OBIEE Report XML Structure Part 3

John Minkjan | Mar 11, 2010 13:48 +0000

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

OBIEE Report XML Structure Part 2

John Minkjan | Mar 8, 2010 13:27 +0000

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

OBIEE conditional format using arrows

John Minkjan | Mar 7, 2010 14:03 +0000

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

OBIEE Report XML Structure Part 1

John Minkjan | Mar 5, 2010 14:05 +0000
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

OBIEE Quirky Report Name

John Minkjan | Mar 2, 2010 12:47 +0000

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

OBIEE Presentation Server Always Refresh

John Minkjan | Feb 27, 2010 13:42 +0000

If you have a separate development presentation server, you can use the developersprompt: (http://obiee101.blogspot.com/2008/10/obiee-developersprompt.html) for bypassing the BI servercache. If you always want to bypass the Presentation server cache add this to the instanceconfig file of the development presentation server:

<WebConfig>
<ServerInstance>
<ForceRefresh>TRUE</ForceRefresh>
</ServerInstance>
</WebConfig>

Till Next Time