60 likes | 236 Views
Session #1116A Top Tricks from the Masters of Hyperion Intelligence. The Gang Position – Vertical (We hope). Mark Ostroff “Mr. Tips and Tricks” Author of the original Intelligence Tips and Tricks Cookbook. The 3 Faces of Eve. OOoooppss…. The 5 Faces of MS Office Integration.
E N D
Session #1116ATop Tricks from the Masters of Hyperion Intelligence The Gang Position – Vertical (We hope)
Mark Ostroff“Mr. Tips and Tricks”Author of the originalIntelligence Tips and Tricks Cookbook 1116A | Top Tricks from the Masters of Hyperion Intelligence
The 3 Faces of Eve OOoooppss…. 1116A | Top Tricks from the Masters of Hyperion Intelligence
The 5 Faces of MS Office Integration Various methods, with different features & levels of complexity: • Simple Export to Excel • Formatted Export to Excel • Create an MS Office Master document, then export a data file used by that Master. • Use OLE Automation from within BQY to control MS Office app • Use SmartView to embed updatable content into MS Office 1116A | Top Tricks from the Masters of Hyperion Intelligence
Comparison of Integration Methods Comparing the Pros and Cons Method Coding Effort Applicable Apps Min HI Version Functional Level Simple Export None Excel v5.0 Raw Data Formatted Export None Excel v8.5 or HS9 Format / Formulas Master Document None to Little Excel, Word, PPT v5.0 Link-based OLE Automation Extensive Any OLE App v6.0 Unlimited SmartView None to Little Excel, Word, PPT, Outlook HS9 Data Display & Refresh 1116A | Top Tricks from the Masters of Hyperion Intelligence
Please Complete Your Session Evaluation Session #1116ATop Tricks from the Masters of Hyperion Intelligence Adam, Wayne, Mark, Larry, Curly and Moe