113
4
Bso wIll never dIe and here Is why
Dave Farnsworth
4.1 WHO SHOULD READ THIS CHAPTER?
Writing a chapter about the block storage option (BSO) within Essbase comes with
asubstantial amount of risk. No matter how carefully the topic is researched, there will
CONTENTS
4.1 Who Should Read is Chapter? 113
4.2 Prerequisites 114
4.3 Why BSO, Indeed 114
4.3.1
Need for Speed 115
4.4 What Is “Good” Performance? 115
4.4.1
Know the Basics for Good Performance 115
4.4.2
Dimensionality 115
4.4.3
Block Size Mysteries 117
4.4.4 Dimension Order 118
4.5 Getting the Most from Multiple Processors 121
4.6 Cache Is King; Know the Basics 121
4.6.1
Index Cache 122
4.6.2
Data Cache 123
4.6.3
Data File Cache 124
4.6.4
Calculator Cache 125
4.6.5
Dyna ...