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

Calculated Member /Label Filter

Oct 25, 2012 at 12:21 AM

I'm attempting to create a calculated member that have aggregates based on a label. Here is one of the items I have tried:

Aggregate(([Project_Task - All Task Levels].[Task Level 1].[Caption].&[8801]) ,[Measures].[Cost Burd Amt])

Where is "8801" is the label of items I want to aggregate.  Anyone have an idea of the proper syntax. The code above fails returning a "#VALUE" error.

Any assistance would be appreciated.



Nov 13, 2012 at 3:35 PM

Sorry for the delay John.

Have you tried changing the word Aggregate to Sum?

If that's not it, I would capture the MDX query in the MDX tab and then run the MDX query in SQL Server Management Studio. Then if you double click on the problem cell, it will give you the error message explaining what went wrong with the calculation.

Jun 9, 2014 at 12:42 AM
I have added a new feature to see the #VALUE! Error message a few releases ago:
Marked as answer by furmangg on 6/8/2014 at 4:42 PM