Tag Archives: MDX

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

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

m4s0n501 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), … Continue reading

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

How to get SSAS to return the correct currency format.

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

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

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