The Oracle BI Presentation Services Dashboard URL is for use in :
the content of a dashboard
How to reference the Dashboard Url :
|Oracle BI Presentation Services page||saw.dll?Dashboard From the actions, you need to set up an alias.|
|From another page on the same Web server||/Analytics/saw.dll?Dashboard From the actions, you need to set up an alias.|
|From a different server or sent through email, and so on||http://server_name_or_ip_address/Analytics/saw.dll?Dashboard|
The basic Dashboard URL command needs no parameters. It displays the user's default portal, after authenticating the user. This is the format:
I saw also a PortalPages Url as : saw.dll?PortalPages
In a field formula with a HTML format, the dashboard link depend of a column value.
CASE WHEN Columns."Column Name" = 'ADDRESS' THEN '<a href="/analytics/saw.dll?Dashboard&PortalPath=/shared/Master Data Management/_portal/Essent Demo/&Page=page1 &Action=Navigate&col1=D_VENDOR_UNIFIED.ADDRESS&val1=%22' || PROFILE_SUB_DATA.VALUE || '%22&col2=Columns.%22Column%20Name%22&val2=ADDRESS" >' || PROFILE_SUB_DATA.VALUE || '</a>' WHEN Columns."Column Name" = 'CITY' THEN '<a href="/analytics/saw.dll?Dashboard&PortalPath=/shared/Master Data Management/_portal/Essent Demo/&Page=page1 &Action=Navigate&col1=D_VENDOR_UNIFIED.CITY&val1=%22' || PROFILE_SUB_DATA.VALUE || '%22&col2=Columns.%22Column%20Name%22&val2=CITY" >' || PROFILE_SUB_DATA.VALUE || '</a>' ELSE PROFILE_SUB_DATA.VALUE END
You can modify the behavior of the Dashboard URL command by adding parameters to the URL.
|PortalPath||PortalPath||Catalog Path of the dashboard|
|Page||Page=x||The name of the dashboard page|
|Passing Filters||&Action=Navigate||To apply filters to the answers include in the dashboard page (OBIEE 10G/11G - Passing Filters through the Go and Dashboard URL)|
The best way to retrieve the PortalPath and the Page parameters is to generate a dashboard link (See below for how to). In the dashboard link, you will see clearly this two parameters.
Example of URL for a dashboard “Master Data Management” with the page “Vendor” :
saw.dll?Dashboard&PortalPath=%2Fshared%2FMaster Data Management%2F_portal%2FMaster Data Management&Page=Vendor
Two types of Dashboard links can be generated. Intended for collaboration, these are the:
The Bookmark Link provides a mechanism whereby a user may obtain a shortcut link to a Dashboard page, which contains all aspects of page state.
This link can then be e-mailed to another user who (assuming they had identical permissions and access) can enter that link into the URL line of a browser and view the same page content. The recipient could then further analyze the data in the Dashboard. Technically, page state is too complex to capture in a URL so this functionality writes an object to the Presentation Services catalog, which is called by the Bookmark Link URL.
To create a Bookmark Link :
After a Bookmark Link has been generated, the user may continue to modify the content of the page, e.g., add or delete reports.
A second variant of this functionality generates a Prompted Link, which does not capture all aspects of state, but instead provides a simplified link to the Dashboard Page, which contains both the path to that page and a simplified presentation of Dashboard Prompts.
This Prompted Link permit to provide a simple URL-based API for generating and customizing Dashboard content. Unlike the Bookmark Link, this link is dynamic, which maps to no saved catalog content.
To create a Prompted Link :
The Prompted link syntax aims to pass filter and the complete syntax of the additional parameters is explained here : OBIEE 10G/11G - Passing Filters through the Go and Dashboard URL
Quickly, you will see several additional parameters (Action=Navigate, col1, op1, …)
Here is an example of the Full URL:
This section explains how to configure the new Dashboard Prompt Types feature.
For configuration, the Create Bookmark Link is enabled by default. The following nodes must be added to the instanceconfig.xml under the "ServerInstance" node:
<Dashboard> <EnableBookmarkURL>True</EnableBookmarkURL> <EnablePromptedURL>True</EnablePromptedURL> <BookmarkExpirationDays>30</BookmarkExpirationDays> </Dashboard>
<Dashboard> <EnableBookmarkURL>true</EnableBookmarkURL> <EnablePromptedURL>true</EnablePromptedURL> </Dashboard> <Cache> <Bookmarks> <MaxAgeMinutes>43200</MaxAgeMinutes> </Bookmarks> </Cache>
For the Bookmark Link, the function linkToPage(bInlineDrill,bGetBookmarkOnly) can be called. If the second argument is omitted or set to “false,” the browser address bar will be updated with the bookmark URL. If the second argument is set to “true,” the browser address bar won't be refreshed. In either case, the bookmark URL is retrieved asynchronously and put into variable saw.bookmarkURL. Polling the value of saw.bookmarkURL will give the link. This variable is set to empty string when the function is invoked. As for the first argument, if you see the “Page Options” menu on the page, set it to true, otherwise, set it to false.
For the Prompted Link, the function GetPURL( ) returns the Prompted Link as a string.