Tag Archives: MDX

Same members declared in both Sub Select and Where clause of same MDX

Posted on 02/09/2013 by Jens Vestergaard

What to make of it? Currently I am conducting a review on all existing solutions. These solutions have seen their share of developers over the years. Hence there are several “trademarks” to be found. One such trademark threw me off a bit. … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

SSMS Quick Tip

Posted on 23/02/2012 by Jens Vestergaard

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

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

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 , , | 3 Comments

Pct af totalen

Posted on 30/12/2007 by Jens Vestergaard

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