Introduction

Many a times there is a need to re-organize data retrieved by an OTBI Analysis. Sections and Table Prompts helps us to do the same.

We would try to build a very simple analysis by making use of Sections and Table prompts but prior to that it makes sense to understand what Table prompts and Sections are and how they can be used.

Sections

The sections function is used to make the columns that comprise the data sets of analyses appear more meaningful by segregating them into tables of related information. Sections are built after the analysis has been run and can be based on virtually any column. Sections by design can be introduced to or eliminated from analyses almost instantly. This is helpful when different columns need to be grouped, ungrouped or regrouped quickly for emphasis within analyses.

We can find the Sections area when we edit the “Table” view available under Results tab

Table Prompts

Table prompts set up in analyses help to display the one desired member of a column at a time and allow for dynamic filtering by consumers. Table prompts, just like sections are built after the analysis has been run and can be run virtually on any column. Table prompts too like sections may be defined in or removed from analyses almost instantly. This is useful when different columns need to be grouped, ungrouped or regrouped quickly for emphasis within analyses.

We can find the Sections area when we edit the “Table” view available under Results tab

Worked-Out Example

As we have now got some idea about sections and table prompts , let’s try to create a simple analysis. We will build the analysis on “Workforce Management – Person Real Time” subject area and will have the following columns

The Criteria tab would look like:

Now we want to ensure that we should have a prompt for Country field and for those countries details should be displayed for individual cities section wise For this we would need to define “Country” as a Table prompt and include “City” in Section region as shown below:

And once done we could see the following results:

Ashish Harbhajanka

Add comment