Hi IP Experts,
I have a requirement to get a value from 2 different cubes STORE and MERCHANDISE belongs to a multiprovider.
I want to calculate sales from all my stores and store it in a keyfigure(Store)
I want to calculate contribution of sales for my each store with my merchandise levels(SBU,CAT,GBB) as Total sale of all my stores/each store sale)*Merchendise sale.
DATA D1 TYPE 0INFOPROV.
DATA D2 TYPE ZCATHKB.
DATA D3 TYPE ZGBB1.
DATA D4 TYPE ZPLANT.
DATA D5 TYPE ZSBUH.
DATA STORE TYPE F.
DATA MERCH TYPE F.
*FOREACH D4.
*STORE = STORE+{CY_SMSLS,ZICHOPP1,#,#,D4,#}.
*ENDFOR.
*{ZGRTE_CY,ZICHOPP1,#,#,#,#} = STORE.
FOREACH D4.
FOREACH D1,D2,D3,D4,D5.
MERCH = ({ZCY_SLSXM,ZICHOPP1,D2,#,#,#}/STORE)*{ZCY_SLSA,ZICHMPP2,D2,D3,D4,D5}.
{ZASSRT,ZICHAPP1,D2,D3,D4,D5} = MERCH.
ENDFOR.
ENDFOR.
Thanks in Advance,
Pushpa M