web analytics

Tagged: Oracle

Control Files Oracle 11G

Control file in Oracle is a binary file and defines the current state of Physical Database.It helps maintain Integrity of database. They are required at the MOUNT state during database startup and to operate...

Setup ODBC Connection for OBIEE

Follow the steps below to set up the ODBC Connection. The tool is found here: Load odbcad32 and you’ll get this: Select “Add…” and select the Oracle BI Server and click Finish.

ODBC Vs OCI

ODBC Vs OCI

Differences between ODBC and OCI ODBC: – Open Database Connectivity, which is known as Universal Data Connector. OCI: – Oracle Call Interface, Normally connects to Oracle Source. Hence, both can connect to Oracle Sources....

How to Update Physical Layer Table Columns

How to Update Physical Layer Table Columns

Issue: New columns are added to a table in the database. We want to add these columns to the physical layer table. Possible ways: Drop the previously imported table and re import it again....

Aggregation Rules and Functions

Aggregation Rules and Functions

The following list describes the aggregation rules that are available for measure columns in the “Layout pane” and for columns in the “Edit Column Formula dialog: Column Formula tab”. The list also includes functions...

Total in Report OBIEE

Total in Report OBIEE

If the Report-Based Total option is not selected, then the Oracle BI Server will calculate the total based on the entire result set, before applying any filters to the measure columns. From OBIEE 11g: BI Design Best...

Data Mismatch Issue After Up gradation from OBIEE 10G to OBIEE 11G

Data Mismatch Issue After Up gradation from OBIEE 10G to OBIEE 11G

How to Fix Data Mismatch Issue After Up gradation from OBIEE 10G to OBIEE 11G Hi, there is no clear cut method (I found yet) to fix this issue. The tips and method I...

OBIEE Security ( Oracle BI Publisher )

OBIEE Security ( Oracle BI Publisher )

Security in OBIEE 11g ( also comparison with OBIEE 10g )  Key Security Changes for Release 11g: Some of the key changes in OBIEE security in 11g are 1. User and Groups are no...

Connect WAMP  server with Oracle Database

Connect WAMP server with Oracle Database

Note: Path enviornment variable should not contain any other oracle instant client or php path . Install VC++ 2010,2012 and 2013 before installing wamp.(on 64 bit OS)   1- install wamp server ( 64 bit...

error: Content is protected !!