Script logic to call the values saved in different scope and combination

[BalaValluru]

Hi Experts

In the example shown below, we have two sets of source data and to calculate the logic Total Expenses multiply with Ratios with Product combinations and to post the target with product combination and country

Source Data : 1 Total EXP with the combination of some products having value ex:37000

Source Data : 2 To save the Ratio in BPC. I have taken some dummy members and saved in different scope.

Could you please help me in below logic to call the (source data 2 )[AUDIT].[RATIO] to in to logic which is saved in different scope

• Source Data 1 (scope)

*WHEN ACCOUNT
*IS  TOTAL EXPENSE
*WHEN PRODUCT
*IS ABC
*IS DEF
*IS GHI
*REC(EXPRESSION =(source data 1) %VALUE%* (source data 2 )[AUDITIDM].[RATIO] = Target members)
*ENDWHEN
*ENDWHEN

Thanks

Kishore V

[former_member186338]

I do not understand what do you mean by PRODUCT members:

ABC - A1_123_R - A1_123?????

[former_member186338]

"1_123_R....Dummy member created as Dimension member in Product Dimension to save the Ratios"

Absolutely strange idea!

Also, how "ABC" is related to "A1_123"???

[former_member186338]

Sorry, but what do you mean by this code???

It has no relation to my sample!

PRODUCT =A1_123_RATIO

???

And the rest is also strange!

Once again:

//Scope source data 
*XDIM_MEMBERSET ACCOUNT=TOTAL_EXPENSE // "TOTAL _EXPENSE"?? space inside???
*XDIM_MEMBERSET PRODUCT=A1_123,A1_345 //list of required products

//For each product ratio is stored in [ACCOUNT].[RATIO]
*WHEN ACCOUNT
*IS * //already scoped
  *REC(EXPRESSION=%VALUE%*[ACCOUNT].[RATIO],ACCOUNT=6701000) //6701000 - result account
*ENDWHEN

Result will be written to the same product

What is not clear????

[former_member186338]

P.S. If TOTAL_EXPENSE is parent node then script will be:

//Scope source data
*XDIM_MEMBERSET ACCOUNT=BAS(TOTAL_EXPENSE) // "TOTAL _EXPENSE"?? space inside???
*XDIM_MEMBERSET PRODUCT=A1_123,A1_345 //list of required products

//For each product ratio is stored in [ACCOUNT].[RATIO]
*WHEN ACCOUNT
*IS * //already scoped
*REC(EXPRESSION=%VALUE%*[ACCOUNT].[RATIO],ACCOUNT=6701000)//6701000-result account
*ENDWHEN

[former_member186338]

Sorry, but RATIO_R you have for product A1_123_PROD

And TOTAL_EXPENSE - for another products like AAAA etc

For sure you will have zero result!

And another dimensions are also not matching...

It's hard to understand what do you want to achive, but I will try to propose another script...

[former_member186338]

"Rest of other dimensions are not uncommon and results to post at BAS(all) members."???

Sorry, but unable to understand!

[former_member186338]

Sorry, but I am unable to understand the required logic:

For source You have ALL_CITY and NO_CITY

How do you want to allocate to base members under ALL_CITY??? Based on what???

Looks like it's better to explain required business logic!

[former_member186338]

Requirements:

We have 3 products AAAA, BBBB, CCCC (base or parent??)

On the account TOTAL_EXPENSE (parent?) sum of the mentioned 3 products have to be allocated to products like A1_123_PROD (how to select all products like A1_123_PROD???)

Allocation have to be done using account RATIO for each product like A1_123_PROD.

Result of allocation to be stored in account 6701000

All other dimensions have to be described in details!

[BalaValluru]

Hi vadim.kalinin

Attached results

Thanks

KishoreV

[BalaValluru]

Hi vadim.kalinin

After running the script, results are showing zero values.

Above script we have scoped for Source data 1 table.( Total expenses with product data)

How are we calling Source data 2 table ( Ratios are having with different scope members not are equal to Source Data 1)

Can we use lookup in script to call Ratios (source data 2 table)

Thanks

Kishore V

[former_member186338]

"After running the script, results are showing zero values" - sorry, but I am unable to see what you are doing!

How do you run the script?

What is the script text?

What about log?

What data you have?

Please read:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

[former_member186338]

OK, you have 5 Product members. (ex: A1_123,A1_345)

And in ACCOUNT you have:

AMOUNT - original amount

RATIO - ratio stored

RESULT - target result to be saved

Then the script will be:

*WHEN ACCOUNT
*IS AMOUNT
  *WHEN PRODUCT
  *IS A1_123,A1_345 //list of required products
    *REC(EXPRESSION=%VALUE%*[ACCOUNT].[RATIO],ACCOUNT=RESULT)
  *ENDWHEN
*ENDWHEN

[former_member186338]

P.S. If you want to run this script using DM package then it can be:

//Scope source data 
*XDIM_MEMBERSET ACCOUNT=AMOUNT
*XDIM_MEMBERSET PRODUCT=A1_123,A1_345 //list of required products

*WHEN ACCOUNT
*IS * //already scoped
  *REC(EXPRESSION=%VALUE%*[ACCOUNT].[RATIO],ACCOUNT=RESULT)
*ENDWHEN

My previous code was for default.lgf

[former_member186338]

Correct setup has to be:

1. Only single member for Product

2. Ratio - has to be member of account dimension

3. Target has to be different account then source