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

Aggregates with Attribute Change Run and Master data

Hi !

I created Aggregate which includes Master Data such as Customer , Customer Number , Material , Material Number.....

It also contains navigational attribute and hierarchy...

Now we all know that if Master data and Hierarchy changes frequently(or some new values are added or new attributes are added etc.) we want to see the respective change in Aggregates too

So just Rolling up aggregate will not help.

We need to apply Attribute Change run for this purpose, to aggregates..

Now the question is HOW TO APPLY ATTRIBUTE CHANGE RUN to aggregates?

How to automate this process with Process chains..?

If i create Aggregate on Master Data CUSTOMER NO., DOES IT AUTOMATICALLY INCLUDE THAT AGGREGATE IN ATTRIBUTE CHANGE RUN FOR THAT CUSTOMER NO. PROCESS CHAINS ? Yes or No..........

(What i mean to say is if there is Attribute Change Run for Customer No. and if this is in Process chains specially created for Customer Number , than as aggregates are created on Customer No., does i t automatically applies and make changes to Aggregate too, or do we hvae to create special process chian for it ?)

Please reply asap ? its urgent

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 10:56 AM

    Hi,

    in Monitoring tab u can find options for Attribute Change Run.

    In Process Chains in other bw processes u have option Attribute Change Run

    u can use this.

    https://www.sdn.sap.com/irj/sdn/advancedsearch?query=attributeChangeRun+&cat=sdn_all

    https://www.sdn.sap.com/irj/sdn/advancedsearch?query=attributeChangeRun+usingprocess+chains&cat=sdn_all

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:47 PM

    Kartikey,

    You do not apply attribute change run to aggregates. Suppose, you have a master data object that is used in your infocube. When the master data attribute change run for this object takes place, it will also adjust the corresponding 'SID' links. As such, you cannot do a roll up during the attribute change run of this object wherever this object is used in a cube.

    You CANNOT create AGGREGATES on master data. Because, AGGREGATES are indexes (baby cubes) on a cube. But, you can include AGGREGATE ROLL UP in a transaction data process chain as an end step.

    hope this helps.

    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.