Monday, June 9, 2014

Pre-defined presentation variables in OBIEE 11g

These variables can be referenced in analyses, dashboards, KPIs, and agents. The syntax for these pre-defined presentation variables is 
@{session.variablename}  " OR"
@{session.variables.variablename}
You can use variable in below views. For example Title view: here i am giving User name and loginTime.















All Views name where you can you Predefined Presentations Variable:
Title views
Headers and footers for PDF output
Narrative views
Link or image objects in a dashboard
Static text views
Text objects in a dashboard
Filters
Graphs to specify conditional formatting of graph data. Gauge thresholds.
Column formulas
Gauge limits
Conditional formatting conditions
Agents
Table and column headings in analyses
Actions to specify parameters.
Direct database requests
Conditions to specify parameters
Dashboard prompts and inline prompts
Selection steps
KPIs included in a KPI watchlist
KPIs to define thresholds

Pre-define presentation variable name : 
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
sessionrtl
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.
session.rtl = false
sessiontimeZonesession.timeZone = (GMT-06:00) Central America
sessiontimeZone.id
This returns a value that is not localized.
session.timeZone.id = (GMT-06:00) Central America
sessiontimeZone.name
This returns a localized value.
session.timeZone.name = (GMT-06:00) Central America
sessiontimeZone.value
This returns a localized value.
session.timeZone.value = (GMT-06:00) Central America
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.path
This returns the path in the catalog.
dashboard.path = /users/administrator/_portal/Sales
dashboarddashboard.namedashboard.name = MyDashboard
dashboarddashboard.caption
This returns the localized name of the dashboard.
dashboard.caption = Sales
dashboarddashboard.location
This returns the URL for the location.
dashboard.location = Dashboard&PortalPath=/users/administrator/_portal
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

Thanks and Regards 
Rakesh Patil
rakeshpatil002@gmail.com
OBIEE Foundation Suite 11g Certified Implementation Specialist

No comments:

Post a Comment