April 29, 2009 at 7:13 am
why SSRS not maintaining the sort order on the cube data while Office Excel and procalrity maintain the sort order
April 30, 2009 at 8:38 pm
can you provide more information as to what you are seeing? if you run the query in the dataset is the data returned as you would expect it? If you are referencing hierarchies the results could potentially be organized a little differently since SSRS has to return all levels of the hierarchies and flattens them out to be able to preserve the hierarchy information. would definitely need more information in regards to your MDX query, what you are seeing, and how you are trying to use the data in the report.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 1, 2009 at 2:10 am
For the SSRS report I am using the following MDX query
SELECT NON EMPTY { [Measures].[SLA Value] } ON COLUMNS, NON EMPTY { ([Credit Note Date].[Fis Month Name].[Fis Month Name].ALLMEMBERS * [Credit Note Date].[Fiscal Year Desc].[Fiscal Year Desc].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Sentinel DW] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS.
But when executing this MDX query in Analysis Service Server/SQL Server Management Studio I am getting the Correct Order that is Fis Month Name from APRIL to March. Look at the figure below.
But the SSRS Report from the above query ordered by the alphabetical order of Fis Month Name.
ie APRIL,AUGUST,DECEMBER,FERUARY,JANUARY,MARCH,NOVEMBER,OCTOBER,SEPTEMBER.
Look the at the SSRS report below
May 1, 2009 at 5:19 am
Your images did not come through. When you execute the query in the dataset does it return the results as expected? If that does then you probably need to look at your report layout as far as the data region that you are using to see how the data is being sorted differently. Are you using a table, matrix, list...what type of grouping, sorting, etc. is being done on the data region.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply