Skip to Content
author's profile photo Former Member
Former Member

Reading time dependant Master Data

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 07, 2012 at 11:08 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.