I'm not sure if I understand your scenario. What do you mean by FREEZE VALUES OF YOUR MD?
So if you copied your ZMDATA data from your 0MDATA, you will really get BLANK values in your attributes since you did not load yet data in your ZMDATA. Maybe if you forgot the loading part in your masterdata? OR maybe you forgot to tick the attributes in your ZIC_01 but you ticked the attributes in your multiprovider? If that's the scenario, you will really get BLANK values in your query in multiprovider.
Thanks.
Loed
MD Freeze values means :
Yesterday, in original cube 0IC_01's 0MData values are following:
0Calmonth Position 0MData Attr1. Attr2. Attr3 ...........
01.2018 Manager David H#333 NY USA ...........
Now today I need to load all values of cube 0IC_01 in copy cube ZIC_01 including ZMData so value are:
0Calmonth Position ZMData Attr1. Attr2. Attr3 ...........
01.2018 Manager David H#333 NY USA ...........
Next month, in original cube 0IC_01's 0MData values changed and Change Run changed the all records like:
0Calmonth Position 0MData Attr1. Attr2. Attr3 ...........
01.2018 Manager David H#444 NY USA ...........
02.2018 Manager David H#444 NY USA ...........
Now again, I need to load next month values of cube 0IC_01 in copy cube ZIC_01 including ZMData so freeze values are:
0Calmonth Position ZMData Attr1. Attr2. Attr3 ...........
01.2018 Manager David H#333 NY USA ...........
02.2018 Manager David H#444 NY USA ...........
How to do that?
There are two standard scenarios available for this:
You can use time dependent master data, so at query execution time the report user can decide what the reference is for your transaction data (a date from the transaction, the date of running the report, or any other date really).
Alternatively you can add the master data attributes to the cube. When you load the cube, you then also write the master data attribute values to the cube so they are 'frozen in time'.
The first scenario gives you the most flexibility, but you need to think about it a bit more at reporting design time, and potentially train up the business users on this specific functionality.
Add comment