Accessing Calculation Groups from BI Tools

Consider the following when accessing Calculation Groups from BI Tools:

  • Calculation Groups are presented to the end-user as Dimension Attributes. They may also be organized in folders.
  • Calculation Groups are executed by combining them with the Dimension Hierarchy or Attribute referenced in the Calculations and a set of Measures.
  • Additional Dimensions may be added to the query to see their effects on the calculation for the set of measures.
  • To reduce the number of calculations, use the Filter or Slicer features of the BI tools.
  • Only one Calculation Group may be used in a query at a time. Using more than one Calculation Group will result in either empty cells or an undefined run-time query error.