time dependent master data in infocube

[sunil_hirgude2]

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

[former_member186399 · Accepted solution]

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

[sunil_hirgude2 · Accepted solution]

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

[sunil_hirgude2]

It's worked using key date.

Sorry for late reply