Sydney ODTUG

I recently presented at ODTUG Sydney.   

To access the presentations, please go to:  
http://www.odtugspconference.com/Presentations.html

For those interested, here are the demo videos for my BI Apps* Tips and Tricks presentation. 

Unless otherwise specifically stated, the material contained herein is proposed for information purposes only.  References to any specific commercial products, process, service by trade name, trademark, manufacturer, or otherwise , does not constitute or imply an obligation to deliver any material, code, or functionality, and should not influence any purchasing decisions.

Video 1: Creating Siebel Delete Triggers in the DAC

Video 2: BI Apps and EBS Delete mappings

Video 3: Enabling Slowly Changing Dimensions

Video 4: Configuring Project Cost Aggregates

Video 5: Adjusting the Task Hierarchy when there are Name duplicates

Video 6: Configuring the DAC for Bitmap Indexing on Partitioned Tables (Pt 1)

Video 7: Configuring the DAC for Bitmap Indexing on Partitioned Tables (Pt 2) 

Video 8: Enabling Star Transformation Hints in the RPD
Note: This is a potential option to deal with stubborn queries that won't use star transformations when you want it to.  The video shows how I disabled the 'WITH' clause in the Connection Pool.  This is only a workaround for an error when adding a Connection Script to enable Star Transformations but it does have some consequences that you will need to consider.

 

*BI Apps = Oracle Business Intelligence Applications