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