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.

 

John

Coordinator
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.

Coordinator
Jun 9 at 12:42 AM
I have added a new feature to see the #VALUE! Error message a few releases ago:
https://olappivottableextend.codeplex.com/wikipage?title=View%20Error%20Message&referringTitle=Home
Marked as answer by furmangg on 6/8/2014 at 4:42 PM