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

OBIEE rtfm.ini config file

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

;-)

Till Next Time

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.

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

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

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

Then the right side:

and left side:

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

Till Next Time

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:

The {saw:columns} Structure

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}

The {saw:tableHeading} Structure

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

The {saw:columnHeading} structure

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:

This also control the dataformat:

Till Next Time

OBIEE conditional format using arrows

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

was sought.

Let’s start with the basic report:

Calculate the delta:

Add two conditional formats:

Add the correct images:

Set it to image only:

There you go:

 

Till Next Time

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:

The {saw:criteria} tag

The {saw:criteria} starts with the subjectArea subtag
The first inner tags are:

{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

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”.

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