Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Tables Stacked Columns
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 | ETC | ETC | ETC | ETC |
| ETC | ETC | ETC | ETC | ETC |
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?
Answers
-
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.
0 -
Highly regrettable, however I entirely see your point. Thanks,
0
