Sorting calculated members - SSAS 2012

• tej3as

  Ten Centuries

  Points: 1040

  More actions

  July 17, 2014 at 1:04 am

  #310004

  Hi ,

  I am using SSAS 2012 cube, and in Calculations Pane --> Script View

  I am trying to "sort" the calculated members but am not able to sort correctly still.

  I have tried adding in "script view" as below :

  CREATE MEMBER CURRENTCUBE.[Measures].[Member_1]

  AS '([Measures].[Member_1]/[Measures].[Total])*100',

  VISIBLE = 1 , SOLVE_ORDER = 1, DISPLAY_FOLDER = 'FolderA\SubFolder';

  CREATE MEMBER CURRENTCUBE.[Measures].[Member_2]

  AS '([Measures].[Member_2]/[Measures].[Total])*100',

  VISIBLE = 1 , SOLVE_ORDER = 2, DISPLAY_FOLDER = 'FolderA\SubFolder';

  CREATE MEMBER CURRENTCUBE.[Measures].[Member_3]

  AS '([Measures].[Member_3]/[Measures].[Total])*100',

  VISIBLE = 1 , SOLVE_ORDER = 3, DISPLAY_FOLDER = 'FolderA\SubFolder';

  but it is still not sorting in the FolderA\SubFolder as per below:

  Member_1, Member_2, Member_3... (since my sort orders for these are correspondingly 1,2,3 as highlighted in Bold)

  Am I doing it correctly?

  Also, I have multiple folders like above where in each folder I want to sort as per the way I want by assigning SOLVE_ORDER from 1,2,3,4,5,.... where 1 being the highest (to display on top) and 5 being the lowest (to display at last) in the corresponding folders, while browsing the cube.

  To add note, I am having 3 folders created (Display Folder) for calculated members (measures) and I am trying to do sorting first in FolderA\SubFolder as I mentioned above.

  Do I need to add SOLVE_ORDER in the other 2 folders' calculated members also; then only it will be effective ??

  As of now, I am doing SOLVE_ORDER only for calculated members of FolderA\SubFolder

  But am not able to get it sorted properly while browsing the cube

  Pls advise

  Thanks