Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Models and Aggmaps

403487Apr 1 2008 — edited Apr 2 2008
I have a cube with 5 dimensions running successfully with a model and an aggmap. However, a higher level has now been added to one of the dimensions, and the model modified from:

Dimension dimension
Net_Result = A - B

to

Dimension dimension
Root = Net_Result + C
Net_Result = A - B

I have left the aggmap unchanged:
RELATION this_aw!TIME_PARENTREL(this_aw!TIME_AGGRHIER_VSET) PRECOMPUTE(ALL) OPERATOR SUM args DIVIDEBYZERO YES ....
..
..
..
MODEL model
AGGINDEX NO
CACHE SESSION

However, the aggmap would not compile and gives the following error despite having made the relevant changes to the database and the affected dimension:
java.sql.SQLException: ORA-36910: MODEL can only edit the top level of its matching relation hierarchy.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 180
ORA-06512: at line 1

Would appreciate any advice.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 30 2008
Added on Apr 1 2008
#data-warehousing, #olap
1 comment
1,146 views