`

WikiNote

  1. Linux - X Windows System (commonly X or X11) Saturday, 13 March 2010, 11:07 pm
    About You're using two computers. You're using the X window system of the first to type to and look at. You're using the second to do some important graphical work. You want the second to show its out. […]
  2. Linux - Services Saturday, 13 March 2010, 10:17 pm
    How to manage them ? From the terminal service xinetd start service xinetd stop service xinetd restart From Oracle Entreprise Linux / Red Hat System / Administration / Server Settings / Services Artic. […]
  3. Linux - Cygwin - Unix-like environment under Windows Saturday, 13 March 2010, 10:09 pm
    What Is Cygwin ? Cygwin is a Linux-like environment under Windows. The installation directory (by default, c:\cygwin) is the root of the Unix-like file system, which contains bin, etc, home, tmp, and. […]
  4. Linux / Unix Saturday, 13 March 2010, 9:21 pm
    Distribution and Graphic Environment Linux is an open source software and anyone can take it and create this own Linux (of distribution). It's why you can find a lot of distribution on the market : *. […]
  5. Linux - Nano Saturday, 13 March 2010, 9:20 pm
    About Nano is a file editor. Articles Related How to Start Nano nano /mydirectory/myfile The workspace In the upper left corner, you have the program and it’s version “GNU nano 1.3.12″ In the ce. […]
  6. Linux - How to edit a file? Saturday, 13 March 2010, 9:07 pm
    About To edit a file in the shell mode, you have to use an editor such as: * emacs * vi * pico * gedit * nano Articles Related Snippet To edit the file: emacs file.txt vi file.txt pico file.txt To sav. […]
  7. Linux - Installation of OEL 5 on VMWare 32-bit (x86) machine Saturday, 13 March 2010, 9:01 pm
    About This article is a step-by-step manual to install Oracle Entreprise Linux 5 on a VMware Server. <http://www.vmware.com/appliances/directory/cat/508?k=oracle> Prerequisites * Download the Or. […]
  8. Linux - How to set the $PATH environment variable? Saturday, 13 March 2010, 9:32 am
    About The $PATH environment variable is a list of which directories Linux will search for for executable files. As in DOS, the shell uses the PATH variable to locate a command. PATH contains a list of. […]
  9. EBS - Installation on Linux OEL 5.1 Update 4 Friday, 12 March 2010, 6:22 pm
    Minimal Hardware requirement * OS: Linux (physical or virtual). * Memory: At least 2GB of 3GB would be better and 4GB will the top * File System Space Requirements for Standard Installation: At least. […]
  10. Linux - Environment Variable Friday, 12 March 2010, 6:09 pm
    About Environment variables in the bash shell help you in several ways. Certain built-in variables change the shell in ways that make your life a little easier, and you can define other variables to s. […]
  11. Linux - Vi Friday, 12 March 2010, 6:04 pm
    Introduction To edit files on the command line, you can use an editor such as vi. To open the file, run vi /path/to/file The contents of the file must appear. Articles Related The most important comma. […]
  12. Linux - Command Friday, 12 March 2010, 5:58 pm
    Linux Command To learn more about each command, read its associated man page (for example, type man ls at the shell prompt to read about the ls command). Command Description Network ifconfig To detect. […]
  13. OBIEE - Period to period comparison with the AGO Function Friday, 12 March 2010, 2:54 pm
    About the Ago and the Todate function are set up Articles Related Implementation You can therefore create a logical column in a logical fact table (it's not possible to use them in an answer) with for. […]
  14. OBIEE - How to set up the time dimension Ago and Todate Friday, 12 March 2010, 2:35 pm
    ago, todate, obiee About To use the OBIEE - Time Series Conversion Functions : AGO and TODATE on a particular dimension, you have to designate the dimension as a Time Dimension and set one or more key. […]
  15. Nmap to discover the open port / service Thursday, 11 March 2010, 4:01 pm
    About Nmap ("Network Mapper") is a free and open source (license) utility for network exploration or security auditing. Windows - How to know which program take a port ? How to scan a comput. […]
  16. Sql - Oracle - ROW_NUMBER Thursday, 11 March 2010, 10:34 am
    About The ROW_NUMBER function assigns a unique number (sequentially, starting from 1, as defined by ORDER BY) to each row within the partition. It has the following syntax: ROW_NUMBER ( ) OVER ( [quer. […]
  17. SQL Thursday, 11 March 2010, 10:30 am
    * ORA_HASH Function * View * TO_NUMBER * ROW_NUMBER
  18. OBIEE - Presentation Variables Wednesday, 10 March 2010, 10:54 am
    About The presentation variable is the only variable offer by the presentation service. OBI server variable Articles Related What is the syntax for presentation variables? The syntax for referencing p. […]
  19. OBIEE - Presentation Variable System (reserved variable) Wednesday, 10 March 2010, 10:47 am
    About The presentation service has some presentation variables that are reserved to give specific information. You can use them in your answer such as @{system.currentTime} to filter depending of the. […]
  20. OBIEE - Filter on current time - created Tuesday, 9 March 2010, 1:14 pm
    About How to filter based on the current time the answers. Presentation service has some presentation variables system where you can find the current time in this one: @{system.currentTime} You then j. […]

OBIEE - Dimension fragmentation design to add an automatic filter with the choice of a column

February 13th, 2010 by gerardnico

In response to an original Idea of Venkat with this blog entry: Puzzlers – Puzzle 1

“How do we make BI EE to generate different filters for every column(within a dimension) chosen from Answers?”

The idea is when you add the column Channel desc to an answer the query must be automatically filtered.

You can also found a copy of this entry in the wiki : OBIEE - Dimension fragmentation design to add an automatic filter with the choice of a column

Continue reading “OBIEE - Dimension fragmentation design to add an automatic filter with the choice of a column” …

Tags:
Posted in OBIEE | No Comments »

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: , , ,
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:
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: , , , ,
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: , ,
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: ,
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: , , ,
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 :

  1. to create a column which is on the top of a dual view (or skinny table) in the physical layer.
  2. to create a dummy business model because BI Server requires us to have a minimal of one logical join.
  3. to create a special subject area (presentation catalogue) to separate the functional of the parameters columns
  4. 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: ,
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 :

  1. if you don't need a total by “promo Category” (by post or by internet), you can create a new dimension with a formula
  2. 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: , ,
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 ?

  • using the content property of css
  • using the conditional formatting of OBIEE

Continue reading “Obiee - How to mix string and number data type in one column and get a sum ?” …

Tags: ,
Posted in OBIEE | No Comments »