Skip to Content

time dependent master data in infocube

Hi Experts,

I am using time-dependent master data which is uploaded with its text.

I have created an info cube and query, and Info object is used in it for code value.

I want a text of that code in the query output as per my selection of 0calmonth.

e.g. Info object - ZBM_CODE used in an info cube.

If my selection is - 04.2016 to 03.2017 -> showing latest period text output -> "ABC".

If my selection is - 04.2015 to 03.2016 -> still showing latest period text output -> "ABC" but I want previous text here "XYZ". Is it possible? If yes then how?

Help me to achieve this requirement.

Thanks,

Yogesh Patil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 03, 2017 at 10:07 AM

    Yogesh,

    This work based on what key date you have maintained in the query designer (in the query property section) .You can define a customer variable in the key date to pick up based on your calmonth.

    -Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Gajesh,

      Thanks for your reply.

      Should I need to create a variable in key date and map it with 0calmonth variable?

      And key date variable will be same as 0calmonth var or like 0calday?

      Can you please elaborate this? or if you having any doc regarding this please share.

      Thanks,

      Yogesh

  • Apr 28, 2017 at 04:24 AM

    It's worked using key date.

    Sorry for late reply

    Add comment
    10|10000 characters needed characters exceeded