FETCH FIRST 65001 ROWS ONLY OBIEE 11g

By default OBIEE Analysis returns 65000 records for a report, it can be updated as per your business requirement. Here is the steps to be followed

1. Log into Enterprise Manager (EM)
2. Click on "Business Intelligence"
3. Click on "coreapplication" ->   "Capacity Management" Tab -> "Performance" tab
4. Modify the value "Maximum Number of Rows Processed when Rendering a Table View"
    Lock and edit configuration
    Enter Value as per requirement.
5. Restart Presentation services.

OBIEE 11G - Overwrite maximum number of records in Analysis

In OBIEE 11g maximum number of records to be shown in a reports can be restricted from enterprise manager(em) click here for details, However if someone needs to overwrite the maximum number of records in a report then it can be achieved by adding 

"FETCH FIRST 50000 ROWS ONLY" in the Prefix section Under "Advanced' tab of analysis and Click on "Apply SQL"

*50000 being the custom value, as per the requirement.
 

OBIEE -BI Content Server is down, after creation of Windows services

Content server went down after creating windows services and it never starts. To fix the issue we need add a new environment variable in windows.

BI_ORACLE_HOME=<path_to_middleware>\ORACLE_BI1

DAC Index Actions

Index actions can override the default index behavior for dropping and creating indexes by mode type (full load, incremental load, or both).

Scenario:-By default DAC ETL type INDEX are not parallel and this default behavior of Index creations through DAC is controlled by the file customsql.xml. Any change in the customsql.xml is applied globally to all the indices, so to make it for a particular index – INDEX actions can be used.

Steps to follow

Login to “DAC” and click on “Tools” > “Seed Data” > “Actions” > “Index Actions”

 

Then Create “New” Action give the name

In Value field click on tick then a pop appears in screen then create the two new records one for “Drop Index” and another for “Create Index” then give the SQL statements for each record

 

Create Index SQL Statement

 

Once the index action is created this has to be applied to the columns to which you want to override the default behavior.

Navigate to “Indices” tab in “Design” then query for the Index for which we need to assign the action

Then a pop up appears called “Add Actions”

Then select the action which was created in “Index Actions” and click “OK” . Do this for both the create and Drop Index

Then “Save”

ddlimp utility - Unable to connect to the database.

ddlimp utility failed to connect to database with correct connection details.

ddlimp /U SIEBEL /P ***** /C siebel /G SSE_ROLE /F D:\OBIEE11G\Oracle_BI1\biapps\dwrep\Upgrade\CTLFiles\DDL_OLTP.CTL /L D:\OBIEE11G\Oracle_BI1\biapps\
dwrep\Upgrade\CTLFiles\DDL_OLTP.log

Connecting to the database...
Unable to connect to the database...

Fix:-
Create a USER DSN instead of SYSTEM DSN with the same connection details and use the DSN in ddlimp utility parameters.

OBIA 7.9.6.4 Installation

To download OBIA 7.9.6.4, log into oracle edelivery

https://edelivery.oracle.com

select the below option under Business Intelligence category

Oracle Business Intelligence 11g Media Pack for Microsoft Windows x64 (64-bit)

and download Oracle Business Intelligence Applications 7.9.6.4 for Microsoft Windows  -- V35873-01

Click on setup file and Run as Administrator

Click Next

 

 Select Oracle Home, Instance and domain locations from the OBIEE install folder.

 Enter weblogic user details.

Select components to install and click Next.

 

 

 Click Next

 

Installation process will restart the OBIEE services. This process might take time.

 Starting OPMN components.

 

OBIEE RPD, catalog, informatica repository and DAC code will be available in the biapps folder.

DAC 11G Installation and Configuration- Part1

Create Database User:-

For Sql Server:-
Create a DAC_USER  and add the below permissions to the user.

For Oracle:-
Create a user in the database and grant all privileges to the user.

 Select dac11g_install and Run As Administrator

 

Click Next

 

 Select the folder where Informatica is installed.

 

Select domains.infa file which is under Informatica folder.

 

Create a folder DAC11G and Select that folder to have the DAC installation files.

 

Select appropriate option.

 Select Install

 

Click Done

Click DAC Client to configure

 

Click on configure

Create Connection and Click Next.

 Enter details as shown above and for Authentication . choose create New authentication file.

Click OK

 

 Enter DAC_USER details, user created in the database and click OK

 

(For SQL Server Only) driver is available for Oracle, SQL Server driver has to be downloaded.

Download SQL SERVER driver Executable Jar File and copy jar file in to the lib directory of DAC(sqljdbc4.jar) and rename the file to sqljdbc.jar

 

Test Connection now.

 Create a new connection to log into DAC.

Click on Login

 

Click Yes

Enter DAC_USER details.

 Enter Administrator username and password.

Click on Tools-> DAC Server Management -> Repository Configuration . Change Mode to Standalone