simple advantage of @functions

[former_member201264]

Hi,

please let me know how the simple advantage of @functions and more clearly about @aggregate_aware fucntion.

Sreeni

[Former Member · Accepted solution]

@Aggregate_Aware is used when you have summary tables that you would rather take the data from. If you have monthly, weekly and daily fact tables, you would obviously want to go to the monthly table first as it will be the smallest. So your function would be @Aggregate_Aware(monthlyfact.value, weeklyfact.value, dailyfact.value). You also need to understand how to define aggregate incombatibility using the aggregate navigation functionality. There is plenty of help text on this

@Prompt() allows you to request user input and use the prompt responses to filter data. Again, the system help covers this in more detail

@Script() is a Deski only function that will be less useful in the future and doesn't need covering here.

@Select() allows you to insert the name of an object to use its SQL - it saves you maintaining the same SQL code in two places in the universe.

@Variable() allows you to return various bits of information and is most commonly used in row level restrictions with the @Variable('BOUSER') function used to restrict rows to those that the logged in user is entitled to see.

@Where() is like @Select() but it is recommended to avoid where clauses in objects wherever possible because they restrict every query that you use them in. Two objects of Sales TY and Sales LY with where clauses would cancel each other out and you would get no data back because it would be looking for rows where the transaction occured in two different years!

If possible, please get on a universe design course - they are the best way of learning the tool.

Regards,

Mark

[Former Member]

@fucntions are very powerful in Universe desinger.

Here are...

1. @select --- Uses a mentioned object definition forexample: @select(xyz) in object ABC definition. The xyz object definition will be taken as ABC object definition.

2. @where --- same as @select but the definition will be frin Where clause of object

3. @Aggregatre_Aware() --- is baiscally for when you have detailed and aggregate facts in universe designer. It decides from which table the data has to be retrieved.