Skip to Content
0
Former Member
May 21, 2009 at 05:52 AM

ip function

23 Views

We are having 100 articles out of which 80 are already existing articles and 20 are new. All these 20 new article are enabled in my query with u201CView Master Datau201D option i.e., no data for this new articles exists in my cube. Now I need to populate transactional data for this new articles by using the below logic.

If sales value(zsales) for 80 articles is 5lakhs. User wants to plan sales value (zplansales) for all 100 articles (old and new articles) as 10 lakhs. Here difference is 10 lakhs u2013 5 lakhs = 5 lakshs(zdifsalesvalue). This 5 lakhs needs to be distributed equally among all 20 new articles.

Is it possible with distribution by reference or key. Or we need to with Fox Coding.