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.

Comments:

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

Posted by Pieter Breugelmans on October 09, 2010 at 12:25 AM MDT #

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

Posted by Mark Rittman on October 11, 2010 at 06:05 PM MDT #

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

Posted by Devendar on October 12, 2010 at 08:29 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

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!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today