Using sorting or order by in cubes

[SP1709]

Hi,

I need to provide sorting for dimensions in my cube.
I am having three columns in my dimension table
StrID Strname StrOrder

In cube i need to use Strid for all aggregations and all, strname to be displayed to user and Strorder for ordering the dimensions.

I have such corresponding order fields for all the dimensions in the cube.

Please let me know if there is any way to acheive this

Thanks,
SP

 

[MDXer]

in the dimension editor on the property pane there is an order by property that you need to specify your sort column. You may need to bring the sort column into the cube as a member stribut to accomplish this.

Sorry it has been a while.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[SP1709]

Hi,

Thanks for replying. I have got a direction from your previous mail to proceed but not the solution yet.

For cube dimension there are two member attributes Member Key column and Member Name column.
I have set StrID as Member key column(as StrId is the primary key column) and Strname as Member Name column.
So whats needs to be done for StrOrder. Is there any other member attribute which can be set to strorder

Please help

SP