Grand Total Issue in OBIEE

OBIEE Grand Totals with Calculated Columns (report)

This is a bit of a specific problem, but I could see it being something that those new to OBIEE could run into. It deals with incorrect Grand Total values being displayed for a Calculated Column when using report filters.
Consider the following report:

In this report, Amount A and Amount B are standard columns in a database table, and Variance is a calculated column in the repository. The calculation for Variance is 100 * (Amount B - Amount A) / Amount A. So, going by the Grand Total amounts in the report above, 100 * (696 - 550) / 550 = 26.55.
Suppose you want to filter the results of this request so that it only shows items having a Variance greater than 30:

Note the Grand Total for Amount A and Amount B are summed correctly for the filter, but the Variance still shows 26.55. Obviously, this is incorrect, so what’s going on here? The filtered amount should be reported as 100 * (220 - 130) / 130 = 69.23.
If you want to show the correct variance for the filtered Grand Total amounts, you need to enable an option in your instanceconfig.xml file. Open the file $OracleBIData/web/config/instanceconfig.xml, and add the following line somewhere inside your <ServerInstance> and </ServerInstance> section:

<ReportAggregateEnabled>true</ReportAggregateEnabled>

Make sure you don’t accidentally put this inside an element nested inside <ServerInstance>, or it won’t work.

Save instanceconfig.xml, and restart your BI Server and Presentation service.
Now, the correct amount should be shown for the filtered Grand Total variance:

This was previously a bug in OBIEE that was addressed by adding the ReportAggregateEnabled option. It’s not really documented anywhere other than on Metalink, so hopefully this will be helpful to someone.

OPMN startup issues : OBIEE 11g

When you see below error message while starting up opmn services 

ONS server initiated

 [opmn] [TRACE:1] [522] [pm-internal] PM state directory exists: /u01/app/middleware/instances/instance1/config/OPMN/opmn/states

 [opmn] [NOTIFICATION:1] [675] [pm-internal] OPMN server ready. Request handling enabled

[opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: 

1) Delete states directory in 

     /u01/app/middleware/instances/instance1/config/OPMN/opmn/

2) ' no address matched properties for the request' error message 

 Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (467413041:1854) [No addresses matched the properties for the request]

 [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: 

Open opmn.xml (ORACLE_HOME/opmn/conf/opmn.xml) and look the ports which are already using kill the pid's and start opmn services 

ps -ef|grep 'opmn -d'|grep -v 'grep'

kill -9 <pid>

3)  Unknown error 1074200016
RPC response timeout
time out while waiting for a managed process to stop

Take a backup of the  

/u01/app/middleware/instances/instance1/config/OPMN/opmn/opmn/conf/opmn.xml file.

-  Edit the opmn.xml

and increase timeout start/ stop parameter in seconds

<start timeout="1200" retry="2"/>

<stop timeout="240"/>

<restart timeout="920" retry="2"/>

Oracle recommends that you shutdown OPMN before shutting down your computer. Use the opmnctl stopall command to stop OPMN and OPMN-managed processes.

On the Microsoft Windows operating system, you can use the Windows services control panel to stop OPMN and OPMN-managed processes.

Types of Views in OBIEE

Types of Views in OBIEE

View Name	Description
Compound Layout	Use the compound layout view to assemble different views for display on a dashboard. On the Criteria tab, you can click the following button to access the compound layout view.
Title	Use the title view to add a title, a subtitle, a logo, a link to a custom online help page, and timestamps to the results.
Table	Use the table view to show results in a standard table. Users can navigate and drill down in the results. You can add totals, customize headings, and change the formula or aggregation rule for a column. You can also control the appearance of a column and its contents, and specify formatting to apply only if the contents of the column meet certain conditions. On the Criteria tab, you can click the following button to access the table view.
Chart	Use the chart view to drag and drop columns to a layout chart. You can customize the title, legend location, axis titles, and data labels. You can customize the size and scale of the chart, and control colors using a style sheet. Oracle BI Answers supports a variety of standard chart types, including bar charts, column charts, line charts, area charts, pie charts, and scatter charts. Custom chart subtypes include two-and-three-dimensional, absolute, clustered, stacked, combination, and custom. On the Criteria tab, you can click the following button to access the chart view.
Pivot Table	Use the pivot table view to take row, column, and section headings and swap them around to obtain different perspectives. You can drag and drop headings to pivot results, preview them, and apply the settings. Users can navigate through pivot tables and drill down into information. Users can create complex pivot tables that show aggregate and nonrelated totals next to the pivoted data, allowing for flexible analysis. For an interactive result set, elements can be placed in pages, allowing users to choose elements. On the Criteria tab, you can click the following button to access the pivot table view.
Gauge	Use the gauge view to show results as gauges, such as dial, bar, and bulb-style gauges.
Filters	Use the filters view to show the filters in effect for a request. Filters allow you to constrain a request to obtain results that answer a particular question.
Column Selector	Use the column selector view to permit users to dynamically change which columns appear in results. This allows users to analyze data along several dimensions. By changing the facts, users can dynamically alter the content of the results.
View Selector	Use the View Selector view to select a specific view of the results from among the saved views. When placed on a dashboard, the view selector appears as a drop-down list from which users can make a selection.
Legend	Use the Legend view to document the meaning of special formatting used in results, such as the meaning of custom colors applied to gauges.
Funnel Chart	Use the funnel chart view to show a three-dimensional chart that represents target and actual values using volume, level, and color. It is useful for depicting target values that decline over time, such as a sales pipeline.
Narrative	Use the narrative view to show the results as one or more paragraphs of text. You can type in a sentence with placeholders for each column in the results, and specify how rows should be separated.
Ticker	Use the ticker view to show the results of the request as a ticker or marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet. You can control what information is presented and how it scrolls across the page.
Static Text	Use the static text view to include static text in the results. You can use HTML to add banners, tickers, ActiveX objects, Java applets, links, instructions, descriptions, graphics, and so on, in the results.
No Results	The no results view allows you to specify explanatory text to appear if the request does not return any results.
Logical SQL	Use the logical SQL view to show the SQL generated for the request. This view is useful for trainers and Oracle BI administrators, and is usually not included in results for typical users. You cannot modify this view, except to delete it.
Create Segment	The create segment view is for users of the Oracle's Siebel Marketing Version 7.7 (or higher) operational application. Use it to display a Create Segment link in the results. Users can click this link to create a segment in their Oracle Siebel Marketing operational application, based on the results data.
Create Target List	The create target list view is for users of Oracle's Siebel Life Sciences operational application integrated with Oracle's Siebel Life Sciences Analytics applications. Use it to create a Create Target List link in the results. Users can click this link to create a target list, based on the results data, in their Oracle Siebel operational application.