Latest News

Sunday, July 5, 2015

OBIEE Global Variables (New Feature in OBIEE 11.1.1.9)


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.



  • Google+
  • Pinterest
« PREV
NEXT »

1 comment

  1. 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