Time dependant Master data in report

[Former Member]

Hi All,

I have Employee time dependant master data. The records in employee master data are as below.

Employee     Valid To         Valid From             User Name

1234             31.08.2012      01.01.1000              Deepak

1234             31.12.9999      01.09.2012              Deepak Chavan

User name is navigational attribute in the master data.

Now when I run the report with 0calmonth= 08.2012  I am expecting report to show Employee user name as " Deepak" but it it showing the

latest occurence " Deepak Chavan".

when I run the report with 0calmonth= 09.2012 user name is coming as "Deepak Chavan".which is true.

Even when I do listcube , Navigational attribute value for User name is " Deepak Chavan" for all calmonths data in cube.

Cube Data:

Employee    Calmonth       0Employee_user name    

1234              08.2012      Deepak Chavan    

1234              09.2012      Deepak Chavan 

1234             10.2012       Deepak Chavan  

How to show user name in the report with time dependancy?

Regards,

Deepak chavan.

[Former Member]

Hi Deepak,

I believe this is the innate behavior of the time-dependent master data. Not only for displaying, but also for deletion.

Try deleting first record, it'll automatically delete the latter also.

Br,

H