Tag Archives: MDX

SSMS Quick Tip

Posted on 23/02/2012 by Jens Vestergaard
Share

If you ever need to test Analysis Services roles, you can easily do so either by browsing the cube or by means of a query. When browsing a cube through SQL Server Management Studio (SSMS) or Bisuness Intelligence Developer Studio (BIDS), you … Continue reading →

Posted in Programming | Tagged , , , , , , , , | Leave a comment

How to get SSAS to return the correct currency format.

Posted on 09/05/2011 by Jens Vestergaard
Share

Although setting the language and collation correctly, it’s not easy to see why a specific MDX would not return the right formatting, in regards to monetary, thousands seperator etc. There is however a way of forcing the language, through a … Continue reading →

Posted in Programming | Tagged , , , | 2 Comments

MDX Query using other hierarchy in same dimension as in slicer

Posted on 17/04/2011 by Jens Vestergaard
Share

The other day a coworker of mine presented me with a problem in one of our solutions. His basic pain was, that the front-end of the application only allowed for one dropdown containing whatever dimension was set up to be … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

Pct af totalen

Posted on 30/12/2007 by Jens Vestergaard
Share

Et eksempel på hvordan man kan beregne pct. af totalsalg og pct af salget på niveauet over det aktuelle. WITH MEMBER [Measures].[Pct of total] AS ‘SUM( {[Product].CurrentMember}, [Measures].[Unit Sales]) /SUM( {[Product].DefaultMember}, [Measures].[Unit Sales])’, FORMAT_STRING=’#0.00%’ MEMBER [Measures].[Pct of parent total] AS … Continue reading →

Posted in Programming | Tagged | Leave a comment

Kumulative værdier

Posted on 17/10/2007 by Jens Vestergaard
Share

Her ses et eksempel på hvordan man beregner kumlative værdier over en periode WITH  MEMBER MEASURES.[Sales To Date] as ‘         SUM( {[Time].CurrentMember.Level.Members}.Item(0)         : Time.CurrentMember,[Measures].[Sales Count])’  MEMBER MEASURES.[Sales Year To Date] AS ‘         SUM(YTD([Time].CurrentMember),[Measures].[Sales Count])’  MEMBER MEASURES.[Sales Quarter To Date] as … Continue reading →

Posted in Programming | Tagged | Leave a comment