Home » Posts tagged "OLAP"

Posts Tagged ‘OLAP’:


How Oracle DBA’s can avoid Software License Non-Compliance due to feature usage

Oracle licensing is a complex subject. A complete policy guide for the database alone runs over 130 pages, and contains a lot of details which are easily misconstrued by even the most experienced users. The Cintra team often come across new customers who have unknowingly created a license compliance issue, either due to being unaware

(Read More…)

OBIEE – Configuring Multiple Repositories and Presentation Service in the same Machine

Published by in BI & ETL, OBIEE on December 16th, 2009

This chapter explains how to go about setting up multiple Oracle BI presentation services, each configured to access a different repository file (RPD) running on the BI Server. The thing is that you can easily set up the BI server so that it manages more than one RPD file. This is done by the follow

(Read More…)

OBIEE – Checking Global Consistency before saving

Published by in BI & ETL, OBIEE on December 16th, 2009

When you save the repository, make sure the system will check the Global Consistency first. NOTE:  YOU MUST REMOVE ALL ERROR AND WARNING PROBLEMS.  THE WARNING MESSAGES CAN CAUSE PROBLEMS WHEN YOU DESIGN THE REPORTS.

OBIEE – Defining Presentation Column Names

Published by in BI & ETL, OBIEE on December 16th, 2009

Define the friendly column names to make easier the users interpretation. Don’t use the same name defined on the Logical Column name. See the example below:

OBIEE – Defining Presentation Catalog and Presentation Tables

Published by in BI & ETL, OBIEE on December 16th, 2009

Defining friendly Presentation Catalog name to make easier the users understand what the purpose of this catalog is. Define the Presentation Tables using the follow rules: Don’t drag and drop the all logical tables without any customization. As a good practice, create as minimal tables as possible. Try to create consistent tables with the dimensions

(Read More…)

OBIEE – Defining Aggregation method for each metric

Published by in BI & ETL, OBIEE on December 15th, 2009

Define the aggregation method for the metrics in you fact tables. See image below:

OBIEE vs OBISE1

Published by in BI & ETL, OBIEE on December 14th, 2009

A simple one today, but a question I get asked regularly is the difference between OBIEE+ and OBISE1. OBISE1 is a cut down version of OBIEE+ designed to cater for entry level deals however both are based on the same technology platform. The differences between the 2 are: OBIEE+ Can be licenced either by Named

(Read More…)

OBIEE – Oracle BI EE 10.1.3.3.2 – Connectivity to Essbase – First Impressions

I had some time today to quickly install Essbase and BI EE 10.1.3.3.2 to test out the newly added feature of Essbase connectivity. Following are the list of bare minimum components that you would need to get this up and running. 1.   BI EE 10.1.3.3.2 – If you are doing an upgrade from an earlier release

(Read More…)

OBIEE and Essbase – Defining OLAP Integration

In this second part of our OBIEE series, the integration between OBIEE and Essbase is a seamless transition from our OLAP cube to the OBIEE suite managed by using OBIEE’s Administration Tool. This Administration tool has been designed with wizards, utilities, and interface design elements to help administrators work more efficiently. Using an existing Essbase

(Read More…)

© This website and its content is copyright of © Cintra Software and Services 2011. All rights reserved.