sorting problem in webi

[Former Member]

Hi All,

I have a stored procedure universe. I have a requirement like to show the order how data coming from database.

But at report level it get sorted. I dont want to show sorted data. when I see table values at universe I am getting order as in database

Please help me on this

Thanks

[Former Member · Accepted solution]

BO does show the data as it is in the same order how it comes from database. It won't do sorting automatically.

Check the following possibilites.

1. Check if you have applied any sort order / group by clause in query level

2. Check each column if any sorting applied unintentionally in edit report mode

If you apply group by clause, obviously the query does sorting based on group by fields. Group by clause appears when you add any measure in Edit query panel.

Regards

Gowtham

[Former Member]

can anybody have any idea on this?

any help greatly appreciate

Thanks

[Former Member]

You will need to include a row number in what you are returning from the stored procedure.