Reading time dependant Master Data

[Former Member]

Hi

I have a transactional data source  0CO_OM_NWA_1 and a cube 0PS_C041.

0PROFIT_CTR infoobject is present in a cube which is a time dependant master data.

In transformation from Datasource to Cube, I join AUFNR(Activity number) of source to 0PROFIT_CTR in cube and say read master data from 0ACTIVITY.

0Activity takes data from AUFNR field and present in cube. Also 0PROFIT_CTR is attr to 0ACTIVITY hence i can read profit center from attr of 0ACTIVITY.

But since 0PROFIT_CTR is time dependant, when i use 0PROFIT_CTR_0BUS_AREA ( the attribute of 0PROFIT_CTR), i alwayas get data according to current truth.

For example, profit center 1915 was in Business area PPMV in 2008 and it moved to Business area PPTR fron 2009 onwards then in my Bex report, I always get profit center 1915 in business area PPTR even if i run the report for 2008.

My requirement is i sould be able to read business area in 2008 and not current truth.

what is the easiest way to achieve this. I dont want to enhance the datasource neither change a cube.Probably something on query level.

[former_member188080]

Hi,

You can use key date as the property of the query ... and additional variable in the selection screen but that will help to certain extent..

the best way is to populate same data at Infoprovider or transaction data level and get it seen at query level..

http://scn.sap.com/thread/1802463

http://scn.sap.com/thread/1651552

http://scn.sap.com/thread/1369989

Thanks and regards

Kiran

[Former Member]

Hi Kiran,

I know the usage of Key date in query but it will show attribute values of only date you have specified.

Isnt it possible to read the fiscal year period  value of every record in bex report at runtime , capture it in a variable and use that value to read te time dependant master data for each and every record.