X

An Oracle blog about BI Publisher

Reporting on Local Data

A departure from the norm today ... you get to sit back and watch something rather than read my ramblings. Listening to me for 10 minutes might be even worse I guess.

One of the many new features in BIP 11g is the new data model builder ... if you dig around you'll notice that you can now report on an Excel file. Even better you can join your excel data to another SQL data source and report on your local data alongside the centralized data ...cool.

Rather than write about it, I recorded it. Having finally found a screen recorder that 1. works and 2 does not cost anything. Without further ado ...

Im hoping to get this up to the BIP YouTube page soon but for now, its hosted on ScreenToaster. The blog template is only 600 pixels wide so the quality is not great. If you want to get the full 3D surround sound experience, just click here or hit the full screen icon option in the movie above.

Having listened to myself, do I really sound like that? I realized I forgot to mention that the Excel must be of the xls binary format and not the new xlsx type.

I'm so glad I don't have a web cam set up on my laptop ... now that would be scary :0)

Update

==========

For YouTube lovers everywhere the video is now mounted on t'tube

Direct link here. You might want to up the quality to 720p ... the upload to Tube has lost some of the quality.

Join the discussion

Comments ( 3 )
  • Pieter Breugelmans Saturday, October 9, 2010
    In my personal opinion, yet another very powerful feature that slipped into our product and thanks to Tim for creating awareness about it. Once anyone got a chance to review the great recordings he posted above, don't forget to look up the details of the feature in our online Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher:
    Defining a Microsoft Excel File as a Data Set Type
    http://download.oracle.com/docs/cd/E14571_01/bi.1111/e13881/T527073T527080.htm#ms_excel_ds
  • Mark Rittman Tuesday, October 12, 2010
    Hi Tim,
    Yes, I agree it's a good feature. To complement your video, I thought it might be worth posting a link to my blog article from a few weeks ago that covered the feature as well (hope this is OK with you):
    http://www.rittmanmead.com/2010/09/13/creating-federated-data-models-using-bi-publisher-11gr1/
    regards
    Mark
  • Devendar Tuesday, October 12, 2010
    Hi,
    I am Dev Gandra, I have been following your blog from several days. I came across a requirement to design a org chart using BI publisher (EBS). You have mentioned long time back that you would post a blog with the details on how to design a dynamic org chart.
    If possible, please post it.
    Thanks
    Dev
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.