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!

Separate hierarchy loading

Kirill.BoykoMar 12 2008 — edited Mar 13 2008

Hello!

Could anybody help me with following question?

I have MOLAP dimension ITEMS. This dimension constantly (each day) updated with new items. Once a year a hierarchy in this dimension changes. E.G. last year items were arranged using ITEMS_2007 hierarchy and today they are arranged using ITEMS_2008 hierarchy.

Are there any way to separate loading of new MEMBERS and HIERARCHY? I don't what to load each day in 2008 hierarchies for 2007 and 2006.

Are there any way to load (I can create it using AWM) hierarchy manually? Which structures I must fill?

Thank you in advance

Regards,
Kirill Boyko

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2008

Added on Mar 12 2008

#data-warehousing, #olap

8 comments

1,592 views