OLAP Miner User's Guide
OLAP Miner provides the Deviation Detection wizard to help you create a
deviation detection definition. This definition determines how and what
portion of the OLAP cube will be analyzed for deviations.
Before you create a deviation detection definition, read the following
requirements and restrictions.
The following requirements apply to creating deviation detection
definitions:
- Determine which member that you want to search for deviations and select
that member as Member Only.
Typically, this member is from the Measures or Accounts dimension.
- Ensure that you use loaded and calculated OLAP cubes for deviation
detection definitions.
- Select members from dimensions that use either the addition operator (+)
or the no-consolidation operator (~).
- Ensure that the OLAP cubes have a sufficient amount of accurate data at
the lowest levels of the dimension hierarchy. If the subcube contains
very little data, the mining results might be less useful.
OLAP Miner calculates values by starting from level zero, not from the
first generation. For example, if you select Member and Descendants for
an entire year to be calculated in a deviation detection definition, OLAP
Miner first calculates for deviations by scanning the values for January,
February, and March.
- Select label-only members as Member Only.
The following restrictions apply to creating deviation detection
definitions:
- Avoid members that use calculation scripts unless all the values in the
subcube that you select are additive. For example, the parent member
values must be the sum of all child values.
- If you select a shared member, you are prompted to select the shared
member's counterpart base member that has the same name, but is not
tagged as shared.
- If you select a member with a non-additive associated formula, OLAP Miner
performs the deviation analysis only on the lowest level of data.
- Some members of a cube might be excluded because of their position in
their dimension's hierarchy. For example, a member might be
excluded because it falls within a non-additive part of the hierarchy.
See the OLAP Miner online help for information about how to start the
Deviation Detection wizard to find deviations in your OLAP cube.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]