FSG Excel Templates Tomorrow

Yesterday, I wrote about the possibilities and limitations of using BIP templates with the FSG engine from GL to get Excel formats out. That was what was possible 'today', today's post is about what is going possible 'tomorrow.' Now, dont get excited, thats not a literal 'tomorrow' ... we have been working with a customer on the templates. We are a little ways away from prime time - Im happy that they are ready for non-FSG applications but the existing FSG Excel solution ie ADI (not the web version) has a raft of cool features that we need to replicate - I'll get into those.

The basic functionality lets you map cells and groups of cells to your incoming XML data source and then add almost any native Excel functionality to the template. The report can then be executed via the concurrent manager and then, via the OPP the Excel template applied to the data and the final Excel file generated. Users can then access the output just as they would any other report in the system via the SRS forms/pages.

Those of you that know the FSG engine will know that you can run a 'content set' on top of a given FSG report. For the uninitiated this is the ability to run the report for a given set of say companies or cost centers within EBS - generating a single data set for how wver many members there are in the content set. The neat FSG feature here is that we 'burst' the result for each member of the content set onto its own sheet in the workbook and allow you to control the name of the sheet tab.

On the FSG product side they have implemented some very neat drill down features. Those of you using the ADI or WebADI products will know that your outputs can have links on every number in the Excel output that when clicked drill you into the GL inquiry pages. This will be available in the Excel and RTF templates when generally released. Enabling users to drill back into the application to discover where that huge and erroneous looking number in the report came from.


We are working on other enhancements to the FSG solution namely the ability to run an FSG Report Set and have each report and its content set members (if applied) burst on to their own sheets in the Excel output - this is a tough one to implement so no promises at this point.

Sorry, I can not commit to a GA date right now. We are working on R12 and there are plans to back port to 11i10 when its all wrapped up - but its coming and it aint far off.



Any update on this issue?

Posted by Yugi on July 31, 2008 at 01:19 AM MDT #

Hi Its still under controlled release for R12. I would recommend logging an SR with support against us (1479) so you have something to track during its release. Tim

Posted by Tim on August 04, 2008 at 02:12 AM MDT #

On a different note, does anybody know anyone who would have FSG report writing experience and looking for a job in Cork, Ireland?

Posted by Caroline on June 18, 2009 at 02:55 AM MDT #

Is the bursting functionality for content sets into different tabs in an excel workbook available yet?

Posted by Sean on July 21, 2009 at 11:43 AM MDT #

are excel templates available for FSGs in R12 now?

Posted by 47.wing@gmail.com on July 22, 2009 at 01:58 AM MDT #

Yes, the excel templates are available through the Report Manager responsibility. You may need to add the respective menu options since the responsibility does not always include them with the standard definition. You need to define an excel template and upload it to Oracle.

Posted by Sean on July 28, 2009 at 01:46 PM MDT #

Tim, Any further news on these excel templates? Have they released for wider use in R12? Or are they still in controlled release? Thanks Thuy

Posted by Thuy on September 07, 2009 at 10:56 AM MDT #

Hi Tim, Background : My output format is excel 2) I use RTF to design the templates 3) I am including header and footer in the RTF depending on the conditions 4) I am using pagebreaks after each section. Question : 1)When I print my excel output, I want to see the header and footer on each sheet I print. How? 2)How to setup pagebreaks for excel after each section 3) how to setup vertical pagebreaks for excel in my templates. Thanks in advance for your time and advice. Regards TS

Posted by TS on October 26, 2009 at 06:15 PM MDT #

Hi Tim, How to fix the column width in the template for the excel output? Thanks & Regards TS

Posted by TS on October 27, 2009 at 04:45 AM MDT #

Hi Tim, Any Idea how to make the text wrap in excel output generated from BI RTF template? Thanks & Regards TS

Posted by TS on October 27, 2009 at 04:46 AM MDT #

Hi Tim, Burst the result for each member of the content set onto its own sheet in the workbook and allow you to control the name of the sheet tab. Is this functionality available yet, if yes is there any thread which could help me in understanding in how to achieve this? Regards, Hash

Posted by Hahs on November 15, 2009 at 07:26 PM MST #

Why don't you try using GL Wand from Excel4apps? It is a much cleaner, easier to use solution.

Posted by Richard Savill on March 07, 2010 at 08:16 PM MST #

The article is very helpful! Thank you for the template help. Personally, I had some problems converting excel files over to PDF and making it look nice. Then I found this program at my work that quickly and painlessly converts my excel documents into pdf so I didn't have to do it manually (which would end up taking aggravating hours upon hours). It provides my business a simple way to make individualized statements for our business associates, taking our invoices and seamlessly placing the information in awesome templates. Check it out http://www.nirvaha.com/free-spreadsheet-templates.html

Posted by Joseph Becket on July 28, 2011 at 07:23 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 2014