MDX Add Fake Measure

MDX Add Fake Measure is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

It is a common practice to include both attributes and metrics on an MDX cube report. However, MDX cube reports can also contain only attributes to review attribute information. If this type of MDX cube report accesses data that is partitioned within the MDX cube source, the report can require additional resources and impact the performance of the report. To avoid this performance issue, the MDX Add Fake Measure VLDB property provides the following options:

• Do not add fake measure to attribute-only MDX report: MDX cube reports that only contain attributes without any metrics are processed as normal. This can cause additional processing to be required for this type of MDX cube report if it accesses data that is partitioned within the MDX cube source. This is the default option for SAP and TM1 MDX cube sources.
• Add a fake measure to an attribute-only MDX report: MDX cube reports that only contain attributes without any metrics also include an additional structure that acts as a metric, although no metrics are displayed on the report. This can improve performance of MDX cube reports that only contain attributes and also access data that is partitioned within the MDX cube source. This is the default option for SSAS and Essbase MDX cube sources.

Levels at Which You Can Set This

Database instance and report