Skip to Content
author's profile photo Former Member
Former Member

Attribute/Hierarchy change run

Hello experts,

i've several navigational attributes in my aggregates.

Does the change run automatically adjust the aggregates ?

or

Should the following be done :-

1> Deactivate the aggregates

2> Execute the change run

3> Activate and fill the aggregates again

If attrubute change run alone is sufficient, then are there any cases when i need to perform all the three steps mentioned above

Best Regards,

Sanjay

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2005 at 07:26 AM

    Hi Sanjay,

    You need to perform the above steps whenever the cube is loaded with new data.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2005 at 07:32 AM

    Hi

    Let me clarify

    The change run will change the existing aggregates when masterdata has been updated. Loading new data into the cube does not require a change run only a roll-up of the aggregates. I.e. the process you describe should never be nessecary.

    regards

    Kristian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks for your response Michael that clarifies my query.

      As for your question on "why are you using time dep. nav attributes and not the historical truth?" - the attribute has not been used as an characteristic in our cubes and its too much of an effort now to go back and add them as characteristic in the cube. And hence we have to report on time dependent navigational attributes :(.

      Regards,

      Sanjay

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2005 at 08:20 AM

    Hmm, time dependant attributes. Well I havent used them in aggregates as you can only have one key date in the aggregate. As far as I know the change run is for changes in masterdata where as the change of the keydate is something else. I really don't know if a change run will change aggregates build on time dependant attributes! But try it out!

    Regards

    Kristian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.