Remove Carriage Return In Linux

Error Message:
/bin/bash^M: bad interpreter: No such file or directory

Solution:
sed -i -e 's/\r$//' Filename

Till Next Time..

Unset your existing ORACLE_HOME variable

Recently I got this error message when tried to install OBIEE 11.1.1.7.0 on Linux machine.

Error Message

INST-08109: An ORACLE_HOME environment variable should not be defined

Solution:

Unset your existing ORACLE_HOME variable by using one of the following commands.

• C Shell:

  prompt> unsetenv ORACLE_HOME

•   Bourne/Korn shell:

  prompt> export ORACLE_HOME=

After Unset ORACLE_HOME variable we can continue OBIEE installation

Till Next time.

Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

After upgrade to bundle patch set 11.1.1.6.2 The new SQL generated by the .RPD file aggregates data incorrectly.

Solution

1)      Take a copy of the 11.1.1.6.0 .RPD file (repository version 318)

2)      Open the 11.1.1.6.2 version of the Admin tool  (repository version 320)

3)      Open the 11.1.1.6.0 version of the .RPD file with the 11.1.1.6.2 version of the Admin tool.

4)      Save the .RPD file and upload it.

Note that opening a copy of the .RPD file from the upgraded (11.1.1.6.2) OBIEE server will not work.  The version of that RPD is already 11.1.1.6.2, so the 11.1.1.6.2 Admin tool will not “upgrade” it to the current version.  You need to use the 11.1.1.6.0 RPD.

Reference:

http://www.biztech.com/blog/2012/10/obiee-11-1-1-6-2-issues/

Till next time...

Error while generate DAC parameters

Issue:

Error while generate DAC parameters

BIDEV Financial Analytics

MESSAGE:::No physical folder information found for SILOS_DEV

EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.design(ExecutionPlanDesigner.java:1322)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:169)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:119)

com.siebel.analytics.etl.client.view.table.EtlDefnTable.doOperation(EtlDefnTable.java:169)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)

com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

Solution:

Go to Tools->Seed Data->Task Physical Folders -> add new physical folder, name it with SILOS_DEV

Till next time...

OBIEE 11.1.1.6.2 BP1 Patchset is released

OBIEE 11.1.1.6.2 BP1 is now available on My Oracle Support.

The Oracle Business Intelligence 11.1.1.6.2 BP1 patchset comprises of the below patches: 

1.     14223977 Patch 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer

2.     14226980 Patch 11.1.1.6.2 BP1 (2 of 7) Oracle Real Time Decisions

3.     13960955 Patch 11.1.1.6.2 BP1 (3 of 7) Oracle Business Intelligence Publisher

4.     14226993 Patch 11.1.1.6.2 BP1 (4 of 7) Oracle Business Intelligence ADF Components

5.     14228505 Patch 11.1.1.6.2 BP1 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x

6.     13867143 Patch 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence

7.     14142868 Patch 11.1.1.6.2 BP1 (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. 
•    The instructions to apply the above patches are identical, and are contained in the Readme file for Patch 14223977.

Reference: 

https://blogs.oracle.com/proactivesupportEPM/entry/obiee_11_1_1_64

Till next time...

Set Numbers of row per page

Some of peoples maybe ask this question why by default OBIEE only show 25 rows per page for table or pivot. Maybe some of you want to change number of this row as you needed. This step show you how to do that

At the report level, edited the table view property set number of Rows Per Page you want to show. For example you may want to show 100 rows per page, then set on Rows per Page to value 100

 

 

 

Till Next Time

Export / Import Repository metadata

Export Repository metadata
Tools->DAC Repository Management -> Export
Export file C:\Oraclebi\DAC\bifoundation\dac\export

Import Repository metadata

Tools->DAC Repository Management -> Import



Till next time