Friday, March 26, 2010

OBIEE PATCHES 10.1.3.4.1 part 4

Even more patches

Patch ID Description Updated Size
9509684 MERGE REQUEST ON TOP OF 10.1.3.4.1 FOR BUGS 8290868 9356692 9179171 9224649 9413 26-3-2010 41 MB
9492821 MERGE REQUEST ON TOP OF 10.1.3.4.1 FOR BUGS 9280334 9434435 26-3-2010 2.7 MB
9413991 LOGIN CAN FAIL IF LOGIN ATTRIBUTE OR IDENTITY ATTRIBUTE IS MAIL 25-3-2010 720.2 KB
8654779 CR 12-1T21JN1: IE8: NEXT PAGE AND ALL PAGES BUTTONS ARE NOT WORKING IN EDIT VIEW 21-3-2010 7.6 KB
8867841 CR 12-1UR9DLP > EEA >1 0.1.3.3.3:090204:1614 > HEAP MEMORY ALLOCATION ERROR 21-3-2010 82.1 KB
9280334 CALENDAR DD/MM/YYYY PROMPT IN DASHBOARD RETURNING FORMAT YYYY-MM-DD HH:MI:SS 10-3-2010 2.7 MB
9139499 MERGE REQUEST ON TOP OF 10.1.3.4.1 FOR BUGS 8599681 8921914 9073754 7-3-2010 13.4 MB
9305376 CATALOG - CREATE SHORTCUT WITH DIFFERENT NAME APPEARING TWICE ON THE DASHBOARD 5-3-2010 2.7 MB
9017835 OBIEE SERVER CRASHES WHEN RUNNING HR APPLICATION REPORTS 25-feb-10 28.1 MB
9147807 INCORRECT SYNTAX NEAR 'SESSION' WHEN QUERYING FRAGMENTED LOGICAL FACT TABLE 24-feb-10 187 KB
9356692 MERGE REQUEST ON TOP OF 10.1.3.4.1 FOR 8763296 7260120 8680924 8674235 8674235 8 10-feb-10 41 MB
8744580 OTBI : RSUM NOT DISPLAYING THE SUM AS EXPECTED 6-feb-10 148.7 KB

As always:

Yes you need a metalink/support account to download them. No, I will not download them for you and redistribute them. Ask your local Oracle representative for support.

Till next time

Monday, March 22, 2010

OBIEE rtfm.ini config file

http://forums.oracle.com/forums/thread.jspa?threadID=1047009&tstart=0

;-)

Till Next Time

Tuesday, March 16, 2010

OBIEE Start reading on graphs!

OBIEE 11g is coming!

We don’t no when, but we do know that the increase in graphical possibility's will be HUGE!.

In that lays a huge danger, developers have a natural tendency to try out all options, and even worse give all the options to their clients often resulting in very “colourful” dashboards.

image

If you are coming from OBIEE 10G and want to prep for 11g you might want to catch up on some reading on how to make good graphs, instead of only colourful graphs!

For several years the books of Stephen Few: (http://www.perceptualedge.com/blog/) where considered as the one and only standard. Certainly he was one of the first to write things down: (Information Dashboard Design: The Effective Visual Communication of Data ) This is still a must read for every Dashboard developer.

Recently a new book has arrived “The wall street journal guide to information graphics” by Dona M. Wong. Personally I find this easier to read then the Stephen Few book. I like the setup where on the left page there is a “bad” example and on the right side there is a “good” example. Another good feature of the book is the statistical “brush-up” chapter.

Till Next Time

Thursday, March 11, 2010

OBIEE Report XML Structure Part 3

In part 2 I showed you the Columns structure, in this article I want to show you the filter structure

The {saw:filter} structure

image

To create filters OBIEE uses sawx epression engine. First it define the type:

image

Then the right side:

image

and left side:

image

For filters based on an other report it pretty much works the same:

image

Till Next Time

Monday, March 8, 2010

OBIEE Report XML Structure Part 2

In part I showed you the base structure. In this part I want to show you the Columns Structure:

image

The {saw:columns} Structure

image

The first inner tag is {saw:column} . The base tag contains the column formula, columnId and aggregation rule

This tag is divided into {saw:tableHeading}, {saw:columnHeading}, {saw:displayFormat}

image

The {saw:tableHeading} Structure

image

This allows you to set an alternative caption as table heading.

The {saw:columnHeading} structure

image

This allows you to set an alternative caption as column heading. Also the interaction on a column level (Ai when you click on the column heading) is set here.

the {saw:displayFormat} structure

This control the display format of the data cel:

image

This also control the dataformat:

image

Till Next Time

Sunday, March 7, 2010

OBIEE conditional format using arrows

On the OTN forums (http://forums.oracle.com/forums/thread.jspa?threadID=1039411&tstart=0) an example for this:

image

was sought.

Let’s start with the basic report:

image

Calculate the delta:

image

Add two conditional formats:

image

Add the correct images:

image

Set it to image only:

image

There you go:

image 

Till Next Time

Friday, March 5, 2010

OBIEE Report XML Structure Part 1

Some time ago we did a project where we scripted the reports. The big problem is that the XML structure of the OBIEE reports isn’t very well documented. (At least we couldn’t find it, but if you have a good link please let me know!)

Base structure:

The most outer structure is are the {saw:reports} tags, together with the base structure you get something like:
image

The {saw:criteria} tag

The {saw:criteria} starts with the subjectArea subtag
The first inner tags are:
image
{saw:columns} Holding the columns information
{saw:filter} Holding the filter for the subject area
Next Time I will show the detailed columns and filter tags
Till Next Time

Tuesday, March 2, 2010

OBIEE Quirky Report Name

Have you ever noticed when a report name starts with  “CON”, the file system name will be converted to “co%6E”.

image

Let start an insider joke: “It’s the usenet handle of the original programmer ;-)”

Anyhow it’s one of those things you will have to keep in  mind when scripting reports.

Till Next Time