Skip to Content
0
Former Member
Jul 09, 2008 at 06:44 PM

Reporting the latest of Valid from and Valid to record

78 Views

Hello all,

I have a requirement, I have employee data in one cube and in another cube I have employee past employement history data. We are reporting by creating infoset over the two.

The second cube has information as to Employee A was employed before at company ABCD from jan 2003 to dec 2003 and at company XYZ from jan 2004 to feb 2005.

Now we want to run report saying show me all the employees where previous work history has XYZ as their latest employment, so how do we achieve this. We have created a variable for Company at the first selection screen but how do we compare the dates like employee A should be reported since that was his last employment.

Can some one help me.

Thanks in advance,

Kiran