I have a normalized data base.
Now I have created a dimension using certain tables and defining levels in the dimension using certain columns in those tables. say for eg I created a dimension using courses table with course_id as a level.

Now if I want to create another dimension curriculum with course_id being a level of the dimension then oracle is posting an error saying that more than dimension can not be created on a single column.

Rajeev

I think this is your design issue because oracle will not allow you to define a level (the column of a particular table i.e. in your case course_id) in more than one dimension. What you can do is merge these levels in single dimension or you have to use that
column from some other table. You have to decide and make those changes accordingly in design.

Gairik Chakraborty

Thanks for the answers that you have provided me with and Gairik thats exactly what I did to solve the problem. I tried to merge the dimension levels and created one dimension that has multiple levels and that has solved my problem.

Rajeev

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips