Pro Tip 6

Recently Oracle introduced new functionality to allow Drill-Through to the Data Management Landing Page from PBCS Data Forms and Smart View Ad-hoc to Excel.  Previously, the only option was to the web browser. The functionality is available via the Options Ribbon, Advanced tab. The setting is called “Drill-Through Launch” and you can either force it to Excel by selecting “In New Sheet” or have it prompt you by selecting “Prompt Me to Choose Target”. Personally, I like the second option because your not forced into one option. You can choose the “In Web Browser” if you want to check the drill to source or check mapping details or Excel if you want to do Excel analysis on the detail values.