Using @Select function
You can define any new object by entering its definition (MDX) or by referencing an existing object by using @Select function.
We recommend using @Select as much as possible rather than the object definition for multiple reasons:
- Life Cycle Management only ensure integrity with generated objects not with objects created by a user: @Select always guarantee the validity of the object
- @Select allow to define a level or part of it and to be reuse anywhere in the universe
@Select can be used anytime in:
- Objects definition
- Details definition
- Measures definition
- Pre-defined filters definition
- Where clause of Objects / Details / Measures
- Calculated measures
Using @Prompt function
@Prompt is a way to define parameters in the universe that will let users to choose among a list of values/members one or multiple values.
A prompt can be mandatory or optional, it can be also contrained (users have to select values form the list of values) or free (users can enter manually a value).
A prompt can also be base on a static list of values defined in the universe.
Another prompt parameter can also keep or not the last values selected by the users.
@Prompt can also be defined with default values.
Those parameters can be selected at query time by users to restrict the data to be retrieved: the answers to these parameters can be mandatory or optional.
Last these parameters can also be automatically added to the query with no user intervention: they behave like SAP variables (mandatory filters).
We recommend using widely @Prompt in universes because they provide a lot of flexibility when building reports, queries, analysis or dashboards and also they are used to filter the data coming from OLAP data source.
@Prompt can also be used for:
- Choosing dynamically a measure
- Choosing dynamically a hierarchy level
- Choosing dynamically a dimension and a hierarchy level
- Enter a value for:
- Select a relative position from a current member: Lead or Lag functions
- Use to retrieve partially members based on a top/bottom selection: Rank function
- Select prompt operators such as: equal, not equal, in list, etc.