This project has moved and is read-only. For the latest updates, please go here.


Jan 20, 2014 at 1:50 PM
Hi all,
Does anyone know if the Extensions can refer to a dimension instead of a measure? And if so what the syntax is. Rather speculatively I tried [dimension].[field name], however this was a bust and I am no SQL expert.

Any advice much appreciated.

Jan 20, 2014 at 6:01 PM
Jan 23, 2014 at 11:14 AM
Hi, thanks for that. Hoping I can pick your brains further with an example and you can tell me if its even possible?

I am basically trying to assign values to certain words in a dimension field.

Basic syntax that does not work is as follows:


Any guidance much appreciated.


Jan 23, 2014 at 4:01 PM
Without knowing the names of your dimensions and dimension attributes it is hard to say. Here is a guess assuming your dimension is called Product and your dimension attribute is called Colour:

IIf([Product].[Colour].CurrentMember is [Product].[Colour].&[Green],1,0)

This question is probably better for the SSAS forums since it is a basic MDX question and not specific to my addin:
Marked as answer by furmangg on 6/8/2014 at 4:29 PM