Display data in sections Dashboard or Analysis

3244578

Hi Team,

I have a requirement to create a report where i have to display data in sections

eg: say i have a prompt for Candidate name (choice list)

after i select candidate prompt

my report should display like

candiate name abc

fname lname age city

abc    asd     10   NYC

candidate name bcd

fname lname age city

bcd    gef     11   Florida

This was a an easy feature in BO and MSTR but since i am pretty new to OBIEEE so would be great if anybody can help

Andrew Fomin.

Do you want something like this?

3244578

yessss exactly this

Andrew Fomin.

Main steps are:

1. Create a pivot table.

2. Move "candiate name" field to sections.

3. All other fields ("fname", "lname", "age", and "city") to rows.

--

Some tweaks:

4. Make measure column hidden (this column is not necessary if your report base on a single dimension).

5. Change section properties to display labels.

As you are new to OBIEE take a look at this Creating Analyses and Dashboards. If you are in a hurry, read this section: "Working with Pivot Tables, and Master-Detail Linking"->"Formatting a Pivot Table and Adding Calculations".

3244578

Hi Andrew,

I was able to fulfill that need but now they have asked us to modify the need eg:

candiate name abc

fname lname age city

abc    asd     10   NYC

job  startdate   enddate

test   today        tomorrow

candidate name bcd

fname lname age city

job  startdate   enddate

test2   yesterday        tomorrow

Basically instead of displaying just one table we have to now display two tables for the same section

Is it possible

Andrew Fomin.

I don't like word "impossible", that's why I'd say that I don't know how to do that [in Analysis].

3244578

haha
is it possible in dashboard?

Andrew Fomin.

It is definitely possible in BI Publisher.

And I've forgotten about a Narrative view in Analysis. It allows you to directly code view using HTML.

3244578

Looks like there isn't any direct solution to it

Andrew Fomin.

Actually, quick and dirty narrative view took me about 15 minutes. I don't think it will take significantly more to make it good-looking. But yes, that is not the best report from a support point of view.

3244578

if possible can u share the code, i jsut want the basics
u can share the code in a simple way if you worry about data nd all
will be really helpful Andrew