Skip to Content

Use Universe Designer functions in OLAP universes

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:
    • Computations
    • 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.
1 Comment
You must be Logged on to comment or reply to a post.
  • i have a question related to the functions you have defined in document “OLAP universes best practices”, for YTD. that never worked for me as

    “<EXPRESSION>SUM(YTD([0CALMONTH].CurrentMember), @Select(Key Figures\Shipped Quantity in Gals)))</EXPRESSION>”


    “<EXPRESSION>SumYTD([0CALMONTH].CurrentMember), @Select(Key Figures\Shipped Quantity in Gals))</EXPRESSION>”

    thanks. MAT.