
366 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
box choice drives what selections appear in the next dropdown. For instance, if the
user chooses “Audio Systems” from the Segment dropdown, the Channel dropdown
would be populated based on a lookup to the table where our valid sparse interdi-
mensional relationships are stored (Figure 10.6): “Distribution,” “Government,”
“Education.” If the user then selects “Government” from the Channel dropdown, the
Entities dropdown would be limited to “North America” and “Latin America” based
on the Segment -> Channel -> Entities interdimensional relationship establ ...