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
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
Quote from: New_Guy on 12 May 2017 09:35:11 AM
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.
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