18 Northdown Road Nottingham NG8 3PF
Phone: +44-7971726521
Follow us:

Blog

Connect OBIEE with Tableau

Introduction The How to connect to Oracle BI server using ODBC article discusses an approach that uses Oracle ODBC driver to connect from Tableau to OBIEE. However, this approach poses several challenges in an enterprise deployment. This article discusses the pitfalls of using ODBC driver and explains how BI connector, a purpose built Tableau to OBIEE connector, makes
  • BI, BIP, Business Intelligence, Data Visualization, OBIEE, obiee11g, tableau
  • Posted by Zafar Ali / Posted on 12 Oct / 0 Comments
  • Read More

Federated Data Models in BI Publisher 11g

BI Publisher has always had the ability to create reports using multiple data sets, either through appending queries together or by combining them using something called a “data template”. Data Templates were tricky to set up though, so I was interested when looking through the new features in BI Publisher 11g to note that creating
  • Posted by Zafar Ali / Posted on 13 Sep / 0 Comments
  • Read More

IMPROVING SPECIFIC REPORT PERFORMANCE

OBIEE 11g analysis has query performance option to “Share query with multiple users” Tip: This option is more to do with BI Presentation Server Cache. This has no impact on settings saved for BI Server Query Cache. To enable this option, * Analysis’ Advanced tab * In the bottom of the page select “Share query
  • Posted by Zafar Ali / Posted on 01 Sep / 0 Comments
  • Read More

DISABLE CACHE FOR A PARTICULAR REPORT

This will be a quick post – Let’s say we have a requirement where we want to disable caching only at the Report Level, i.e to say – for a specific Report, we don’t want to refer to Cache. Simply, Go to advance tab, In the prefix section, paste SET VARIABLE DISABLE_CACHE_HIT=1; click on apply
  • Posted by Zafar Ali / Posted on 01 Sep / 0 Comments
  • Read More

If a column is deleted from a RPD, what reports will be affected

In general every OBIEE Application user/developer needs to know the origin of the data displayed on reports. The general questions that everyone looks for answers to understand their application are: How the report columns are defined back in metadata? What are the OBIEE objects (Analysis, BIP Reports, Prompts and filters etc.) that are being referenced
  • Posted by Zafar Ali / Posted on 01 Sep / 0 Comments
  • Read More

OBIEE Metadata Dictionary in 11g

This is the definitive guide to generating and installing the OBIEE metadata into your OBIEE 11g environment. Some blogs claim to do this too. But, they seem prone to errors… Step 1. Generate the Metadata from the Admin Tool. I used the 11.1.1.7.141014 version. Repository version 326. You can only generate the metadata in offline mode.
  • Posted by Zafar Ali / Posted on 01 Sep / 0 Comments
  • Read More

Integrating OBIEE with Microsoft Office Using Oracle Smart View

This article describes the steps to integrate OBIEE with Microsoft Office using Oracle Hyperion Smart View For Office. Download Smart View using any one of the option below: Option 1: From the Oracle BI EE “Home page”-> In the Get Started section, click the Download BI Desktop Tools link, then select ‘Smart View for MS
  • hyperion, Microsoft, OBIEE, office, Oracle, smart view
  • Posted by Zafar Ali / Posted on 11 Aug / 1 Comments
  • Read More

CONVERT ORACLE FORM TO APEX USING FRMF2XML UTILITY

If you want to use your Oracle Form’s functionality in Oracle Apex application then you need to convert first Oracle Form into XML using frmf2xml utility in Oracle Forms 11g and then you need to create a migration project into Oracle Apex. Below are the steps given to perform this task. 1. Convert Oracle Form
  • Apex, oracle form
  • Posted by Zafar Ali / Posted on 06 Aug / 0 Comments
  • Read More

Oracle Cloud

  • Cloud, Database, Oracle, oracle 12c
  • Posted by Zafar Ali / Posted on 14 Jul / 0 Comments
  • Read More

Identity Column in Oracle 12c

Previous releases of the Oracle database, there was no substitute of the AutoNumber or Identity functionality like other database (SQL Server, MySQL etc). Same behaviour was implemented using a combination of sequences and triggers. However, Oracle 12c now introduces two alternatives 1) identity columns and 2) the ability to use sequence pseudocolumns as default values. This
  • Posted by Zafar Ali / Posted on 27 Jun / 0 Comments
  • Read More

MULTIPLE FACT TABLES

My current blog  looks at the logical or business model.  In particular how to connect fact tables so that you can get numbers from more than one fact in the same report – and actually show results. This aspect of OBIEE seems to cause a fair amount of confusion and I have seen some slightly
  • BI, BIP, OBIEE, obiee11g, Oracle, Tips & Tricks
  • Posted by Zafar Ali / Posted on 06 Jun / 0 Comments
  • Read More

OBIEE conditional format using arrows

OBIEE conditional format using arrows was sought. Let’s start with the basic report: Calculate the delta: Add two conditional formats: Add the correct images: Set it to image only: There you go:
  • BIP, Month Ago, OBIEE, Trending
  • Posted by Zafar Ali / Posted on 03 Jun / 0 Comments
  • Read More

Configuring and Customizing Map Viewer – OBIEE 11G pt2

Download NAVTEQ sample data from the below path: http://www.oracle.com/technetwork/middleware/mapviewer/downloads/navteq-lic-168395.html Link to download or buy map data from different vendors: http://www.oracle.com/technetwork/database/options/spatial/downloads/partners/spatial-partners-data-087203.html#navteq Step 1: Download NAVTEQ data Go to the below link: http://www.oracleimg.com/technetwork/testcontent/o31bi-354140.html Create a folder c:\Sample_data and extract or unzip the contents of both the file into this folder location. Step 2: Connecting to SQLPLUS Go
  • Posted by Zafar Ali / Posted on 14 May / 0 Comments
  • Read More

Hadoop Integration with OBIEE 11g

The newest release of Oracle Business Intelligence 11.1.1.7 shows Oracle’s continued efforts in trying to integrate its Oracle Business Intelligence Platform with big data technologies such as Hadoop and Hive. Specifically, I’m talking about OBIEE 11g’s ability to integrate with a Hadoop Data source. What is Hadoop? Hadoop is a framework that enables data to
  • big data, hadoop, hive, OBIEE
  • Posted by Zafar Ali / Posted on 14 May / 0 Comments
  • Read More

How-to: Mapviewer Integration with OBIEE 11g

I’ve seen quite a few articles on OTN and Google which outline how to configure Mapviewer for your 11g solution.  The problem is that many of these articles are: 1) overly complex 2) out of date With the release of OBIEE 11.1.1.6, mapviewer comes pre-configured with weblogic and the only installation steps required are: installation of
  • Posted by Zafar Ali / Posted on 14 May / 0 Comments
  • Read More

OBIEE – Calculation between results of a union

Some times the data model does not allow you to create a single query to get the results you need. then we are forced to do a Union. (actually they are 4 possible operations Union, Union All, Minus and Intersect). The default is Union. I seldom prefer Union All over Union, since it’s a little
  • Posted by Zafar Ali / Posted on 12 May / 0 Comments
  • Read More

OBIEE with Key / Name / Value table, the Union solution

OBIEE with Key / Name / Value table, the Union solution A customer asked me to create an analysis on top of a Name – Value table. A table where instead of having one row for each key, there are multiple rows with the structure of Key_Value / Attribute_Name/ Attribute_Value. This structure is very nice
  • Posted by Zafar Ali / Posted on 12 May / 0 Comments
  • Read More

Tooltip On Column Headers : OBIEE 11g

In one of our projects we had a requirement of putting tooltip on column header without losing the data format of the column values. Below are the steps: Open an analysis in OBIEE 11g Go to column format of the column where tooltip is required Put HTML tag in column Heading and check Contains HTML
  • Posted by Zafar Ali / Posted on 12 May / 0 Comments
  • Read More