Skip to Content
0

How to freeze values of MD with attributes into its copy infoobjects in BW?

Feb 13 at 10:38 AM

46

avatar image
Former Member

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:

  1. Copy of 0IC_01 with 10 infoobjects and 01 MD info object i.e. ZIC_01
  2. Copy of 0MData infoobject with 50 attributes i.e. ZMData
  3. 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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Loed Despuig Feb 15 at 01:52 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 16 at 09:55 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Jan Van Ansem Feb 16 at 12:09 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for reply Jan. Please correct me if I understand wrong.

scenario 1) Make the copy of original master data obj. with time dependent capability. and load master data also like original master data and other objs. map via direct assignment between original and copy cube.

scenario 2) How can I map original master data's attributes to info objects of copy cube?

0