FSG Excel Templates Today!

I exchanged several mails with Scott from General Dynamics regarding FSG outputs with BI Publisher. He was looking at using the Financial Report Template Editor (in Excel)solution from the Report Manager team for FSG reports and had some questions. He had an issue with loading an updated Excel template into the template manager via their UI - theres a bug open for this that he is now hopefully attached to. The discussion opened up a little into the capabilities within the Excel template solution - I provided some insight which I think is worth sharing with a wider audience.


As some of you know there is a true Excel template solution in the works - its not quite generally available - we are working through some kinks and requirements with a customer at the moment and once they are sorted it will hit metalink without a password requirement. More on those tomorrow. To clear things up on the Report Manager Excel template solution - this is not a binary Excel solution.

You use an Excel interface to build the layout for the FSG data - under the covers an XSLFO template rather than an Excel file is created to format that output. At runtime the XSLFO is applied to the FSG data and the user can pick the output format they want e.g. Excel, PDF, etc. The fact to know here, is that the Excel we generate is not actually Excel - its HTML or more properly XHTML. We then set the mime type such that Excel is used to open the file. There are obvious limitations - no native Excel functions are going to work so you can use a formula function on your data or embed a macro in the template - we do not interpret VBA macro language into XSL code ... sorry. The advantage, is that you get a familiar Excel interface to build the templates in and you get multiple output choices from the template as well as the Excel output. Under the Report Manager module you also get drilldown on those FSG numbers into the GL balance inquiry pages.

So why not just use an RTF template? Why not indeed - you can build everything you can in the Excel interface the only missing piece right now would be the drill links but they are coming soon. Scott did ask about the page width limitations? Those of you that know FSGs will know that the FSG engine can generate reports with almost as many columns as you wish. How do you print that out without getting data truncated on the right hand edge of the paper? The FSG team ship you a template out of the box that wraps the data to a new page when it hits the edge of the 'paper' no matter how many columns of data you have. This was designed with the idea in mind that you wanted to print out the FSG where the page size is determined by the paper you feed into the printer. But, if you just want to get the content out to Excel then that paper size can be adjusted.

Think about it, when you first open a new Word doc it makes an assumption that you want 'Letter' or 'A4' sized paper depending on where you are in the world. There is nothing to stop you going in and setting the page width and height to their maximum 22" x 22" - now as long as your output is destinined for Excel or HTML where there is no concept of page size (until you want to print) then you can use this custom width and height and avoid the wrapping that we do for you. With the generic FSG template just extend the table width to the width of the page and you're done.

Your users who want to work in Excel will be happier - they will have a 30 column report laid out in Excel (without wrapping) and they can beaver away using familiar native Excel features to dot the i's and cross the t's. If they want to print their modified report - Excel will handle it with its 'Z' or 'N' print format. Once they are happy with the numbers in the original report they can just apply a new template that expects to be printed ie its Letter or A4 sized and you get all the high fidelity reporting and wrapping from a regular sized RTF template.

Tomorrow, I'll tempt you with some features that are coming with the new binary Excel templates ...


Tim, will we be able to have multiple sheets excel templates? Also, this is not just for FSG right? Thanks, Ike Wiggins

Posted by Ike Wiggins on February 06, 2008 at 02:40 AM MST #

Tim - Thanks for the posts on this and your email help as well. Hopefully it will help someone else figure out what is really going on under the covers. -Scott-

Posted by Scott on February 11, 2008 at 12:47 AM MST #

Hey Scott

You can use RTF templates via the conc manager - now I know you are losing the RM functionality of storage and security but it may be an alternative.
Not sure what version you are running but there is an Excel template editor in RM that should be generating Excel and PDF outputs - if its not there or not working then you either are not patched up or its a bug - log an SR for some help.

Posted by Tim Dexter on February 29, 2008 at 05:04 AM MST #

You know I actually picked this back up, and it appears that E-Business Suite (Oracle Report Manager to be more specific) does not actually support using an RTF for FSG reports. The only output you can generate seems to be PDF - The HTML and Excel are either blank or maligned. Check out Metalink note 418448.1 - It says the FSG Basic Template (rtf layout) is not intended to be used for Report Manager publishing. So at this point I am not a happy camper.

Posted by Scott on February 29, 2008 at 05:44 AM MST #

Tim, Like Scott I'm also having problems trying to publish an FSG to excel from the concurrent manager, it's erroring out. I opened an SR and they said you can't publish to excel from the concurrent manager using the XML publisher templates. Only works from report manager. We're on 11i, any chance this will be available soon? We would actually prefer not to use report manager for performance and usability reasons, but it seems we're stuck if we can't get concurrent manager publishing to excel working. Thanks, Jay

Posted by Jay Johnson on September 08, 2008 at 08:05 AM MDT #

Jay Please log an SR against the General Ledger product requesting the Excel templates for FSG functionality Tim

Posted by Tim on September 08, 2008 at 08:56 AM MDT #

Do you believe music is heading towards a time where tracks are released for free and musicians make their moolah through concerts and sponserships?

Posted by Michel Menietto on February 28, 2010 at 02:19 PM MST #

Many printing techniques are used to produce posters. While most posters are mass-produced, posters may also be printed by hand or in limited editions. Most posters are printed on one side and left blank on the back, the better for affixing to a wall or other surface. Pin-up sized posters are usually printed on A3 Standard Silk paper in full colour. Upon purchase, posters are often rolled up into a cylindrical tube to allow for damage-free transportation. Rolled-up posters can then be flattened under pressure for several hours to regain their original form.

Posted by Zana Andelman on March 09, 2010 at 05:54 PM MST #

I'm wondering what CMS your blog uses? It seems fabulous and I like every one of the guest functions which are available. I'm sorry if this is the incorrect place to ask this however I wasn't sure the right way to make contact with you - thanks.

Posted by Oscar Morgan on March 15, 2010 at 04:12 AM MDT #

There is really no doubt that Jay is close to being the best rapper of all time.

Posted by Products Review on April 08, 2010 at 05:30 PM MDT #

tremendous! Jay Z is a an awe-inspiring guy.A genuine modern day role model. I took my family to see him last year in concert and had a fabulous time.

Posted by Wedding blog on May 06, 2010 at 09:08 PM MDT #

It's another well crafted story. I own simply in recent years noticed FSG Excel Templates Today! (Oracle BI Publisher Blog) coupled with am still digesting this fantastic Diy article content that you've got listed here.

Posted by Erin Hensel on June 02, 2010 at 07:38 AM MDT #

Maintain up the excellent function mate. This website publish indicates how nicely you recognize and know this subject.

Posted by never fail list building system review on August 22, 2010 at 05:33 AM MDT #

Hey Tim, Is there any way i get a chance to know how to build a Excel template and use it a source for layout instead of RTF for concurrent program submission. Please advise me ,. Thanks and regards, Sunil Dutt.S

Posted by Sunil Dutt on November 01, 2010 at 01:07 AM MDT #

Does anyone know if the excel template issues have been resolved. We just upgraded to R12 and my template from Report manager looks like excel but has HTML file extension. In addition, the output disregards the defined number formatting from the template. Example; it keeps showing "0" instead of the predefined "-" and it generated regular underlining instead of accounting underlining.

Posted by guest on August 14, 2014 at 11:58 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« July 2016