Creating Calculated Measures


Advertisements

You can also create calculated measures in OLAP Universes built on OLAP data sources. Following OLAP data sources only support calculated measures −

  • SAP Business Warehouse (BW)
  • MSAS 2000 and 2005

Syntax for calculated measure is shown below −

<EXPRESSION></EXPRESSION>

In UDT, you can use following functions to be used in calculated measure expression −

  • @Prompt
  • @Select
  • @Variable
  • @Where

To create an OLAP Universe, use the following steps −

In UDT, open an OLAP Universe and insert a new measure object in the Universe.

OLAP Universe

Next is to pass the object definition as an XML/MDX expression in Where condition.

Click Parse to review the object definition and fix any errors → OK to save the object definition.

To perform an integrity check, navigate to Tools → Check Integrity. The integrity check validates the XML syntax and any Universe design tool @FUNCTIONS.

Functions

Advertisements