2010/02/01

OBIEE Answers - Pivot Table / Chart Horizontal Layout - Multiline

At the current client site, we had a requirement to show PIE charts one for each section. As we all know, by default OBIEE presents the sections vertically. If the number of sections is 3 or less this layout would look nice, but what if there are more sections, scrolling down vertically would not appeal to the end users to get a comparative view.

Joe Bertram had posted Javascript to present the sections horizontally and I thought we could use this script to rotate the PIE charts horizontally. We have duely lifted his script and use in ours and the result looked like below.

Which is not appealing as the users have to scroll across, so I thought there must be a way to present this on multiple rows with limited columns per rows. Am no expert on Java scripting, so another cry for help!!

This time another OTN Member John Minkjan replied with a variant of original script by Joe and the final desired output which looked like below.

.
Thanks to Joe & John for their effort.

6 comments:

  1. Hi Chris,

    Never tried. I will give it a go and see. Surprised to know that with all the 11g offerrings the basic stuff is't fixed.

    Regards

    ReplyDelete
    Replies
    1. Hi to all,

      The code does not work in 11g. I also need it.

      Delete
  2. Hi, I have a same requirement, can you please provide any script available to work in obiee11g /12c. Appreciate your support !

    ReplyDelete

File Handling with Python

This little utility is for copying files from source to target directories.  On the way it checks whether a directory exists in the target, ...