WikiNote

The Go URL to manage Answers Saturday, 6 February 2010, 6:18 pm
About The Go URL is used to : * add an answer in your favorites, * link an answer to an other answer * issue sql * pass filters * integrate an answers into an external Web site * generate the result d. […]
Essbase - ASO/BSO Storage Saturday, 6 February 2010, 6:10 pm
Storage type Essbase support two storage type : * block storage * and aggregate storage as a persistence mechanism for multidimensional databases. Aggregate storage databases enable dramatic improveme. […]
Essbase - Aggregate Storage Saturday, 6 February 2010, 6:03 pm
About Essbase provides an aggregate storage kernel as a persistence mechanism for multidimensional databases. Aggregate storage database are optimized for sparse data set that primarily require simple. […]
Essbase - BSO Access Path Saturday, 6 February 2010, 6:01 pm
About Essbase BSO uses two types of internal structures to store and access data: * data block * and index Article Related Cell Data Access Accessing a cell in the data block does not involve sequenti. […]
OBIEE - Quick Skin and Style customization Friday, 5 February 2010, 4:54 pm
Articles Related Pictures What Location Login page your_skin_directory/b_mozilla_4/bglogon.jpg Banner your_style_directory\s_vgw\b_mozilla_4\bg_banner.jpg Portal Logo Image your_style_directory/portal. […]
OBIEE - Look and feel Customizing (Skin and Style) Friday, 5 February 2010, 4:35 pm
Articles * How to customize the background color of a graph * OBIEE - Skin and style Configuration * OBIEE - Quick Skin and Style customization Documentation / Reference * Customizing the Oracle BI Pr. […]
OBIEE - Skin and style Configuration Friday, 5 February 2010, 4:34 pm
Articles Related Steps Copy an existant skin and style directory In a default installation with OC4J, the skin and style directory are located in this directory: OracleBI_Home\oc4j_bi\j2ee\home\applic. […]
Oracle - Monitoring - created Friday, 5 February 2010, 2:22 pm
Articles * Monitoring Locks * Entreprise Manager Sessions select * from v$session
OBIEE - BI Presentation Server (Dashboard / Answer) - Links to dat:obiee:look_feel:start changed to dat:obiee:skin Friday, 5 February 2010, 2:18 pm
obiee * Oracle Business Intelligence Presentation Services Overview Logical SQL * OBIEE - Logical Sql * OBIEE - How to set a Request variable (SET VARIABLE) ? * OBIEE - Densification with the logical. […]
OBIEE - Backup and important files and directory Friday, 5 February 2010, 11:50 am
Introduction When you need to migrate or to backup an OBIEE installation. You must first now the complete installation process and component involved in order to have a good understanding of all impor. […]
Oracle BI Scheduler/Delivers Configuration Friday, 5 February 2010, 11:45 am
obiee, bi scheduler About This article go through all the minimal steps that you must perform to configure BI Scheduler. OBIEE - BI Presentation Server (Dashboard / Answer)OBIEE - Oracle Business Inte. […]
OBIEE - Oracle Business Intelligence Scheduler / Delivers Friday, 5 February 2010, 11:36 am
Articles * Oracle BI Scheduler/Delivers Configuration * OBIEE - How to configure the Mail server of Scheduler/Delivers * Advanced Publication with Delivers Articles Related Documentation/Reference * O. […]
OC4J - Creation of a Windows Service with Javaservice Friday, 5 February 2010, 11:18 am
Introduction On Windows, when the machine fails and/or is rebooted, OC4J for OBIEE is unavailable for remote commands until a user logs in and starts it. As an solution, you can configure the OC4J pro. […]
Oracle Containers for J2EE (OC4J) Friday, 5 February 2010, 10:21 am
java, web server It's a J2ee web server and is the J2EE runtime component of Oracle Application Server. It's composed with Orion Application Server, so a lot of configuration for Orion Application Ser. […]
ODBC - How to create a DSN connection in Windows Friday, 5 February 2010, 9:21 am
About A step by step guide on how to create an ODBC system DSN connection on Windows Articles Related On Windows * Start > All Program > Administrative Tools > Data Source ODBC * Select the t. […]
Oracle - Date Datatype Wednesday, 3 February 2010, 3:15 pm
Formatting The formatting of a date is controlled by the following parameters : * Oracle - NLS_DATE_LANGUAGE * Oracle - NLS_DATE_FORMAT Articles Related Documentation / Reference * Datetime Format Ele. […]
Oracle - NLS_DATE_LANGUAGE Wednesday, 3 February 2010, 3:14 pm
About NLS_DATE_LANGUAGE is a parameter which control the language used in the date format datatype. Articles Related Example SQL> alter session set NLS_DATE_LANGUAGE = "AMERICAN"; Sessie. […]
Oracle - Database Parameters Wednesday, 3 February 2010, 3:09 pm
About Management ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD' show parameter NLS_DATE_FORMAT Database Initialization / Session Parameters DB_BLOCK_SIZE Value : 16K of 32K (* 1024) This parameter i. […]
Oracle - NLS_DATE_FORMAT Wednesday, 3 February 2010, 3:07 pm
About The parameter NLS_DATE_FORMAT control the format of the date datatype. You can see here to see the different format possible. Articles Related
Oracle Database Wednesday, 3 February 2010, 3:02 pm
Optimizer - the motor of Oracle * Oracle - Query optimizer * Oracle - Execution/Query Plan * Explain Plan * Autotrace * ... * Operation * Join Operation / Method * Access Paths * Hints * Schema object. […]

Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer

October 29th, 2009 by gerardnico

Oracle Warehouse Builder 11g: Getting Started by Robert Griesemer - ISBN 1847195741

Packt Publishing offer me the chance to review this book and I want to thank them as the author Robert Griesemer because writing a book is never an easy task.

The book is a step by step tutorial offering to construct a complete datawarehouse environment from the capture of the data, through their integration to the construction of a cube.

Continue reading “Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer” …

Tags: book, data integration tool, datawarehouse, OWB
Posted in OWB, Uncategorized | No Comments »

OBI Forum Live Second Edition

May 28th, 2009 by gerardnico

I'm going to present in the OBI Forum Live the next week on the 3th Wednesday of Juny 2009.

This second edition is really impressive and as I see that we will have parallel sessions, I'm already very disappointed because I couldn't assist to all presentations :

Multi-Language Dashboards, John Minkjan
Oracle BI EE en Oracle Mapviewer, Daan Bakboord
OBI-EE, The Rising Sun Emiel van Bockel
Understanding the Oracle BI Server Engine, Gerard Braat
Creating Hybrid Essbase/Relational Oracle Business Intelligence Enterprise Edition Logical Models, Mark Rittman

Continue reading “OBI Forum Live Second Edition” …

Tags: OBIEE
Posted in Uncategorized | 2 Comments »

Densification with OBIEE logical Sql (Sparse to dense data)

May 12th, 2009 by gerardnico

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them.

And it's also the most problem that you have when you work with time series calculations as the lag/lead function, is that the data are not dense.

This article show the capability of the OBIEE logical sql to densify the data. To know more about the Obiee logical Sql, you can also read the good post of Venkatakrishnan.

The sample example come from this article : Database - Data Densification (sparse to dense data) and the sql below is a translation in OBIEE logical sql of the densification solution with cross and right outer join.

Continue reading “Densification with OBIEE logical Sql (Sparse to dense data)” …

Tags: dense, densification, OBIEE, sparse, sql
Posted in OBIEE | 3 Comments »

Obiee - How to configure the Mail server of Oracle BI Scheduler/Delivers

April 26th, 2009 by gerardnico

This article talk about the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as :

the sender address
the smtp server
the smtp port

Continue reading “Obiee - How to configure the Mail server of Oracle BI Scheduler/Delivers” …

Tags: bi_scheduler, OBIEE, smtp
Posted in OBIEE | No Comments »

OBIEE and Apex Integration

April 25th, 2009 by gerardnico

You may have sometime to change some data in your application.

Apex is a great tool that allow you to develop and deploy rapidly a web based application.

Here for our example, we must access to a vendor Apex form to change some values on it.

Our goal is to have the report below in OBIEE with one link by vendor that points to the Apex vendor form and that the Apex form show us the data of the vendor.

Continue reading “OBIEE and Apex Integration” …

Tags: apex, OBIEE
Posted in OBIEE | No Comments »

Obiee - Period to period comparison with the analytical function Lag/Lead

April 17th, 2009 by gerardnico

During this thread on the Obiee forum, Goran point out a solution for a period to period comparison with the analytical function lag. It was time for me to drill down in this analytical function and to compare it with the obiee time function : ago.

lag and lead are analytical functions that can be used to get the value of a column in a previous/next row. More …

Attention : Your data must be dense to have a correct result. See the paragraph with sparse data. If you don't have dense data, you can always use the Obiee Ago Function

Continue reading “Obiee - Period to period comparison with the analytical function Lag/Lead” …

Tags: ago, analytic function, OBIEE, time function
Posted in OBIEE | 1 Comment »

Obiee - A special subject area to handle the dashboard parameters prompts

April 17th, 2009 by gerardnico

All the prompts in OBIEE are column based prompt. You can't create a prompt if you don't select a column. And as it's the only way to set up a variable for a formula, it's impossible to bypass this constraint.

In our case, we don't care about the value in the dimension column as we want parameter values as for instance the hierarchy level :

The idea behind the scene is :

to create a column which is on the top of a dual view (or skinny table) in the physical layer.
to create a dummy business model because BI Server requires us to have a minimal of one logical join.
to create a special subject area (presentation catalogue) to separate the functional of the parameters columns
to be able to choose this column in order to create one or several others parameter prompts.

The advantages of this solutions are that :

as you query a skinny table (or dual view), the performance are very good
as you use a column, you can translate in other languages the label of the parameter prompt
you can add a parameter value without changing the original dashboard prompt

Continue reading “Obiee - A special subject area to handle the dashboard parameters prompts” …

Tags: dashboard prompt, OBIEE
Posted in OBIEE | 4 Comments »

Obiee - How to suppress detail rows of a master group in a pivot view ?

April 10th, 2009 by gerardnico

You have detail row of a group in a pivot table that you want suppress as this :

We have two solutions :

if you don't need a total by “promo Category” (by post or by internet), you can create a new dimension with a formula
if you want a total by “promo Category”, we must perform a cross conditional formatting. One each column, we must add this conditional statement.

if "promo category" = internet then suppress the value

Continue reading “Obiee - How to suppress detail rows of a master group in a pivot view ?” …

Tags: css, OBIEE, pivot
Posted in OBIEE | No Comments »

Obiee - How to mix string and number data type in one column and get a sum ?

April 9th, 2009 by gerardnico

Sometimes, you want to mix number and string data type in one column because you want to send a conditional message :

For instance, :

if value > 1000, write “To Big” else value
if value is null, write “No Data” else value

If you write a function, on this way as :

CASE WHEN  Measures."Count Passed" IS NULL THEN 'No Data' ELSE Measures."Count Passed" END

You will have this error :

[nQSError: 10058] A general error has occurred. [nQSError: 22027] Union of non-compatible types. (HY000)
SQL Issued: SELECT "Business Rule"."Rule Name", CASE WHEN Measures."Count Passed" IS NULL THEN 'No Data'
ELSE Measures."Count Passed" END,  Measures."Count Passed" FROM "MDM Vendor"
nQSError: 10058 A general error has occurred. nQSError: 22027 Union of non-compatible types. (HY000)

If you have already used a software as crystal report, you can't mix of course two types of data in one field but you can have two fields one above the other. It's why I have done in this solution.

But with css, we can go further and have a single column.

How ?