Dates in same row in BEx

[Former Member]

Hi Guys,

I have below requirement, I tried with constant selection, its working but it is impacting query performance.

Please let me know any other options to achieve this.

Existing
	Created Date	Changed Date	Activity Date
User1	10/9/2014
User2		10/9/2014
User3			10/9/2014
Expected
	Created Date	Changed Date	Activity Date
User1	10/9/2014	10/9/2014	10/9/2014
User2		10/9/2014	10/9/2014
User3		10/9/2014	10/9/2014

Thanks,

Suri

[Former Member]

btw, I used replacement path variable to convert date to measure.

[sateesh_kumar1]

Hi Suresh ,

what is condition to populate same date for all users ?

at any instance only 1 changed date/Activity date will populate to all users.

You can write =max/min(activity/changed) in report in webi , if only one date populates in data for all users.

[Former Member]

Hi Sateesh,

Actually i need to compare 3dates for each user, if all are same, then put counter 1.

To compare the dates, all dates should be in single row, so that condition will satisfy.

3dates can be different also, in that case i do not need counter as 1.

Thanks.

[former_member209606]

Hi,

Suppose  all the user have different date values mean your expected  output details & existing output details are same or differ??

Regards

Sureshkumar C

[Former Member]

Hi Suresh,

if different dates then also it should show in same row.

I achieved this using constant selection, but want to know any other alternative solution.

Thanks & Regards,

Suri