351
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 Ecient Smart View Spreadsheets 353
10.3.1 Hardware: It’s Your Laptop 353
10.3.2 How Smart View Is Architected; What Are All ose URLs? 354
10.3.3 Spreadsheet Eciency Meets Essbase 354
10.3.4 How Many Cells? 354
10.3.5 Dimension Arrangement for Ecient 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 Setti