Order By Dimension Members

FAQ

Profile

Order By Dimension Members

Database Help (Home) -> OLAP

Next: remove response body from imap email

Author

Message

Prasad

External

Since: Feb 09, 2005
Posts: 33

(Msg. 1) Posted: Mon Mar 16, 2009 5:50 pm Post subject: Order By Dimension Members Archived from groups: microsoft>public>sqlserver>olap (more info?)

Hi, I got the Top 5 performing states by Sales. select [Measures].[Sales] on columns, TopCount ([State].[State_CD].children, 5, [Measures].[Sales]) on rows from [Sales] where [Time].[Year].&[2008] Result is: New York Connecticit Boston Washington Alabama >> Stay informed about: Order By Dimension Members

Display posts from previous:

Related Topics:

Changing the order of Dimension Attributes - Hi There, I have a dimension with the following attributes Family Group Line Type Of course, when browsing the dimension, they are appearing alphabetically. Is there any way to change the order to something like: Family Type Group Line Any help..

Calculated Members - Is it possible to store calculated members physically in cube? or is there any way to achieve this.

Total sum on calculated members - Hi I have build a cube with avarage values on measure, but I need on the Total cell of dimension the sum of each single average value like example ex1. ex1. C C1 C2 C3 C4 C5 Total R1 1 3 4 2 1 11 R2 5 2 4 3 6 20 I try to do..

Writeback and Custom Members - Anyone know if it is possible to support writeback (via Update Cube) on Custom Members? I want to use a custom member to allow users to create forecasts, then allow individual cells to be updated using writeback.

calculated members on dimensions? - Hi, I was trying to implement my own time intelligence in SSAS, not through the wizard. i created my own dimension ('time calculations') and put some calculated members on it (implementing Year-To-Date and other expressions in MDX) i have linked this ne...

	Database Help (Home) -> OLAP	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum