Writen by
Devil
3:18 AM
-
1
Comments
What is a Global Variables ?
A completely new type of variables called the Global Variables is available in OBIEE 11.1.1.9 . It can be defined in the context of an analysis and can be used in other analysis as well. It is very useful to do some intermediate reusable calculations in between different analysis.
Global Variables can be created from the Criteria Tab on Column Formula , Under Variables select Global Variable, an existing Global Variable can be used or a new can be Created here.
Now how to Use a Global Variable ?
To reference a global variable you need to use the fully qualified name including the context as mentioned below: @{global.variables.variablename}.
Note: To manage Global Variables Manage Global Variables privilege is required.
What are the uses of a global variable vs. a saved custom column? Under what circumstances should we select one of those objects vs. the other?
ReplyDelete