Home » 2009 » December

December, 2009:


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

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

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

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

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

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…)

Backing Up and Restoring Your MySQL Database

Backing Up and Restoring Your MySQL Database Do you need to change your web host or switch your database server? This is probably the only time when you really think of backing up your MySQL data. If you’ve got a website with a database or your custom database running for your applications, it is imperative that you

(Read More…)

Ten MySQL Best Practices

MySQL is a complex piece of software that may seem overwhelming when you’re first trying to learn it. This article describes a set of best practices for MySQL administrators, architects, and developers that should help in the security, maintenance, and performance of a MySQL installation. 1. Set a password for the “root” user and then

(Read More…)

MySQL Administrator Best Practices

Database administration serves a number of important functions from improving the performance of your database to avoiding a disaster that would result in lost data or costly system downtime. This article will describe some of the fundamental tools and practices programmers, as well as DBAs and SysAdmins, can use with the powerful new MySQL Administrator

(Read More…)

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