Skip to Content
0
Former Member
Nov 01, 2012 at 06:47 AM

Time dependant Master data in report

39 Views

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.