OBIEE Tables Stacked Columns

Question

Hello,

I am wondering if this is possible on OBIEE 11g. I have a requirement for a table with let's say 20 columns. Rather then have such a wide report, requirement is to have columns stacked, so there are 10 columns only, but 5 values per column.

an abstract is

COL1

COL2

COL3

COL4

COL5

COL6

COL7

COL8

COL9

COL10

COL11

COL12

COL13

COL14

COL15

COL16

COL17

COL18

COL19

COL20

VAL1

VAL2

VAL3

VAL4

ETCETCETCETCETCETCETCETCETC

I am accomplishing this right now via HTML and line breaks, HR tags, but I am hating my life right now doing this like this, and was hoping for a more elegant scalable approach.

Any suggestions?

ElieAintabi · Answer

Highly regrettable, however I entirely see your point. Thanks,

Gianni Ceresa · Answer

Hi,

More "elegant" ?

Well ... as what you look for isn't anything standard, common or logic (because stacking columns would make >90% of the reports unreadable) you don't get anything out of box looking like that.

The only option is manual HTML with a narrative view to make the job.

They only way to get it "dynamic" (aka scalable) would be to use javascript to do the job with some parameters (like for example how many columns you want) and a javascript code would do the job. You can store the JS code in a file you load where needed and using a narrative view you pass values to JS.