Hi
Scenario :
User need freeze data of Info Cube 0IC_01 into its copy Info Cube e.g. ZIC_01 from onward
i.e. When master data update Cube 0IC_01 shows values according to updated master data and its copy Cube ZIC_01 show the freeze values of every data load into copy cube.
Question : How to freeze values of MD with attributes into its copy infoobjects?
Cube1: 0IC_01 having 10 infoobjects and 01 MD info object with 50 attributes for example: 0MData and its daily update.
Cube2:
- Copy of 0IC_01 with 10 infoobjects and 01 MD info object i.e. ZIC_01
- Copy of 0MData infoobject with 50 attributes i.e. ZMData
- Direct assignment between info cube 0IC_01 and info cube ZIC_01
Problem:
All the attributes of copy Master Data infoObject i.e. ZMData are blank
e.g. In original master data object (0MData)
0MData Attr1. Attr2 ...........
David H#333 NY
In copy master data object (ZMData)
ZMData Attr1. Attr2 ...........
David Blank Blank
Thanks
ISKhan
3 Answers
-
Feb 15, 2018 at 01:52 AM
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
Add comment
-
Feb 16, 2018 at 09:55 AM
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?
Add comment
-
Feb 16, 2018 at 12:09 PM
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
Add comment