Data not sorting in Information Design tool Queries

[Former Member]

Hi ,

I have a Universe built on top of SQL Server with around 10 tables.

The data in IDT Queries is not getting sorted when sorting is applied and this happened only after setting the Join_By_Sql to yes in Data Foundation properties. If it is set to No, data is sorted without any issues.

The reason I'm using Join_by_Sql option is my query script is generating two queries with full outer join. In order to synchronize these two queries I've set this option.

Please advise .

Thanks

John

[Former Member]

Hello John,

For testing purpose, can you please test the behavior in UDT to see if the reports fetch data in the sorted order based on .unv. If results are as expected in this workflow, I suggest you to raise an incident with SAP.

Thanks,

Madhumitha

[Former Member]

Hi there,

Did u find any solution.

A year later i am facing the same situation

Can u share the solution if u found it?

I have even used ORDER BY clause in the data foundation.

Thanks...