1

I am trying to create a common named set with fixed members so it can be used in multiple calculated members. But for some reason, it's failing. I am new to MDX scripting. Let me know if there is an issue here.

Aggregate({[TT Collection].[TT Type].&[A]
,[TT Collection].[TT Type].&[O]
,[TT Collection].[TT Type].&[I]
,[TT Collection].[TT Type].&[J]})
Arjun
  • 1,049
  • 6
  • 23
  • 37

1 Answers1

1

If you create the set before Aggregating does it work?

WITH
SET [MYSET] AS
    {[TT Collection].[TT Type].&[A]
    ,[TT Collection].[TT Type].&[O]
    ,[TT Collection].[TT Type].&[I]
    ,[TT Collection].[TT Type].&[J]}
MEMBER [SOMEdim].[SOMEhier].X AS
    AGGREGATE([MYSET])
...
...
whytheq
  • 34,466
  • 65
  • 172
  • 267
  • 1
    @whythq Thank you for the answer. I too tried like this after some research and it worked. – Arjun Sep 01 '20 at 14:16