web analytics

Tagged: BI Publisher

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...

Level Based Measure and Report Totals in OBIEE 11G

Level Based Measure and Report Totals in OBIEE 11G

A level-based measure is a column whose values are always calculated to a specific level of aggregation. The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column. Level-based measures allow: to...

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...

Oracle BI Publisher Installation on Windows

Oracle BI Publisher Installation on Windows

Note: This guide covers installation steps for Windows 7, 8, 8.1 and Windows Server 2012 (Tried and Tested). Make sure you have “Microsoft Visual C++ Redistributable “installed on your system. Prerequisite: Java SDK 6...

error: Content is protected !!