Strange behavior when definning a sort on a report

[backhandx]

Hi all,

I developped a simple dimensional report and I defined an ascending sort on a mesure. When I excute the report, it runs forever without any result ( I stopped after 3 hours of processing) but when I remove the sort on the mesure column, the report runs in 3 seconds.

Can anyone have an idea why is this happening?

Thanks in advance

[New_Guy]

Hi,
Are you getting the whole result set in 3 seconds without sorting and which cubes are you using and how big are the cubes and is the sorting done at the grain level?

Good luck
New guy

[backhandx]

Hi,
Are you getting the whole result set in 3 seconds without sorting and which cubes are you using and how big are the cubes and is the sorting done at the grain level?

Good luck
New guy

Yes, I am getting the whole result in 3 seconds without soritng and I am working on DMR.
The sorting is done on the column of a list.

[New_Guy]

That is strange. Can you try creating a query shortcu and then apply sorting on the Data item of the Query short cut. And try to change the processing to database only or vice versa.

Good luck
New guy