cancel
Showing results for 
Search instead for 
Did you mean: 

Time Dependent Navigational Attributes in Query

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Thanks...

Shambhu

Former Member
0 Kudos

Hi,

Thanks for the update.

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

Thanks