Using @Functions with Universe Objects

in Articles


@Functions are available in Universe designer and are available in the edit select box of an object.

Following @functions are available in Designer.

  • @Select()
  • @Variable()
  • @Where()
  • @Script
  • @Prompt
  • @Agreegate_Aware

Let learn them one by one.

@Prompt

This function is very useful to create an interactive object which would force user to enter some value for a condition in order to restrict the dataset to be returned by the query.

Prompt functions are generally used in where clause of an object to build interactive filter condition in the report.

The syntax of @prompt function is as below.

@Prompt(‘message’,’type’,[lov],mono/multi,free/constrained/primary_key,persistent/not_persistent, [{'default value':'default key'[,'default value':'defaultkey',...]})

Message: Is the text which would be prompted to user. It should be included in single quotes.

Type: Data type to be returned by function. It can be any one of following.

A: Alphanumeric

N: Number

D: Date

LOV: List of values which would be displayed to end user to chose from. LOV could be hardcode or you can use LOV of an exiting object.

e.g. {‘A’,’B’} or ‘Country\Name’

Mono: User can select only one value from list

Multi: user can select multiple values from list

Free: User can select or enter value.

Constrained: User ,ust select value from the list.

Primary Key: This options needs to be used with free or constrained. When used , user selected values are not used its key values is used from index awareness column.

Persistent: Last user selected value is persistent when report is refreshed.

Defaultvalue:keyvalue: Default values to be presented to user. If you have used Primary Key in function you must specify the key value here.

@prompt(‘Enter value(s) for Customer with A:’, ‘A’,’Customer\CustomerA’, Multi,primary_key,{‘A’:’1’,‘B’:’2’})

@Select

This function is used to reselect the select clause of another object. This function is pretty useful to reuse the existing select clause of another object instead of creating it again. So when original object select clause changes, all other objects would be changed if they are using original objects select clause using this function.

Syntax.

@Select(Classname\Objectname)

@Where

This function can be used to re-use the where clause of another object.

Syntax:

@Where(Classname\Objectname)

@Variable

The @Variable function is used to call the value assigned to variables. This function is generally used in security implementation. You can more information on this function on business objects user guide.

e.g. You variable (‘BOUSER’) will return the name of currently logged in business objects user

 

@Aggregate_Aware()

 

This function is used to define the aggregate awareness and will be discussed in another article.

 

@Script

This function is used to call a VBA macro and works only for desktop intelligence anddesigner and is not advised to use in case of web intelligence. It works only on windows platform.

 

@Script(‘var_name’, ‘vartype’, ‘script_name’)


Previous post:

Next post: