Business Intelligence – Oracle

Archive for January 18th, 2008

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.

Posted in All Posts, OBI EE Plus | 2 Comments »