whatisobiee.com

Technorati Tags: OBIEE,Aggregate Persistence Wizard,10g,11g,Aggregates Following up to my previous post, this section looks at what happens under the hood when the logical SQL is executed. the Aggregate Persistence Wizard issues the following logical SQL: create aggregates . We will also look at: delete aggregates; prepare aggregates   Create Aggregates The built-in Aggregate Manager module [...]

Continue Reading How to use the Aggregate Persistence Wizard – Part II – Under the Hood

Tags: Aggregate Manager, Create Aggregates, Delete Aggregates, SQL

Technorati Tags: obiee,10g,nqcmd,aggregates,performance The Aggregate Persistence Wizard is a nifty utility for creating, modelling and populating aggregate tables available in OBIEE 10g and 11g. This utility is especially useful to quickly build a single aggregation layer upon federated heterogeneous physical sources.  OBIEE will create, model and populate aggregate dimensions and facts based upon the intelligence [...]

Continue Reading How to Use the Aggregate Persistence Wizard – Part I

Tags: OBIEE, RPD, tables, Use Case

Changing BI Publisher Default Templates Ever wondered how to change the Shared Templates section when you create a new BI Publisher report ? I did. In fact, these are stored under in the report /Shared Folders/Components/Boilerplates.xdo Click Edit to edit the boilerplate. Then Add New Layout. Make layout changes as necessary, and save as a [...]

Continue Reading OBIEE 11g Publisher Boilerplates

Tags: Add New Layout, Data Model, OBIEE, Shared Templates

In this post, I’ll install a four node OBIEE 10g cluster integrated with Oracle Application Server (for BI Publisher) IIS, and SSO. There will be two “web nodes” which will host IIS, OAS, and the web plugins. These machines will be node01 and node02. There will be two “app nodes” which will host all the [...]

Continue Reading Load Balanced OBIEE 10g Clustered Installation

Tags: Install Oracle Software, OAS, OBIEE, Oracle Application Server

OBIEE 11g Graph colors are quite jazzy comparing to 10g… this is one of the recent feedback we received from clients in our post up-gradation review of codes .So one of the obvious requirement came into picture is that, how do we retain the 1og Graphical color schemes in 11g. This could be easily done [...]

Continue Reading OBIEE 11g Graphical Color Scheme like 10g

Tags: 10g, 11g, Color, Graphical, like, OBIEE, Scheme