KPI Wizard creates MDX expressions for creating KPIs. To create a KPI:

• Select Type:
  • Percent of Max Child - the denominator is the maximum sibling.
  • Percent of Parent - the denominator is ancestor.
  • Percent of Dimension - denominator is the highest level of the hierarchy.
  • Percent of Total - the denominator is all.
  • Absolute Value - the denominator is a constant number you can specify in "100% Value"
• Dimension - used when Type is Percent of Max Child, Parent or Dimension
• 100% Value - used when Type is Absolute Value
• Green Threshold - percent at which yellow will turn green
• Red Threshold - percent at which red will turn yellow
• Icon Type - type of icon used
• Bubble
• Smiley Face
• Traffic Light
• Diamond
• Square
• Gauge-Profit
• Gauge-Cost
• V ! X
• Enable NonEmpty Crossjoin - will remove members with KPI that do not have any data
• Show Value - will show percent next to the KPI image
• Click OK.