Upgrade From OBIEE To OBIEE Features and changes 11G12c[13026] Error in getting roles from BI Security Service (nQSError: 12002, 12010)NQSError:15019 - Table @1%ls is functionally dependent upon level @2%ls[39008] Logical dimension table does not join to any fact source[39059] Logical dimension table has a source at level that joins to a higher level fact sourceAct as (Proxy user) FunctionalityActionAction Framework - How to create and invoke a Java Method (EJB)Administrator AccountAdministration Tool (admintool)Repository Admintool Object Copy/PasteHow to configure BI Server against the LDAP of ADSI ?(Weblogic|OBIEE 11G) - Active Directory (ADSI) Configuration(Ibot|Agent)Aggregate At Function"Aggregate By" FunctionAggregate (Navigation|Table|Content)Aggregate Persistence (Script)Aggregate Persistence Wizard (aka Data Mart Automation)Repository Aggregation rules based on dimension (dimension-specific aggregate)Aggregation RulePeriod to period comparison with the AGO Function Alias (synonyms)Answer/AnalyticsGrand Total Formatting in a Pivot viewApex IntegrationOracle BI Fusion Middleware ArchitectureAt Sign (@)(Presentation column|Attribute Columns)Authentication (ATN)AuthenticationAuthorizationBaseline columnBi-init.cmd (or on UNIX)BI Domain - The complete OBI SystemBI Server (Obis) (Architecture|Overview)Bi Server metrics functionsHome page (bieehome)BIP report integrationBIPlatform SchemaBiserverxmlcliBiserverxmlexec (RPD creation and patching)BiserverxmlgenBISQLProviderBISystemUserBlob data typeThe Business Model and Mapping (BMM)BottomN functionBriefing BookAll the cachesCache ManagerCalculated ItemCalculationCapacity planning / SizingCase When StatementCast as date - Which date format to use ?Cast(NULL as INTEGER)Catalog GroupCatalog ManagerCentral configuration through Fusion Middleware Control(Browser|Database|Third party product) CertificationChoose FunctionBI Server Clients (ODBC, JDBC)Client ToolsCluster (High Availability)Complex (Join|Operator) (Physical and Logical)ConditionsConditional FormattingConnectionConnection PoolConnection ScriptCopy Request Xml to ClipboardCosmetic Formatting (Style, Css)Count (and sometimes Sum)Criteria TabCurrencyDashboardEnable column sorting in DashboardsThe (dashboard|column) promptDashboard parameter prompt - The WHEN 1=0 or ifnull solutionHow to constraint the values of a dashboard prompt based on the selection of an other ?Dashboard Prompt with data level securityHow to create a prompt to handle a parameter ?Dashboard (Url|Link)Data FormatDatabase ObjectDatabase Features ParametersDatatypeHow to mix String and Number data type in one column and obtain a sum ?Date Datatype and FunctionsDbGateway (DB_GATEWAY_THREAD_RANGE)OBIEE / Weblogic 11G - (Create|Recreate) a default authentication provider (with administrator, ...)DeliversAdvanced Publication with Delivers (In Java)What means "Data is dense" ?Densification / Dimensions Preservation PossibilitiesDensification with the fact-based fragmentation capabilitiesLog Files (Oracle Diagnostic Logging - ODL)Dimension (Logical Table)Dimension fragmentation design to add an automatic filter with the choice of a columnIdentifying a Dimension TableHow to create a measure from data that is stored in a dimension tableDirect Database RequestTable Function/Stored Procedure in Direct Database Request(Display Function|Derived Measures) (Rank, TopN, Median, ...)Basic Discrete Distribution ReportDMS Metrics(Universe|Domain)Double column (Descriptor Id)Drilling (Down and Through)Driving TableDXE ExecutionEBS IntegrationEqualizing ObjectsEqualizerpds utilityEssbaseEvaluate - Embedded DB FunctionsEvent Pooling table (Event Table) to purge the cache after ETL processMicrosoft ExcelHow to create an HTML view (Narrative, Static Text) to get a good Excel formatting ?EXECUTE PHYSICAL CONNECTION POOL StatementOracle BI Server Execution EngineExtractprojects utilityFact table (of logical fact table)Defining a Non-Aggregated Measure (Baseline column) of a Fact TableIdentifying a Fact TableDefining the Logical Key of a Fact TableFederated Query / Multi-Database or Cross-Database JoinFilterConditional Filtering based on Presentation Service VariableHow to force a user to filter on a column A every time column B is in the requestPivot Measures (The Filter Function)Filter on current timeThe relative path fmapForeign Key or Physical Join (Fragment|ation) (Partitioning)Fragmentation Content, value-based, horizontal partitioningFact-based vertical partitioning/fragmentationAggregate Navigation with level-based fragmentationFull outer JoinFunctionsTime Series Conversion Functions : AGO and TODATEFunnel ViewGauge ViewGetting Started / TutorialThe Go URLGrain - Level of (summarization|aggregation)(Chart|Graph) View(Group|Security Role|Application Role)Aggregation rules in Logical SQL with the GROUP BY and BY clauseGUIDGuided NavigationHadoop HiveSAP HanaHardenXSS - Specifying Whether to Allow HTML Input in OBIPS FieldsDimension Hierarchy (logical dimensions)Level-based HierarchyHintHistoryHtml Content CachingHTML MarkupIbotVoid (Id)Repository Object IdentifierIframeIIS BI Presentation Service Plugin (OC4J listener)Where and how to call an image / picture ?ImpersonateImplicit Fact ColumnImport WizardHow to retrieve data from BI Server in Excel ?IndexCol Function - Handle hierarchy Level securityInitialization BlockInstallation / ConfigurationOracle Business Intelligence 11.1 Simple installation steps on Windows and OEL Linux 32 bitInstanceInstanceconfig.xml (Configuration Presentation Services)Integer DatatypeOracle BI Open Intelligence Interface (ODBC and JDBC) client connectivityMobile Application, Mobile DeviceIssue SQL (the IssueRawSQl Url)Java HostJavascriptJdbcOracle BI JDBC DriverJob ManagerJoinHow to model a bridge table (Many-to-Many relationship) with the joins property of a Logical Table ?Joins definitions in the repository (complex, foreign, logical table source)KPIPeriod to period comparison (YAGO, MAGO) with the analytical function Lag/LeadLast/First functionThe drop targets of a layout (view|pane)LDAP over SSL with Global Security Kit (GSKit)Left outer joinLogical levelConfigure Level Number of Elements in Dimensional HierarchiesLinux OEL 5 x86 Installation version system session variableLocalizationCommon Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)Logical ColumnLogical JoinLogical Request (before navigation)Logical SqlLogical TableLoginSetting a Query Logging LevelLookup FunctionLogical Table Source (LTS) (Physical and Logical Column Mappings)How to see the Physical SQL generated by a request in Presentation Service ?(Manage|Configure) Map DataBI Management PackMap ViewMapviewerOracle Marketing SegmentationMaster Detail(MDS|Metadata Service) (XML|XUDML)Measures (Columns|Attributes)Level-Based Measure CalculationsNested aggregate measureMerge RepositoryCustom MessagesGenerating and Deploying a Metadata DictionaryOracle BI DMS MetricsMonitoring - (Performance|Perfmon) (Metrics|Counter)Redirect to MonitoringReporting on Multiple Subject Area (Advanced Logical SQL)MultiUser Development Environment (MUDE - Projects)Narrative viewHow to set up a navigate interaction ?(Invoke|Navigate) to an URL (Web Page|HTTP Request)Data Navigation (Drill Down, Through, Link, ...)No Result ViewNQClient.exeNqcmd.exe ODBC Client ToolNqgenoldverrpd (Repository Downgrade)The nQuireID ( Authentication nqid )The Log Viewer (nQLogViewer)Nqquery.log (Query logging)Connection Pool Password ChangeNQSConfig.iniNQsError: 35008 - An error occurred while trying to check outNQServer.logAuthentication Web Service with SAWSessionService (nQSessionService)Nqudmlgen.exeHow to find the value, the data type of a Server variable ?How to define OBIEE to leverage SQL OLAP Query ?Oracle Warehouse Builder IntegrationThe answer PromptHow to customize the background color of a graphBackupHow to define a Many-to-Many relationship with a Bridge table ?How to connect remotely to the servers (BI, Presentation) ?Complement SoftwareFederated Query with Excel SheetHow to limit the number of records fetchHow to define a One to Many RelationshipNullArchitectureRss FeedScript to start Oracle BI Servers and Cluster ControllersOC4JOracle Call Interface (OCI) configurationODBCODBC ClientOracle BI ODBC driverHow to create an Analytics ODBC Data Source (System DSN ODBC connexion)BI Server (JDBC|ODBC) Driver FunctionsMicrosoft Office Server and (Add-in|Plug-In)Opaque ViewORA-00937 - Not a single-group group functionOuter JoinParameters (parameterized query)PasswordPatchIn-Place Upgrade - Patch Set Installation from version to version Upgrade - Moving from to Server PatchHow to redeploy the BI Presentation Service Plug-in (after a patch Installation, Don't forget to redeploy the WAR/EAR file)PDFPERF_PREFER_INTERNAL_STITCH_JOIN database featurePerformance Monitor (Perfmon)Repository PermissionPersist connection poolPhysical Alias Physical LayerPhysical SQLCross conditional formatting on a pivotHow to sort on a measure column of a pivot view ?How to sort on the column grand total value of a pivot view ?How to suppress detail rows of a master group in a pivot view ?How to pivot a character column ?Pivot ViewPlus ComponentsPopulate StatementPorts(Presentation Hierarchy|Hierarchical Column)Presentation LayerBI Presentation Service (SAW/OBIPS)Presentation Services ArchitecturePresentation Service (Query|Result|Cursor) CacheHow to install an other instance of Presentation Services on one Application Server (OC4J)Presentation Service Plug-inPresentation VariablesDatatype of a presentation variableDate Format in presentation variable, dashboard prompt and logical SQLHow to set a presentation variable ?Presentation Variable System (reserved variable)Where can I use a presentation variable ?Privilege packagePrivilegesProjects Release (Promotion|Migration) - From Dev, Test to ProductionPromptFully Qualified Name Object Identifier (Object Path)BI Server (Logical Query|Result) CacheLogical Query Result Cache ParametersPurging / Disabling the Query CacheWhy a Query is Not Added to the Query Cache ?Query CompilerQuery PlanQuery ProcessingRankRegular Expression (Regexp) and how to filter on string pattern ?How to model the different relationships ?Report-based TotalRepository (RPD file)Repository DesignObjects Import from another repositoryRequestRequest variableRight outer join(Row-wise|List of Values) server variableOracle BI Server XML API (XUDML)Running Sum (RSum)How to produce and show a total section on **each line** (Running total)?Usage Tracking S_NQ_ACCT TableS_NQ_INSTANCE tableS_NQ_SUMMARY_ADVISOR tableSA System subject areaSametaexport utility (Metadata Exchange)Installation Sample Application version 825Sample App V107SAP BWSASchInvoke (command line Triggering of Oracle BI Scheduler Jobs)Saw Url - Symbolic URL Parameters AppletHow to set a request/session variable using the Saw Url (Go/Dashboard)Presentation Services log (sawlog.log)ScalingBI SchedulerBI Scheduler Configuration (for Delivers)How to configure the Mail server of Scheduler/DeliversScorecards (and Strategy Management)SecuritySecuritySecurity (Level|Type)How to define the BI server security to add automatically a filter when a column is added to an answer (row security level)The Security ManagerSELECT_PHYSICAL statementsSelection Steps"Server Complex Aggregate" ruleInstalling Oracle BI Components on Different MachinesServer ThreadBI Server Variables (session and repository)How to set and use a server variable (system/repository) of type date ?Where can I use a BI Server variable (session/repository) ?SessionSession ManagerHow to set a server variable with the session type via a dashboard prompt (with a request variable) ?How and where can I set a Request variable (SET VARIABLE) ?How to define one different database credential for each user (the shared logon) ?Single table model.Look and feel Customizing (Style and Skin)OBIEE 11G ( - How to configure a new SkinOBIEE 10G/ - How to create a New Style and Skin ?Quick Skin and Style customizationData Source (Oracle Analytics Adapter)Special CharactersStarting Oracle Business Intelligence on WindowsHow to Start and Stop the services ?How to start and stop OBIEE automatically with a Bat file ?Static Text ViewStaticports.iniStitch Join (Intern Join Operations)Subject Area / Presentation catalogExalytics Summary Advisor(Error Correction) SupportSystem (Configuration) Management (Mbean)System session variables (reserved variables)How to perform a pivot in a table viewTable viewTemps filesHow to set up the time dimension (for time series functions Ago, Todate, ...) ?Time zoneTitle ViewTopNUDML(Upgrade|Refresh|Recover) GUIDUpgrade from the Sample App SampleSales 10gUpgrade ID (UID)Base URLPassing Filters through the Go and Dashboard URL(Usage Tracking|UT) (Query Log)Which Usage Tracking time measure should be used to gauge the performance of SQL retrieval time ?UserBI Server UtilitiesAll type of variablesVariable ManagerThe variable promptOBI VersionVersioningHow to control the use of the WITH CLAUSE and of STITCH Join ?ViewsVirtual Private DatabaseWeb Services API (SOAP,WSDL)The (Web|Presentation) Catalog (Webcat)Translate the WebCat (Dashboard, page and report names)WEBLANGUAGE system session variableHow to add a wiki to OBIEE (installation of a wiki on OC4J standalone)Windows Installation Version Services as Windows Services InstallationSSO Authentication with Windows Native Authentication (WNA)Writeback Capabilities (Table of Pivot)XMLHow to retrieve a result set with the XMLViewService WebService and the logical SQL ?


OBIEE 10G/11G - Dashboard (Url|Link)


The Oracle BI Presentation Services Dashboard URL is for use in :

  • incorporating
  • referencing
  • filtering

the content of a dashboard

The basic of the dashboard Url

How to reference the Dashboard Url :

From References
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

Example / Snippet

In a field formula with a HTML format, the dashboard link depend of a column value.

WHEN Columns."Column Name" = 'ADDRESS' 
   '<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>'

URL Parameters

You can modify the behavior of the Dashboard URL command by adding parameters to the URL.

Parameters Format Definition
NQUser &NQUser=x User ID
NQPassword NQPassword=x Password
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:

  • Bookmark Link
  • Prompted Link

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 :

  • click on the Dashboard “Page Options” menu
  • select the option “Create Bookmark Link”
  • Once selected, the Dashboard message bar will show that “A Bookmark Link suitable for saving or sharing has been created for this page. This Link can be found in the browser's Address Bar.”
  • Copy/Paste the link just created in the Address bar
  • Save it or share it most likely via e-mail.

After a Bookmark Link has been generated, the user may continue to modify the content of the page, e.g., add or delete reports.

The Create Prompt Link is not enabled by default, you have to change some configuration.

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 :

  • click on the Dashboard “Page Options” menu (Need to be configured to show this feature)
  • selects the option “Create Prompted Link”
  • Selecting this option will generate the Prompted Link and the user will see a message indicating, “A Prompted link capturing the prompts and values of this page has been created.”
  • Copy/Paste the link just created in the Address bar
  • Save it, modify it or share it.

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:

  • 10G:
  • 11G:

Javascript functions

For advanced applications, and for both the “Create Bookmark Link” and “Create Prompted Link” functionality, two Javascript functions can be called to retrieve these values from custom scripts embedded on the originating Dashboard Page. Note, for Javascript functions to work a HardenXSSconfiguration must be set to false.

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.

Documentation / Reference

  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Digg
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Ask
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Google
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at StumbleUpon
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Technorati
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Live Bookmarks
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Yahoo! Myweb
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Facebook
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Yahoo! Bookmarks
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at Twitter
  • Bookmark "OBIEE 10G/11G - Dashboard (Url|Link)" at myAOL
dat/obiee/dashboard_url.txt · Last modified: 2014/11/12 12:46 by gerardnico