Columns to Sections

building reports webintelligence
1

Hi All!

In the database has a table with the structure:

table_name (device_name, Param1, Param2, Param3)

device_name is dimension
Param* is measure

I need display Param* in the form of sections in report WebI

Now I do it with “union all”

select device_name, Section1, Param1
union all
select device_name, Section2, Param2
union all
select device_name, Section3, Param3

device_name is dimension
Section* is dimension
Param* is measure

and, Section* is sections in report

How can this be done without “union all”?

Thanks!

obnin (BOB member since 2010-07-08)

2

Hi obnin,
How are you doing it with Section1,2 and 3,please explain.

swap_l (BOB member since 2009-04-09)

3

hi swap_l,

In Universe made three dimensions: Section1,2 and 3.
And fill it ‘Section1’, ‘Section2’, ‘Section3’.

Then I create a query for report in such a way as in my first post.

obnin (BOB member since 2010-07-08)