Saturday Jul 20, 2013

Performance issues after upgrading Essbase outlines from 11.1.1.x to 11.1.2.x

After upgrading Essbase from the 11.1.1.x to 11.1.2.x releases, run through your sanity tests, such as outline dimension build updates, data loads, calculations, queries, etc.  If you encounter any performance issues on the newer release of Essbase (for either ASO or BSO models) as compared to the previous release, rebuild the problematic outline on the current 11.1.2.x release.  It is possibly that the outline did not migrate properly during the upgrade process.  

Once you have rebuilt the outline, run through your tests again and if you still encounter performance issues, open an SR with Support.


 

Thursday Feb 09, 2012

OBIEE 11.1.1 - Upgrade from 10g - Calculated Items

In 10g, calculated items were created in one pivot table only. In 11g, all calculated items are shown in all views.

The format of the report is modified: calculated items that were in one pivot table only before the upgrade now appear in all views.

If a calculated item had the option ‘Hide details’ selected, showing this column in other views changes completely the results.

To replicate 10g behavior in 11g, you must:

Add a new column identical to the one used to compute the calculated item.

In all views except in the one that includes the calculated item, replace the old column by the new one.

Note that it is easier to perform this modification in 10g before the upgrade. It is possible to do it in 11g after the upgrade but then you have to compare 11g and 10g reports to find out which view the calculated item belonged to.

About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today