Time Dependent Navigational Attributes in Query

[Former Member]

Hi,

Location & Job are the Time Dependent Navigational Attributes of an Emp No and

Created a Info Set (outer Join) based on Emp No and DSO....

Created a Query based on the infoset and the Location * Job are Free Chars in the report

In the query property setting entered KEYDATE as 31.12.999

When i executed report and drilldown on Job or location it is displaying me 2 records for each employee one with Blank and the other with information.....

It should display only one record..most recent record avaliable in Emp master data

Where was i doing wrong

[Former Member]

Try the same report with inner join. Also, in the infoset, for 0EMPLOYEE infoobject, check these two attributes.

Thanks...

Shambhu

[Former Member]

Hi,

Thanks for the update.

I can't do a innerjoin as per my requirment it should be a outer join

Thanks