REPOTUNG historized masterdata

[Former Member]

Hello,

having a historized masterdata InfoObject I want to set up

a BEX Report showing the InfoCube data according to "historic truth", which means, any masterdata dataset

according to the date in the InfoCube.

Does anyone know how to set up Querry like that?

Thank You

Martin Sautter

[Former Member · Accepted solution]

Hi,

if i mistaken , you want to use the time dependent variable?if you want to do like that you can take the time characteristics system variable depending upon your use like calday,calmonth,calyear...

could you give ur report scenario clear i can try for response...

regards,

sekhar.

[Former Member · Accepted solution]

Hi Sekhar,

the following example will give a detailing:

Masterdata InfoObject CARRIER_ID with historized CARRIER_NAME - CARRIER_NAME changs over time :

CARRIER_ID

0DATETO

0DATEFROM

CARRIER_NAME

InfoCube BOOKING:

CARRIER_ID

0CALDAY

FIGURE_PRICE_PAID

Desired Report:

FIGURE_PRICE_PAID over 0CALDAY over CARRIER_NAME

with CARRIER_NAME at time of 0CALDAY.

Is this solved with a time characteristics system variable - and how implemented in BEx ?

Thank You for Your help.

Martin

[former_member183777 · Accepted solution]

You can run the report as of a given date using the Key Date variable of the query, but then it will pull the carrier name only as of the that one key date, which will not solve your problem.

To get the desired result you have to bring carrier name into the cube and during the load process capture the value as of 0Calday and store it in the cube.

You can also use a virtual characteristic, but in the scenario given, that doesn't buy you any thing.

[Former Member · Accepted solution]

Hello Vineet,

this basically means to set up another

Character in the cube which i wanted to avoide. The Characteristic must be designed as a compound element

0calday / Carriername and fileed with an Lookup at

loading time.

This gives a lot of redundant data ( and codeing)

and only because in BEx an otherwise simple join between

two masterdata dimension ( Time and Carrier) is not possible.

For me the basic conclusion is that with BW a

reporting accroding to historic state of masterdata

isn't possible easily. A disadvantage towards

"hand made" Datawarehouses and other solutions.

Thank You

Martin Sautter