Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI 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
