This project has moved. For the latest updates, please go here.

Calculated Members on Non-Measure Dimension

Topics: Resolved
Nov 3, 2010 at 3:33 PM


I hope, this is the right corner to place this question:

I downloaded the Extensions and I'm missing the

put an calculated Member on an other than Measure






Nov 3, 2010 at 6:25 PM

I've documented how to add a calculation to a dimension here:

If that's not what you meant to ask, then please clarify your question... I think a few words got lost in your post.

Marked as answer by furmangg on 6/10/2014 at 4:12 AM
Nov 4, 2010 at 10:29 AM

Thanks for your answer, yes that excactly was my question.

After trying around a little I just learned, that you may not

omit the square brackets even if there are no blanks in the names,

e.g.: [Product].[Product Categories].[Bikes].[Road Bikes + 25%] will put

it on produkt dimension, but Product.[Product Categories].[Bikes].[Road Bikes + 25%] (no square brackets)

will automatically put it on measures.

So again, thank you for your answer and for the great tool.



Nov 29, 2010 at 4:18 PM

A question about creating dimensions:

Is it possible to manipulate the dimensions thereby creating new dimensions?

An example: At work, most OLAP cubes have a Year+Month date dimension (now it is 201011). Can I create a new dimension Year (2010) from this?


Nov 29, 2010 at 7:47 PM

Rajjan, that's something your OLAP developers will need to do for you. You can't add new attributes to a dimension via OLAP PivotTable Extensions. You'll need to edit the cube in BI Development Studio.

Or I suppose you could look into PowerPivot if you need more a self-service modeling experience without the help of IT.

Marked as answer by furmangg on 6/10/2014 at 4:11 AM
Nov 30, 2010 at 6:59 AM

OK, that's what I suspected but I had to ask!

Thanks for a great tool anyway!