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.
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
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
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