Direct Links to various OBIEE User and Administration Presentation functions

These are some direct links to various OBIEE User and Administration functions.  These can be useful to know for efficiency and at times can also be useful for debugging security.

To go directly to “Home Page”
http://servername:9704/analytics/saw.dll?bieehome

To go directly to “Dashboard”
http://servername:9704/analytics/saw.dll?Dashboard

To go directly to “Manage Privileges”
http://servername:9704/analytics/saw.dll?PrivilegeAdmin

To go directly to “Manage Catalog Groups”
http://servername:9704/analytics/saw.dll?ManageGroups

To go directly to “Manage Sessions”
http://servername:9704/analytics/saw.dll?Sessions

To go directly to “Manage Agent Sessions”
http://servername:9704/analytics/saw.dll?ManageIBotSessions

To go directly to “Issue SQL”
http://servername:9704/analytics/saw.dll?IssueRawSQL&Done=%2fanalytics%2fsaw.dll%3fAdmin

To go directly to “Manage Map Data”
http://servername:9704/analytics/saw.dll?ManageMapData

To go directly to “Manage BI Publisher”
http://servername:9704/analytics/saw.dll?bipublisherEntry&Done=%2fanalytics%2fsaw.dll%3fAdmin&Action=admin

Components of Oracle Business Intelligence Applications (OBIA)

The Oracle Business Intelligence Applications (OBIA) is made up of a number of components that are brought together to create a great prebuilt BI solution.  The components can be categorized into 4 major components.

1. Prebuilt reports and dashboard content + Embedded dashboard/report building tool
This prebuilt content is contained in the Oracle BI Presentation Services Catalog, and some of the content is built on the Oracle BI Repository metadata.
The tools include Dashboard Editor and Answers.

2. Prebuilt metadata content (Oracle BI Server Repository) + Administration Tool       
This metadata content is contained in the Oracle Business Intelligence Applications repository file (EnterpriseBusinessAnalytics.rpd).
This content is built and administered using the BI Administration Tool, and is built from the metadata in the OBAW.

3. Oracle Business Analytics Warehouse
The prebuilt data warehouse that holds data extracted, transformed, and loaded from the transactional sources.  The OBAW contains best-practice star-schemas and conforming dimensions.

4. Prebuilt ETL processes and tools
Prebuilt Informatica content + Embedded Informatica ETL Tool + Prebuilt DAC metadata repository files + Embedded DAC Tool
Informatica is a third-party application that performs the extract, transform, and load operations for the Data Warehouse.  The Informatica content includes Extract-Transform-Load (ETL) repository objects, such as mappings, sessions, and workflows, and is contained in the Informatica repository file (Oracle_BI_DW_Base.rep).
The DAC is a tool that is used for setup, configuration, administration, and monitoring of data warehouse processes.  The DAC content includes repository objects such as tables, subject areas, execution plans, and tasks, and is contained in XML files.
These tools and processes together extract data from sources, such as Oracle EBS or PeopleSoft, and load the data into the OBAW.

OBIEE11g Master_Detailed events

Creating   Send Master_Detail Events:

This is used when Customer wants to see the details of Summary  report side by side.

Prerequisites:

1. Specify Channel should be unique.
2. Should give that unique name in Properties of the detail event.
3. prompt is mandatory whatever view you are using.(i.e. graph or table or pie etc..)

Steps:

This  Example is when Customer click on particular portion of Pie Chart, The details of that portion should be shown side of that report.

1.  Create Report with different Views (table,Graph,Pie etc..)

2.   Click on “Column Properties “ of the column in the Criteria

and click on “ Interaction” tab

Under the “value “

Select Primary Interaction  as “Send Master-Detail Events”

Give  Specify Channel “ A unique Name” and  ok

3. Go to “Result “tab & Edit Table View

Click on table properties

  

4. Check the “”Listen to Master-Detail Events

And in the “Event Channel “Give the Unique name  give at step 2.

5. Give the Table Prompt (Drag the column in the “Table Prompts”)

Giving prompt is mandatory whatever view you are using. (I.e. graph or table or pie etc..)

6. Now run the report and click on pie chart, the details of that report will be shown in tabular format.

Save the report.

OBIEE Go URL

Go Url:

The GO URL is useful when you are accessing the report in a different subject area.

Please follow the detailed steps to create Go Url Functionality:  

1. Create a summary report.

2. We would like to see the invoice line details which belong to different subject area and our requirement is that,after clicking the invoice number will get the invoice line details.

Go to the invoice number column properties à Data Format à Enable the Override default data format check box à Make the Treat text as Html

      3.Create a detailed report. Note that detailed report belongs to different subject area and make the invoice number as prompted.

4    4. Copy the navigation of detail report url.

http://172.21.7.92:7001/analytics/saw.dll?Answers&Action=results&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP

      5. Go to the summary report and select the invoice number properties and click on edit formula

and update the following url in column formula. http://172.21.7.92:7001/analytics/saw.dll?Answers&Action=results&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP

i)<a> </a> à this is an html tag which is used to represent hyper link.

ii) href is the property to specify the destination report. Copy the detail report URL: http://172.21.7.92:7001/analytics/saw.dll?GO&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP

iii) action is the event which specifies navigation and the value is action = navigate.

iv) P0 is the parameter which specifies the number of parameters that are transferring from source to destination. Here in our example invoice number is the only parameter so P0 = 1

v) P1 is the parameter to represent the assignment (example values are eq is equal, gt refers greater than, etc).

vi) P2 is the destination parameter where this source parameter is transferred to corresponding destination value. (Value = ="-%20Nx_APG0_Invoice_Distributions%20(Payables%20Views)"."Invoice%20Number").

Note: Browser unable to identify the spaces in the URL so please replace the space with hexadecimal value of space %20.

Column variable name for the destination column "- Nx_APG0_Invoice_Distributions (Payables Views)"."Invoice Number".(Replace this column name without spaces).

"-%20Nx_APG0_Invoice_Distributions%20(Payables%20Views)"."Invoice%20Number"

vii) P3: Source column name('||"- Nx_APG0_Invoices (Payables Views)"."Invoice Number"||')

Note: Here we are not replacing the spaces with hexadecimal value because while navigating browser assign the value of source parameter.

Final value is: '<a href=http://172.21.7.92:7001/analytics/saw.dll?GO&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP&Action=Navigate&P0=1&P1=eq&P2="-%20Nx_APG0_Invoice_Distributions%20(Payables%20Views)"."Invoice%20Number"&P3='||"- Nx_APG0_Invoices (Payables Views)"."Invoice Number"||'>'||"- Nx_APG0_Invoices (Payables Views)"."Invoice Number"||'</a>'

Run the Source report and click on invoice number and it will navigate to next destination report .