SAP BusinessObjects Dashboards 4 Cookbook
Categories
- Business Objects (14)
- Best Practices (5)
- Fusion Charts (5)
- Main (11)
- SQL Server (1)
- SSIS (1)
- Uncategorized (2)
- Universe Design (3)
- Web Intelligence (6)
- Xcelsius (29)
- Design Practices (5)
- Excel (4)
- Tips and Tricks (11)
- Workarounds (6)
Archives
- January 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- April 2011
- March 2011
- February 2011
- December 2010
- November 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- October 2009
- August 2009
- April 2009
- March 2009
- January 2009
- December 2008
- November 2008
- October 2008
Tag Cloud
best practices
bonavista
bulletgraph
Business Objects
Business Objects Dashboards
charting package
conditional formatting
content management
Cookbook
datatable
dianne sawyer
dom
Dynamic Color Binding
Excel
expand
fannie mae
fix
fred carter
frederick carter
Fusion Charts
grid component
imt slider
inovista
java
Java Wrapper
microcharts
opendoc
pathway technologies
Publication
ripoff
SAP BusinessObjects Dashboards
scam
scorecard
sorting
sparkline
spreadsheet table
table
tree grid
universe
User Access
User Management
Web Intelligence
wrapper
Xcelsius
Xcelsius 2008



Cascading List of Values
List of Values is a powerful feature that allows users to select from a pick list when setting conditions in a query. This is especially important if you want to query on codes linked to a set of products. Using the List of Values feature, you will not need to memorize which codes go to which products.
The part that I would like to focus on is Cascading List of Values. In a real world Data warehouse for example, we may have thousands of customer codes. As a business user, in order to get to the customer codes I desire, I would probably want to select my customers from a certain region. Using Cascading List of Values, I can first select which regions I want to view and then select my customers from there.
Please note that it is important to think of the most efficient path a business user can take to get to their answer. One blunder that happens with many developers is the lack of planning when creating a Cascading List of Values. Some may include too many levels which in the long run increases the response time of user selection or too few levels which would cause users to spend too much time looking for certain values.