Strategy ONE
MDX Cell Formatting
With the MDX Cell Formatting VLDB property, you can specify for the metric values in MicroStrategy MDX cube reports to inherit their value formatting from an MDX cube source. This enables MicroStrategy MDX cube reports to use the same data formatting available in your MDX cube source. It also maintains a consistent view of your MDX cube source data in MicroStrategy.
Inheriting value formats from your MDX cube source also enables you to apply multiple value formats to a single MicroStrategy metric.
This VLDB property has the following options:
- MDX metric values are formatted per column (default): If you select this option, MDX cube source formatting is not inherited. You can only apply a single format to all metric values on an MDX cube report.
- MDX metric values are formatted per cell: If you select this option, MDX cube source formatting is inherited. Metric value formats are determined by the formatting that is available in the MDX cube source, and metric values can have different formats.
For examples of using these options and steps to configure your MDX cube sources properly, see the MDX Cube Reporting Help.
Levels at Which You Can Set This
Database instance and report