OBIEE 11g - Enable Report Performance Improvement in the Analysis

OBIEE 11g analysis has query performance option to "Share query with multiple users"

To enable this option,
1. Analysis' Advanced tab
2. In the bottom of the page select "Share query with multiple users (may improve performance after initial
run)
3. Click "Apply" and save your analysis.

Read More

OBIEE11g - Enable Log-Level from Advanced Tab

In the Advanced tab, Add below tag in the prefix and click Apply SQL.

SET VARIABLE LOG_LEVEL = 2;

Log from Administration > Manage Sessions.

Read More

OBIEE11g - Calculating First Day of Year, Quarter, Month in Answers

First Day of  Year: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFYEAR(CURRENT_DATE )-1) , CURRENT_DATE )

First Day of Quarter: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAY_OF_QUARTER(CURRENT_DATE )-1) , CURRENT_DATE )

First Day of Month: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFMONTH(CURRENT_DATE )-1) , CURRENT_DATE )

Query For Current Year and Quarter and Month  

SELECT 
TRUNC(cast(TO_CHAR(SYSDATE,'YYYY') as VARCHAR(20))),
TRUNC(CAST(TO_CHAR(SYSDATE,'Q') AS VARCHAR(20))),
TRUNC(CAST(TO_CHAR(SYSDATE,'MM') AS VARCHAR(20)))
FROM DUAL;

Read More

OBIEE11g - Changing Default Chart Colors

Change default chart colors in the OBIEE11g

OBIEE 11.1.1.7.x

<Middleware>/Oracle_BI1/bifoundation/web/msgdb/s_FusionFX/viewui/chart/dvt-graph-skin.xml
Older versions:
<Middleware>\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml

Add the following <SeriesItems> tag before </Graph>
Note: You can add as many <Series id="n" color=.... /> as you wish.

<SeriesItems>

<Series id="0″ color="#ff0000″ borderColor="#ff0000″/>
<Series id="1″ color="#00ff00″ borderColor="#00ff00″/>
<Series id="2″ color="#0000ff" borderColor="#0000ff"/>
</SeriesItems>

</Graph>

Read More

Error : [nQSError: 13015] You do not have the permission to set the value of the variable

View Display Error

Error getting drill information: SET VARIABLE LEDGER-ID='02' SELECT ledger.ledger_id saw_0, valueof(nq_session.LOB) saw_1 FROM OLEM  Error Details Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13015] You do not have the permission to set the value of the variable 'LEDGER_ID'. (HY000) SQL Issued: {call NQSGetLevelDrillability('SET VARIABLE LOB=''LEDGER'' SELECT ledger.ledger_id saw_0, valueof(nq_session.LEDGER_ID) saw_1 FROM LEDGER')}

Solution :
 Go to properties of session variable all check the option "Enable everyone to set value"

Follow the below steps :

1. Open Administration Tool. Go to Manager > Variables.

2. Select System or Non-System variable (depends on type of your variable) under the Session  from left pane. Then the corresponding variables will be listed on right pane.

3. Right click on the variable(for which your getting error in presentation service when you tried to change its value) and select properties.

4. check the option "Enable everyone to set value" (by default this option is unchecked) and click OK.
 Log out from that session and again login to presentation services and the same report.

Read More

OBIEE 11g - Query Limit

Query limit and number of minutes a query can run per physical layer database connection, follow the below steps.

> Login to Repository using OBIEE Admin Tool
> Go to Manage > Identity
> Go to Application Role tab, choose the role and double click on it to open.

> Click on Permissions tab



 > Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.

Read More

OBIEE 11g - Query for Yesterday Date

Using in Analysis:

"Date" IN (TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE))

Using sql query in the Dashboard Prompt:
SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE) 

FROM "Time"

Read More

Using a FILTER Function Instead of CASE Statements

OBIEE alternative – the FILTER function. Like CASE statements, you can use the FILTER function to build a logical column expression. In the Expression Builder, this function can be found under Functions > Display Functions > Filter. Here is an example of how to use it:

Suppose you have two Logical Columns derived from the following expressions:

• UAE:
  CASE WHEN Paint.Markets.Region = ‘UAE’ THEN Paint. SalesFacts.Dollars ELSE 0 END
• INDIA:
  CASE WHEN Paint.Markets.Region = ‘INDIA’ THEN Paint. SalesFacts.Dollars ELSE 0 END

Instead of using CASE statements, try using the following equivalent expressions involving the FILTER function:

• UAE:
  FILTER(Paint. SalesFacts.Dollars USING Paint.Markets.Region = ‘UAE’)
• INDIA:
  FILTER(Paint. SalesFacts.Dollars USING Paint.Markets.Region = ‘INDIA’)

The SQL generated by the FILTER expressions will typically perform better than the SQL generated from the CASE statements. The FILTER SQL may look something like this (pretending all the columns come from the same physical table):

SELECT Physical_yearr,
SUM(CASE WHEN Region = ‘UAE’ THEN Dollars),
SUM(CASE WHEN product = ‘Samsung’ THEN Dollars)
FROM physical_table
WHERE Region = ‘UAE’ OR Region = ‘INDIA’
GROUP BY Physical_year

The SQL generated from the CASE statements may look more like this:

SELECT Physical_year,
SUM(CASE WHEN Region = ‘UAE’ THEN Dollars ELSE 0),
SUM(CASE WHEN product = ‘Samsung’ THEN Dollars ELSE 0)
FROM physical_table
GROUP BY Physical_year

The major difference is that the FILTER SQL includes the criteria in the WHERE clause. In most cases, this means that the WHERE clause would run first, constraining the result set before the CASE statements are run, hence the improvement in performance.

Read More

OBIEE 11G Installation error during configuration steps with message "Distributing Repository" failed

Problem:

When attempting to install OBIEE11g (11.1.1.7) on Windows 64bit, the installation failed at the 
configuration steps with error message "Distributing Repository" failed.

Answer:

To avoid this issue, make sure that the locale en_US.UTF-8 exists on the installation computer before you install Oracle Business Intelligence.

Read More

Installing BI Applications 7.9.6.4 on BI EE 11.1.1.7.0

The Oracle Business Intelligence Application 7.9.6.4 installer fails on Oracle BI EE 11.1.1.7.0 with the error “NQSConfig.INI not found. Please make sure your environment is set up properly”. Also  7.9.6.4 JAZN file is incompatible with BI EE 11.1.1.7.0. This causes authentication failures when a user tries to log in to the Analytics page.

Issue 1: The Oracle Business Intelligence Application 7.9.6.4 installer fails on Oracle BI EE 11.1.1.7.0 with the error “NQSConfig.INI not found. Please make sure your environment is set up properly”.

Issue 2: The Oracle Business Intelligence Application 7.9.6.4 JAZN file is incompatible with BI EE 11.1.1.7.0. This causes authentication failures when a user tries to log in to the Analytics page.

Error Message

NQSConfig.INI not found. Please make sure your environment is set up properly

Please down the attached file Technote1561846.1_InstallSecurity.zip and apply the solution.ID 1561846.1
If required apply patch p16321623_7964_Generic

Patch Download from here

Patch Doc

Read More

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

Error: 

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

SQL Issued: SELECT 0 s_0, "SPM - Strategic Plan"."Res Statement"."Responsibility Statment Ar" s_1, "SPM - Strategic Plan"."Res Statement"."Responsibility Statment" s_2 FROM "SPM - Strategic Plan" 

Solutions:

Create a view in database by selecting all the columns  and use this DBMS_LOB.SUBSTR(<Clob column>) for clob column.
example: SELECT  rs.sp_id,  
        CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT,4000,1)AS VARCHAR2(4000)) RESPONSIBILITY_STATMENT,
        CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT_AR,2150,1) AS VARCHAR2(4000)) RESPONSIBILITY_STATMENT_AR,
       CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT_AR,4000,2151) AS VARCHAR2(4000))
FROM 
       xxspm_respon_statment rs

If it is English characeter it will accept up to 4000 char , If it is Arabic character it will allow you 2150 characters you can split the data in to two columns like in the example.

1) In the RPD physical layer change the data type to Longvarchar
2) In the report level add two arabic columns using concatinate symbal ( || ) in the expersion builder report will work

good luck.

Read More

OBIEE 11.1.1.6.11 - Patche Release Details

11.1.1.6.6

Version	Latest Patchset, patch Set Update or Maintenance Release	Patch Release Date	Comments
11.1.1.6.0		Available	This release is NOT recommended for customers to go-live on. If a customer is upgrading they should install 11.1.1.6.0, then apply the necessary patches via opatch to get them to 11.1.1.6.7 or newer If a customer is currently on 11.1.1.6.0, then apply the necessary patches via opatch to get them to 11.1.1.6.8 or above and plan an adjusted to-live accordingly to be successful. Customers can consider 11.1.1.6 PSE1 that is available for go-live, but the better option is to patch to 11.1.1.6.8 or above
11.1.1.6 PSE 1		Available	This version is recommended for upgrade customers over 11.1.1.6.2, because 6.2 does not have all of the 6.1 PSE fixes
11.1.1.6.2	Patch 13932572 Patch 13887566 Patch 13926409 Patch 13892934 Patch 13916045 Patch 13884769 Patch 13794002 as well as Patch 13952743	14th of May 2012	List of all patches 11.1.1.6.2 consists of: Patch 13932572 - 11.1.1.6.2 Oracle Business Intelligence Installer Patch 13887566 - 11.1.1.6.2 Oracle Real Time Decisions Patch 13926409 - 11.1.1.6.2 Oracle Business Intelligence Publisher Patch 13892934 - 11.1.1.6.2 Oracle Business Intelligence ADF Components Patch 13916045 - 11.1.1.6.2 Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x Patch 13884769 - 11.1.1.6.2 Oracle Business Intelligence Patch 13794002 - 11.1.1.6.2 Oracle Business Intelligence Platform Client Installer and JDeveloper Patch 13952743 mentioned in Readme files needs to be applied, too From the readme: "This patch is highly recommended for all the customers (except Exalytics customers) who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0 and 11.1.1.6.1. Exalytics Customers must not apply this patch." This version is also NOT recommended for upgrade customers because 6.2 does not have all of the 6.1 PSE fixes.  Customers should either go to 11.1.1.6 PSE1 or patch to 11.1.1.6.8 or above Customers need to install 11.1.1.6.0, then apply the necessary patches using opatch to get to 6.2
11.1.1.6.2 BP1	Patch 14223977 Patch 14226980 Patch 13960955 Patch 14226993 Patch 14228505 Patch 13867143 Patch 14142868	Released on 29th June 2012 for all platforms, except HP-UX Itanium	List of Patches: Patch 14223977 - 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer Patch 14226980 - 11.1.1.6.2 BP1 (2 of 7) Oracle Real Time Decisions Patch 13960955 - 11.1.1.6.2 BP1 (3 of 7) Oracle Business Intelligence Publisher Patch 14226993 - 11.1.1.6.2 BP1 (4 of 7) Oracle Business Intelligence ADF Components Patch 14228505 - 11.1.1.6.2 BP1 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x Patch 13867143 - 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence Patch 14142868 - 11.1.1.6.2 BP1 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer This is the first full cumulative patch bundle for 11.1.1.6, and will also synch up with fixes from 11.1.1.5. It can be installed on top of 11.1.1.6.0, 11.1.1.6 PSE1 or 11.1.1.6.2 The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. The instructions to apply the above patches are identical, and are contained in the Readme file for Patch 14223977. There are some new features: A new mobile app and features for mobile customers Improved charting and graphing, including Trellis charts Exalytics certification Note on the Mobile app: client app is available on iTunes AppStore now.  But, this app only works with the 11.1.1.6.2 BP1 server.  It is NOT backwards compatible.  So, you must use it with the 11.1.1.6.2 BP1 server.
11.1.1.6.3 - for Fusion Applications only		End of July - delayed	This version will contain OBIEE fixes specific for Fusion Applications only.  Thus, this version would not benefit standard OBIEE upgrade customers - they would even be advised to NOT install this version. Standard OBIEE customers should patch to 11.1.1.6.8 or above This version does not have all the 11.1.1.6.2 BP1 fixes.
11.1.1.6.4	Patch 14538078 Patch 14538128 Patch 14285344 Patch 14538164 Patch 14415773 Patch 14405222 Patch 14409674 as well as Patch 13952743	21st Sept 2012	This is the currently suggested Patch Set - even if there is a problem you encounter, and cannot find it in the list of fixes. List of Patches: Patch 14538078 Patch 11.1.1.6.4 (1 of 7) Oracle Business Intelligence Installer Patch 14538128 Patch 11.1.1.6.4 (2 of 7) Oracle Real Time Decisions Patch 14285344 Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher Patch 14538164 Patch 11.1.1.6.4 (4 of 7) Oracle Business Intelligence ADF Components Patch 14415773 Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x Patch 14405222 Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence Patch 14409674 Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2 patchsets. However, lists of fixes from included patchsets need to be looked up in the respective patches readme files, and are not included in the above patches' readme files The instructions to apply the above patches are identical, and are contained in the readme file for patch 14538078. Please bear in mind, that the readme states to apply a separate patch 13952743 to JDeveloper, too
11.1.1.6.5	Patch 14696072 Patch 14733356 Patch 14678543 Patch 14733390 Patch 14733413 Patch 14665284 Patch 14733370 as well as Patch 13952743	19th October 2012	This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X). Patch 14696072 (1 of 7) Oracle Business Intelligence Installer. Bug 14696072 Patch 14733356 (2 of 7) Oracle Real Time Decisions. Bug 14733356 Patch 14678543 (3 of 7) Oracle Business Intelligence Publisher Bug 14678543 Patch 14733390 (4 of 7) Oracle Business Intelligence ADF Components. Bug 14733390 Patch 14733413 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. Bug 14733413 Patch 14665284 (6 of 7) Oracle Business Intelligence Bug 14665284 Patch 14733370 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer. Bug 14733370 Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2 and 11.1.1.6.4 patchsets. However, lists of fixes from included patchsets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for patch 14696072. Please bear in mind, that the readme states to apply patch 13952743for JDeveloper, too. When downloading, please select the 11.1.1.6.0 release of this Patch rather than the 11.1.1.6.5 release.
11.1.1.6.6	Patch 15844023 Patch 15844066 Patch 14800665 Patch 15843961 Patch 15844096 Patch 14791926 Patch 15839347 as well as Patch 13952743	26th November 2012	This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X).     Patch 15844023 (1 of 7) Oracle Business Intelligence Installer.     Patch 15844066 (2 of 7) Oracle Real Time Decisions.     Patch 14800665 (3 of 7) Oracle Business Intelligence Publisher.     Patch 15843961 (4 of 7) Oracle Business Intelligence ADF Components.     Patch 15844096 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x.     Patch 14791926 (6 of 7) Oracle Business Intelligence.     Patch 15839347 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4 and 11.1.1.6.5 patch sets. However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for patch 15844023. Please bear in mind, that the readme states to apply patch 13952743for JDeveloper, too.
11.1.1.6.7	Patch 15959887 Patch 15959877 Patch 15929063 Patch 15959899 Patch 15959861 Patch 15894670 Patch 15959917	31st December 2012	This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X).     Patch 15959887 (1 of 7) Oracle Business Intelligence Installer.     Patch 15959877 (2 of 7) Oracle Real Time Decisions.     Patch 15929063 (3 of 7) Oracle Business Intelligence Publisher.     Patch 15959899 (4 of 7) Oracle Business Intelligence ADF Components.     Patch 15959861 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x.     Patch 15894670 (6 of 7) Oracle Business Intelligence.     Patch 15959917 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5 and 11.1.1.6.6 patch sets. However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for patch 15959887. Please bear in mind, that the readme states to apply patch 13952743for JDeveloper, too.
11.1.1.6.8	Patch 16094198 Patch 16094192 Patch 16080520 Patch 16094205 Patch 16094211 Patch 16067995 Patch 16097082	5th February 2013	This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X). Patch 16094198 (1 of 7) Oracle Business Intelligence Installer. (generic) Patch 16094192 (2 of 7) Oracle Real Time Decisions. (generic) Patch 16080520 (3 of 7) Oracle Business Intelligence Publisher. (generic) Patch 16094205 (4 of 7) Oracle Business Intelligence ADF Components. (generic) Patch 16094211 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port-specific) Patch 16067995 (6 of 7) Oracle Business Intelligence. (port-specific) Patch 16097082 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer  (generic) Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6 and 11.1.1.6.7 patch sets. However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for patch 16094198. Please bear in mind, that the readme states to apply patch 13952743for JDeveloper, too.
11.1.1.6.9	Patch 16287811 Patch 16287778 Patch 16237960 Patch 16287840 Patch 16287854 Patch 16227549 Patch 16287884	8th March 2013	This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X). Patch 16287811 (1 of 7) Oracle Business Intelligence Installer. (generic) Patch 16287778 (2 of 7) Oracle Real Time Decisions. (generic) Patch 16237960 (3 of 7) Oracle Business Intelligence Publisher. (generic) Patch 16287840 (4 of 7) Oracle Business Intelligence ADF Components. (generic) Patch 16287854 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port-specific) Patch 16227549 (6 of 7) Oracle Business Intelligence. (port-specific) Patch 16287884 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer  (generic) Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7 and 11.1.1.6.8 patch sets. However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for Patch 16287811 Please bear in mind, that the readme states to apply Patch 13952743for JDeveloper, too.
11.1.1.6.10	Patch 16504136 Patch 16504143 Patch 16504148 Patch 16504154 Patch 16504156 Patch 16427939 Patch 16504161	30th April 2013	This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X). Patch 16504136 (1 of 7) Patch (1 of 7) Oracle Business Intelligence Installer (BIINST) (generic) Patch 16504143 (2 of 7) Patch (2 of 7) Oracle Real Time Decisions (RTD) (generic) Patch 16504148 (3 of 7) Oracle Business Intelligence Publisher (BIP) (generic) Patch 16504154 (4 of 7) Oracle Business Intelligence ADF Components (BIADFCOMPS) (generic) Patch 16504156 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x (BIFNDNEPM) (port-specific) Patch 16427939 (6 of 7) Oracle Business Intelligence: (OBIEE) (port-specific) Patch 16504161 Patch (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (generic) Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7, 11.1.1.6.8 and 11.1.1.6.9 patch sets. However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for Patch 16504136 Please bear in mind, that the readme states to apply Patch 13952743for JDeveloper, too.
11.1.1.6.11	Patch 16747681 Patch 16747684 Patch 16747692 Patch 16747699 Patch 16747703 Patch 16717325 Patch 16747708	June 28th, 2013	Patch 16747681 (1 of 7) Patch (1 of 7) Oracle Business Intelligence Installer (BIINST) (generic) Patch 16747684 (2 of 7) Patch (2 of 7) Oracle Real Time Decisions (RTD) (generic) Patch 16747692 (3 of 7) Oracle Business Intelligence Publisher (BIP) (generic) Patch 16747699 (4 of 7) Oracle Business Intelligence ADF Components (BIADFCOMPS) (generic) Patch 16747703 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x (BIFNDNEPM) (port-specific) Patch 16717325 (6 of 7) Oracle Business Intelligence: (OBIEE) (port-specific) Patch 16747708 Patch (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (generic) Note: The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7, 11.1.1.6.8, 11.1.1.6.9 and 11.1.1.6.10 patch sets. However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files. The instructions to apply the above patches are identical, and are contained in the readme file for Patch 16747681 Please bear in mind, that the readme states to apply Patch 13952743for JDeveloper, too.

Read More

OBIEE 11g - Application Roles Migration from Dev To Prod

1) To migrate security there is a WLST method called as MigrateSecurityStore which can move the roles from one system-jazn-data.xml to the other. To do that, we need to first copy the system-jazn-data.xml from Dev instance to the Prod instance (to a temporary directory). In the same way copy the system-jazn-data.xml from the Prod instance to the temporary directory.

2) Take a backup of all these files before doing the migration. Now, copy the jps-config.xml from any one of the instances (Dev or Prod) to the temporary Directory. And rename the file to jps-config-policy.xml.

3) Open up the jps-config-policy.xml. You will notice that this file contains all the details about all the stores in the environment. Now, for policy migration, we need to basically use this file to point to the locations of the Dev and Prod (source & target) system-jazn-data.xml files. Also, since we are doing only policy migration, we do not need the other store related tags within this file. Remember that we are modifying only a copy of the jps-config.xml. This copy file will be used only for migration.

You will need the following lines for migration:

<!-- JPS XML Policy Store Service Instance -->


<serviceInstance name="policystore.xml" provider="policystore.xml.provider" location="c:/temp/dev/system-jazn-data.xml">
<description>File Based Policy Store Service Instance</description>
</serviceInstance>


<serviceInstance name="policystore.xml" provider="policystore.xml.provider" location="c:/temp/prod/system-jazn-data.xml">
<description>File Based Policy Store Service Instance</description>
</serviceInstance>

4) Now that we have our jps-config file ready, navigate to the temporary directory from command prompt and initialize the WLST using the following command.

In WLST, application role migration can be done even in offline mode. So, effectively there is no need for us to connect to the weblogic admin server. In offline interactive mode, fire the following command

migrateSecurityStore(type=”appPolicies”, srcApp=”obi”, configFile=”C:/SecurityMigration/jps-config-policy.xml”, src=”sourceFileStore”, dst=”targetFileStore”, overWrite=”false”) 

Read More

OBIEE 11g - Adding Custom URLs to the Dashboard

Adding some static URLs like Oracle Home page and Google to the other set of URLs. 

The steps are listed below

1.   Go to {Oracle_Home}\web\msgdb\messages file commonuitemplates.xml 

2.   Search for the web message kuiMainBarActionsTable and add the below listed lines immediately after the tr tag.

      <td class=”DashBarProductCell”><a href=”http://oracle.com” target=”_blank”>Oracle Home</a></td>
<td class=”@{classPrefix}Sep”>-</td>
<td class=”DashBarProductCell”><a href=”http://google.com” target=”_blank”>Google</a></td>
<td class=”@{classPrefix}Sep”>-</td>

      

So, what this does is it adds 2 new URLs to the existing layout. But remember this will affect the UI for all the users.

3.   Save the file and restart presentation services. Now, you should have these 2 new links added to the dashboard.

      

This can be useful if you dont have any other option but to add the links for all the users.

For Email-

In step 2, you can add the below HTML immediately after the <tr> tag.
<td class="@{classPrefix}ActionCell"><a href="mailto:groupname@mycompany.com" target="_blank">Mail Link</a></td><td class="@{classPrefix}Sep">-</td>

Read More

OBIEE 11g - Upgrade from 11.1.1.6.X to 11.1.1.7 on linux

In this example I am taking OBIEE 11.1.1.6   and upgrading it to  OBIEE 11.1.1.7 Version.http://docs.oracle.com/cd/E28280_01/upgrade.1111/e16452/toc.htm.

High-level upgrade path is as follows
There is a  chapter in the upgrade document which says

"Moving from 11.1.1.3, 11.1.1.5, or 11.1.1.6 to 11.1.1.7".

This is you starting point.

http://docs.oracle.com/cd/E28280_01/upgrade.1111/e16452/bi_plan.htm#BABECJJH

Step 1: 

Stop all the  OBIEE Stack

Step 2: Patching Weblogic

As we are going to the latest OBIEE. I want to patch the weblogic to the latest version.
We  have a default weblogic 10.3.5 which came from default OBIEE 11.1.1.6.0 Installation.
I am here trying to patch the weblogic 10.3.5  to 10.3.6.

Why to patch the endeca ?Another  Reason to upgrade weblogic?

If you are planning to use Endeca  better upgrade the weblogic right now... see the screen shot below. Endeca supports  10.3.6

Note : What versions of weblogic is supported for  OBIEE

  

Patch number  13529623 is required to patch the weblogic from 10.3.5 to 10.3.6, download it from oracle support.

Run the following command to start the upgrade process

That's it we have patched the Weblogic Server


Step 3 : Upgrading the BI Domain

For this one you have to download the OBIEE 11.1.1.7.0  Software(bishiphome)

   
Linux Tip :  If you want to unzip all the Linux files at the same time use the following command

Go to software Location unzip the files : unzip  '*.zip'

Run the installer ./runinstaller

Click Finish and you are done with  Installation.

Step 4:

Start the Node Manager and Weblogic in linux

U01/app/oracle/middleware/wlserver_10.3/server/bin
./srartNodeManager.sh

Start Weblogic

U01/app/oracle/Middleware/user_projects/domains/bifoundation_domain
./startWebLogic.sh

 
Step 5: Upgrading MDS and BIPLATFORM Schemas

Starting the  Patch set assitant

U01/app/oracle/Middleware/oracle_common/bin
./psa

Databse Type : Oracle
Connection String : localhost:1521/orcl
DBA User Name : sys as sysdba
DBA Password: sys
Schema userName : DEV_MDS/password (enter earlier password while installed first time)

Click on the connect button it will automatically populate the MDS Schema Details
*Enter the DEV_BIPLATFORM   Schema password you gae during the OBIEE installation and click " NEXT"*

Step 5:  For all the remaining steps in the oracle documentation  ( 6-14)  As said in the document we are gonna use Configuration Assistant.


u01/app/oracle/Middleware/oracle_BI1/bin

./config.sh

Host Name : Locahost

Port No : 9704

User Name : weblogic

Password : weblogic123

That's it done with  configuration

You can now login to OBIEE URL

 http://localhost:9704/analaytics

 Oracle Business Intelligence  Banner etc are misssing... If you have the same problem flush your cache....

After clearing the cache everything looks good.

Even Weblogic is upgraded to the 10.3.6

The only part I am missing is as follows

Need to do some more reading.... I know while installing OBIEE... we all select the RTD option as below...

Will do some research  on upgrading RTD ( Real -Time Decisions) 

Read More