Integrating Oracle Analytics Content
This paper discusses various techniques for integrating Oracle Analytics content into external web content and also integrating external content into Analytics
Dashboards.
Integrating Analytics Reports using Go URL syntax
Analytics supports a versatile “Go URL” syntax to incorporate Analytics content into external portals.
¾ Go URL with parameters can be posted as a Form or
¾ Issue it as a URL with parameters.
If you are issuing parameters as part of a URL, they need to be escaped properly.
Calling GO URL
When calling from within Analytics Dashboard or HTML view simply use the URL saw.dll?GO
When calling from another screen from the same Web server then use the syntax /Analytics/saw.dll?Go
When calling from a different Web server the use full syntax http://server_name_or_ip_address/Analytics/saw.dll?Go
Authentication with the GO URL
It is assumed that Analytics Web site has Single Sign On (SSO) enabled within corporate web-sites.Single Sign On authentication information is not required as a part of the “Go URL”. If Single Sign On is not enabled then additional authentication parameters must be supplied with the Go URL
http://server_name_or_ip_address/Analytics/saw.dll?Go&NQuser=xxx&NQPassword=xxx
Structure of the Go URL
Basic structure of the Go URL is as follows:
saw.dll?Go&Path=/Shared/Training/ParameterReport
Here, the path is the catalog path for the Analytics report ParameterReport. This basic URL syntax displays the default result view for the report in standard style. There are number of optional arguments to this URL syntax
Display ‘Modify’, Download’ ‘Print’, ‘Refresh’ options along with the report saw.dll?Go&Path=/Shared/Training/ParameterReport&Options=mdr
Print report in HTML format
saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=print
Print in xx format, where xx=PDF,Excel, mht or xml
saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=print&format=pdf saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=print&format=excel saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=print&format=mht saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=print&format=xml
Download report directly in the xx Format where xx= Excel, csv or mht
saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=download&format=csv saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=download&format=excel saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=download&format=mht
Showing specific view of the report
saw.dll?Go& Path=/Shared/Training/ParameterReport &ViewName=pivot
Displaying all the records in a table view
saw.dll?Go&Path=/Shared/Training/ParameterReport &Action=Scroll&P5=-1&ViewID=go~Table
Displaying Dashboard or Dashboard Pages
Syntax for displaying entire Dashboard or specific Dashboard pages URL syntax is saw.dll?Dashboard&PortalPath=/shared/Training/_Portal/Training
Displaying specific Dashboard page
saw.dll?Dashboard&PortalPath=/shared/Training/_Portal/Training&Page=Sales%20by%20Region
Displaying specific Dashboard page in PDF format
saw.dll?Dashboard&PortalPath=/shared/Training/_Portal/Training&Page=Sales%20by%20Region&Action=print&f ormat=pdf
Passing Parameters to the Report using Go URL optional argument
The Go URL can also be used to pass context such as filters to a destination request. This is done by adding additional parameters to the call. You need to make sure that any columns you are passing are set up in the destination with Is Prompted filters, or specific default filters. Up to 6 parameters can be passed to the target report
Basic syntax for passing parameters Pass one parameter
saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=Navigate&P0=1&P1=eq&P2=Periods.Year&P3=1+ 1999
Pass 2 parameters
saw.dll?Go&Path=/Shared/Training/ParameterReport&Action=Navigate&P0=2&P1=eq&P2=Periods.Y ear&P3=1+1999&P4=eq&P5=Customers.State&P6=1+CA
Here the operator P1=eq can be of different type as documented in the Siebel Analytics Web Admin guide e.g. like, lt, gt etc.
saw.dll?Go&Path=/Shared/Training/ParameterReport&options=md&Action=Navigate&P0=2&P1=eq& P2=Customers.State&P3=1+CA&P4=like&P5=Products.Type&P6=1+"B%"
Include the numeric parameter value in “ e.g. &P2=Periods.Year&P3=”1998” Also position Like operator at the end of the parameter list.
Passing parameter to a Dashboard prompt
If a Dashboard is using prompts then values can be passed to it similar to above syntax as follows
http://rvijt43/analytics/saw.dll?Dashboard&PortalPath=/shared/Training/_Portal/Training&Page=Filters &Action=Navigate&P0=1&P1=eq&P2=Products.Type&P3=Beef
Issuing Direct SQL to Siebel Analytics using URL syntax
Following URL syntax can also be used to directly issue a SQL against Analytics saw.dll?Go&SQL=select+Region,Dollars+from+SupplierSales
following URL will bypass web cache and issued directly to the Analytics server saw.dll?Go&IssueRawSQL=select+Region,Dollars+from+SupplierSales
Example of embedded Analytics content in an external website
Embedding Report Content
Other possible ways to integrate Siebel Analytics
Siebel Analytics can also be integrated directly with any other 3rd party SQL tool. Siebel Analytics is an ODBC data-source.
1. For example, Siebel Analytics presentation tables/columns can be queried directly from
¾ Excel Worksheet
¾ Access Query Tool
¾ Any ODBC query tool
¾ Programmatically as an ODBC data-source and getting result set.
2. Excel Add-in
Siebel Analytics 7.8.4 supports an Excel plug-in (Separately licensed), where Analytics reports and data can be directly accessed from within Microsoft Excel. Please refer Siebel Analytics Web Admin Guide for additional details about this
feature. Note that this feature is in addition to the standard IQY feature and provides complete access to Analytics Web reports with all its formatting directly from within Excel worksheets.
3. Calling Analytics HTML Soap service to get the HTML view and other report information.
4. Briefing Book
This a separately licensed option to download and view Analytics content offline. A separate viewer is required to view the downloaded briefing book.
5. Advanced Reporting
This is a new option with Siebel Analytics where Analytics data can be formatted with advanced formatting option. This is currently integrated with Actuate Report writer. Starting with next release of Oracle Analytics a new tool Oracle BI XML publisher will allow designing pixel perfect advanced reporting using familiar tools like Microsoft word or Adobe Acrobat.
Integrating content from external websites into
Analytics Dashboard
One can integrate Analytics Dashboards and Reports external content in many different ways.The following sections explains some of the recommended practices.
Integrating within Analytics Dashboard
Analytics dashboard supports many different Dashboard Objects that can be placed on the dashboard page. Some of the useful objects for integration with external content are:
1. Link or Image
This object can be used to navigate to external web content by clicking a ink.
2. HTML content
This object can be used to display HTML content within a Dashboard. Note that HTML content can include plain HTML, javascript or Web forms.
3. Embedded Content
Any external content can be embedded within Analytics Dashboard
4. Passing data from a Report column to External Webpage
a. Custom Text Format
Using the Custom Text Format option for a column, data can be passed to an external web page. For example, in the following custom format for a column the column value is passed to an external web site. Data is passed to the external site when Analytics user clicks on a specific column value.
@[html]"<a target="_blank"
href=""http://www.google.com/search?hl=en&q="@""">"@"</a>" b. Posting Forms from within Analytics Dashboard
An analytics Dashboard section can contain an HTML object. The HTML object can create a Form object and its values can be ‘Submitted’ from within Analytics Dashboard.
c. Write-back to the database
Starting with version 7.8.4., Analytics can selectively write-back (update or insert) data from a Report back into the target database. This technique can be used to do minimal transaction work from within an Analytics Report.