Not aggregatable measure referenced by hierarchy

81 Views Asked by At

I have measure which holds dedicated value for each item in hierarchy level. Can you help me how can I design this measure to avoid aggregations for each item across all children items?

I tried to do something like this, but I did something incorrectly, because Generate function in this case returns too many items.

SCOPE 
  (
    [Measures].[Test]
   ,[Organization Structure].[Parent Id].MEMBERS
  );
  This = 
      [Measures].[Core Totals Target]
    - 
      Sum
      (
        Generate
        (
          (EXISTING 
            [Organization Structure].[Parent Id].MEMBERS)
         ,Descendants
          (
            [Organization Structure].[Parent Id].CurrentMember
           ,1
           ,SELF
          )
        )
       ,[Measures].[Core Totals Target]
      );
END SCOPE;

Do you have an idea how to solve this issue?

1

There are 1 best solutions below

2
On

Not too sure of the purpose of Generate within your script. It looks like it is doing the same as this:

SCOPE 
  (
    [Measures].[Test]
   ,[Organization Structure].[Parent Id].MEMBERS
  );
  This = 
      [Measures].[Core Totals Target]
    - 
      Sum
      (
         Descendants
          (
            [Organization Structure].[Parent Id].CurrentMember
           ,1
           ,SELF
          )
       ,[Measures].[Core Totals Target]
      );
END SCOPE;