- SAP Universe Designer Tutorial
- SAP Universe Designer - Home
- SAP Universe Designer - Introduction
- SAP Universe Designer - Object Types
- SAP Universe Designer - User Interface
- Creating, Editing and Saving
- Creating Parameters
- Creating Schemas
- Table Browser
- Using Derived Tables
- Using Formula Bar
- Universe Building
- List of Values (LOVs)
- OLAP Data Sources
- Using Connection Wizard
- Creating Calculated Measures
- Aggregate Awareness
- Deploying Universe
- Managing Access of Universe
- User and Groups
- UDT vs. IDT Comparison
- unv File to unx File
- Job Responsibilities
- SAP Universe Designer Resources
- SAP Universe Designer - Quick Guide
- SAP Universe Designer - Resources
- SAP Universe Designer - Discussion
Creating Calculated Measures
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.
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.
Advertisements