Database Reference
In-Depth Information
10
advanCed smart vIew
Robb Salzman
Contents
10.1 Introduction
352
10.1.1 overview
352
10.2 A Word or two about the Classic Add-In
353
10.3 tune your reports, Create Efficient Smart view Spreadsheets
353
10.3.1 hardware: It's your Laptop
353
10.3.2 how Smart view Is Architected; What Are All Those urLs?
354
10.3.3 Spreadsheet Efficiency meets Essbase
354
10.3.4 how many Cells?
354
10.3.5 Dimension Arrangement for Efficient Spreadsheets
354
10.3.6 Attributes, DtS, and Dynamically Calculated members
355
10.3.7 use “navigate Without Data” to Improve Performance during
Development 355
10.3.8 Compression 355
10.4 Excel Automation 356
10.4.1 vBA: traditional Automation 356
10.4.2 Smart view vBA Functions refresher and newer Features 356
10.4.3 Setting and managing options 357
10.4.4 Connecting, Logging In, and refreshing Forms 358
10.4.5 Cascading reports 362
10.4.6 Linking Smart view Functionality to Common Form Elements 362
10.4.7 managing Combo Edits 363
10.4.8 Creating a Combo Edits Lookup table for valid Sparse Combinations 363
10.4.9 Adding the Combo Boxes
366
10.4.10 Adding the Initialization Code
367
10.4.11 Adding Events to Drive the Combo Boxes
367
10.4.12 next Steps
369
10.4.13 Error handling
370
10.5 Aterthoughts
371
351
