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

Blog

Alias table within the BI physical layer

When you are starting to put together a business layer from a physical data layer that has tables with self-referential integrity, you may find aliasing the table helpful in laying out the clean data model. The example below uses an EMPLOYEE to MANAGER relationship on the EMPLOYEE table where the MANAGER_ID references back to the
  • BIP, OBIEE, Oracle
  • Posted by Zafar Ali / Posted on 23 Nov / 0 Comments
  • Read More

MULTIPLE FACT TABLES in OBIEE 11g

This aspect of OBIEE seems to cause a fair amount of confusion and I have seen some slightly odd ways to try and achieve it – mostly through complex logical modelling with two or more logical tables sources for a fact. But when you look at this in the right way it’s not that hard.
  • Posted by Zafar Ali / Posted on 19 Nov / 0 Comments
  • Read More

OBIEE Writeback with Dropdown field

Recently i had a unique requirement of making Writeback with Dropdown in OBIEE 11g – unfortunately OBIEE 10g/11g does not have any such feature by default. I wont cover setting up Writeback in this blog, refer to my other blog to understand the preliminary steps require to setup Writeback in OBIEE. In this blog we
  • BIP, OBIEE, Writeback
  • Posted by Zafar Ali / Posted on 24 Oct / 0 Comments
  • Read More

OBIEE connection with Oracle DVD

I have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance and take you through some of the things I learned
  • Posted by Zafar Ali / Posted on 19 Oct / 0 Comments
  • Read More

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