Business Intelligence – Oracle

Oracle BI EE – Achieving Financial Template Layouts using Pivot Tables – Part 2

Posted by Venkatakrishnan J on January 18, 2008

Well, this is an extension of what we saw earlier the other day here. I was told by one user that though they were able to mimic the report in terms of look and feel, there still was one part of the report that did not look the same when compared with the new features guide. For example, look at the screenshot below (Thanks Monika for providing this screenshot).


Basically, we have a repeating Total Fixed Assets and Total Investment which user did not want to have. So, lets go back to the report that we created and start modifying it from where we left off. One of the major problems with sub-totals is that there is no way we can filter them so that they appear only for certain rows. So, the first step is to go and remove the sub-total that we created in BALANCEGROUP3 column so that it removes the inner sub-group.


Once this is done, we need to create 2 sub-totals. One for Cash and one for Other Assets. So, go to ACCOUNTDESC and click on create new Calculated Item. In the Calculated Item sum all the values that are part of Cash metric. Then go to Format of this Calculated Item. Make it bold and give a left padding of 50.




This would create our Cash sub total. Similarly create the sub-total for Other Assets.



Now we have our final report with non-repeating sub-totals.


2 Responses to “Oracle BI EE – Achieving Financial Template Layouts using Pivot Tables – Part 2”

  1. Robert said

    Is it possible to use variables in the formulas?


  2. […] Oracle BI EE – Achieving Financial Template Layouts using Pivot Tables – Part 2 page_revision: 0, last_edited: 1241278491|%e %b %Y, %H:%M %Z (%O ago) edittags history files print site tools+ options edit sections append backlinks view source parent block rename delete help | terms of service | privacy | report a bug | flag as objectionable Hosted by — get your free wiki now! Unless stated otherwise Content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License Click here to edit contents of this page. Click here to toggle editing of individual sections of the page (if possible). Watch headings for an “edit” link when available. Append content without editing the whole page source. Check out how this page has evolved in the past. If you want to discuss contents of this page – this is the easiest way to do it. View and manage file attachments for this page. A few useful tools to manage this Site. See pages that link to and include this page. Change the name (also URL address, possibly the category) of the page. View wiki source for this page without editing. View/set parent page (used for creating breadcrumbs and structured layout). Notify administrators if there is objectionable content in this page. Something does not work as expected? Find out what you can do. General documentation and help section. Terms of Service – what you can, what you should not etc. Privacy Policy. _uff = false; _uacct = “UA-68540-5″; _udn=””; urchinTracker(); _qoptions={ qacct:”p-edL3gsnUjJzw-” }; […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: