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
Quick Links:
Do you have
an Oracle Question?
Best regards,
Oracle Database, SQL,
Application, Programming Tips
All the site contents are Copyright © www.sap-img.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.sap-img.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.sap-img.com or the content authors.