Translate

Tuesday, 6 March 2012

Variables available in OBIEE 11.1.1.6


ScopePresentation VariableExample
systemproductVersionsystem.productVersion = 11.1.1.3 (Build 090619.0110.000)
systemcurrentTimesystem.currentTime = 6/29/2009 7:35:59 PM
sessionlocalesession.locale = en-us
sessionlanguagesession.language = en
sessionrtlsession.rtl = false
This indicates whether the language selection in the Login page is a right to left language. For example, if the language selection is Hebrew, then this variable returns true.
sessiontimeZonesession.timeZone = (GMT-06:00) Central America
sessiontimeZone.idsession.timeZone.id = (GMT-06:00) Central America
This returns a value that is not localized.
sessiontimeZone.namesession.timeZone.name = (GMT-06:00) Central America
This returns a localized value.
sessiontimeZone.valuesession.timeZone.value = (GMT-06:00) Central America
This returns a localized value.
sessionloginTimesession.loginTime = 6/29/2009 7:12:01 PM
sessionlogoutTimesession.logoutTime = 6/29/2009 8:02:01 PM
sessionlastAccessTimesession.lastAccessTime = 6/29/2009 7:35:59 PM
sessioncurrentUsersession.currentUser = Administrator
sessioncurrency.namesession.currency.name = $ English - United States
sessioncurrency.symbolsession.currency.symbol = $
sessioncurrency.userPreferencesession.currency.userPreference = Global Currency 2
useriduser.id = Administrator
userdisplayNameuser.displayName = Administrator
userhomeDirectoryuser.homeDirectory = /users/administrator
dashboardcurrentPagedashboard.currentPage = page 1
dashboardxmldashboard.xml = the dashboard XML
dashboarddashboard.currency.namedashboard.currency.name = Euro
dashboarddashboard.currency.symboldashboard.currency.symbol = $
dashboarddashboard.currency.userPreferencedashboard.currency.userPreference = Global Currency 1
dashboarddashboard.pathdashboard.path = /users/administrator/_portal/Sales
This returns the path in the catalog.
dashboarddashboard.namedashboard.name = MyDashboard
dashboarddashboard.captiondashboard.caption = Sales
This returns the localized name of the dashboard.
dashboarddashboard.locationdashboard.location = Dashboard&PortalPath=/users/administrator/_portal
This returns the URL for the location.
dashboarddashboard.descriptiondashboard.description = Sales by region and district
dashboarddashboard.authordashboard.author = Administrator
dashboard.currentPagedashboard.currentPage.namedashboard.currentPage.name = Sales page 1
dashboard.currentPagedashboard.currentPage.pathdashboard.currentPage.path = /users/administrator/_portal/Sales/page 1
dashboard. current Pagedashboard.currentPage.currency.namedashboard.currentpage.currency.
name = USD
dashboard.current Pagedashboard.currentPage.currency.symboldashboard.currentPage.currency.
symbol = USD
dashboard. current Pagedashboard.currentPage.currency.userPreferencedashboard.currentPage.currency.userPreference = Global Currency 2
analysisreport.currency.namereport.currency.name = $ English - United States
analysisreport.currency.symbolreport.currency.symbol = $
analysisreport.currency.userPreferencereport.currency.userPreference =
Global Currency 2

2 comments:

  1. How did you get this? Is it written somewhere in the documentation?

    ReplyDelete
  2. Yep you got it here... Some more information on variables and how to use them

    http://docs.oracle.com/cd/E23943_01/bi.1111/e10544/analyses.htm#CJAEFIFH

    Cheers
    Shahed

    ReplyDelete

Scripting Hive Commands with Python

  Scripting Hive Commands with Python   In the previous posts, we touched upon basic data processing using Hive. But...