01/12/2010 by Simon Tomey.

Here’s the address to download the slides for today’s session. It’s in an hour’s time and the pressure is on, as last night I was awarded “UKOUG Inspiring Presentation 2010″ for last year’s presentation (”A BI Reporting Roadmap”).

Our session at this year’s UKOUG conference demonstrates some of the powerful functionality in BIP in the context of converting Discoverer and FSG (Financial Statement Generator) reports to BIP.

• The session takes you through and end to end conversion of a FSG to a BIP report, concentrating on data templates.
• I concentrate on Data templates as I’ve done loads of presentations on Presentation templates before (and some knowledge of them is assumed in this presentation).
• The presentation culminates with bursting an FSG equivalent report (actual, budget, variance by cost centre and nominal, period and YTD (year to date)).
• The report emulates drill down and is truly awe inspiring.

Check out the presentation here and get in touch with any questions or observations.

http://oracle.belife.co.uk/BeLife%20-%20Transforming%20Discoverer%20and%20FSG%20Reports%20(UKOUG%20Dec2010)%20v1.0.zip

Posted in BI Publisher, Reporting | Print | No Comments »

25/11/2010 by Simon Tomey.

If you just want your FSG’s in BIP (with limited functionality) then the session we did at UKOUG last year will be helpful.

I’m preparing for my session at the UKOUG conference next week and wanted to refer to some slides I’d run last year. They weren’t on our blog, so I’m sorting that now. Here’s the link to download the slides http://oracle.belife.co.uk/TRANSFORMING%20your%20FSG%20REPORTS%20with%20XML%20PUBLISHER%20v7.2%20[PDF].zip

The presentation just goes through the templates available as standard in EBS for publishing your FSG’s via BIP, in Excel, PDF, HTML or RTF format. We add a few tips and tricks and describe what you can’t and can do. What you can do is a bit limited, hence my presentation next week where I will be showing folk how to do some truly awesome publishing using data templates and bursting. I’ll make a post on the presentation along with a link to download the slides.

Posted in BI Publisher | Print | No Comments »

22/09/2010 by Simon Tomey.

The heart’s desire of every accountant is to be able to see a report and then click on a section of this to get further detail. We’ve found a way of doing this using BI Publisher in EBS.

The classic situation (which is so well catered for by the likes of Discoverer and BI Answers) is the ability to drill down to further information when performing analysis. You get your top level summary report and you want more information for the areas that are of interest to you. For example imagine wanting the account analysis report information, but summarised by account code with the ability to drill down to the sub-ledger detail underneath. Well now you can.

We’ve managed to set this up using bursting in BI Publisher. By creating a series of templates which hold all the information required for all the various drill down permutations, we can enable users to start with a top level report and drill through various paths to open further detailed reports.

The great news is, that this uses the standard free, integrated Oracle BI Publisher bursting technology. It’s a little complex, but not so complex that we can’t show you how to build you own suites of reports. Just look out for all those accountants, with the desires of their hearts fulfilled…

See below for a mock up we’ve done of this. (yes I know the totals don’t quite add up, but you get the idea of how to do it, I hope).

We create a series of templates which allow the user to jump from one report to another, to follow a “drill path”, using automatically generated hyperlinks.

We run the bursting request to create all the output files, populate the hyperlinks and send them to the appropriate folders.

The user then opens the top level report (either from the directory, or just viewing the output).

The report then contains a series of automatically generated hyperlinks which will follow the “drill path” you have specified when you designed the report.

The hyperlinks enable the user to “drill down” to further levels of detail. (The hyperlink merely opens a new report relevant to the item selected).

The number of drill down levels are not limited (but you may wish to keep it to just a few).

You may wish to enable users to go directly to the full detail.

I’ll post an update when we have done more. Meanwhile you might need to get us in to train you so you can make your own journey of discovery in satisfying the heart’s desire of your accountants.

Posted in BI Publisher | Print | No Comments »