OraNA :: Oracle News Aggregator

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

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

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

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

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

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