CustomRollUp or UnaryOperator depending on selection in another Dimension

• nmeseth

  SSC-Addicted

  Points: 427

  More actions

  November 29, 2010 at 4:22 am

  #149418

  I have the following Dimensions:

  DimPeriod

  -- PeriodID

  -- PeriodHierarchies (Parent-Child)

  DimReport

  -- ReportID (Key)

  -- ReportName

  I now want to define the UnaryOperator of the PeriodHierarchies hierarchy to be dependent on the currently selected member of DimReport. Therefore, I introduced a new table

  MapPeriodReport

  -- PeriodID

  -- ReportID

  -- UnaryOp (only 0 or 1 for aggregate and do not aggregate)

  I know that UnaryOperators are static, which lead to me the CustomRollupColumn property. The problem is I cannot figure out how to set the MDX in the column value.

  I added the MapPeriodReport as a new measure group and I am trying to somehow use this value for my dimension roll-up. Strangely, though, when I query the measure UnaryOp, for which a set AggregateFunction to None, I don't see any values for it, although I have selected values for both dimensions DimReport and DimPeriod.

  I am using SSAS 2005. Can someone help me with this? Any help is greatly appreciated.

  Nicolas