When to Disable Lists of Values
By default, lists of values are enabled on all objects, including measures. This is slightly different behavior than with the Universe Design Tool and earlier versions. There are instances in which it is better to disable them by removing the check from the Associate List of Values check box.
Measures
As discussed in the previous chapter, all measure objects should have a SQL aggregate (SUM, COUNT, and so on) in the SELECT statement. Therefore, if you have a list of values on a measure object, the list of values will return only one row of data, since there are no dimensions in the GROUP BY clause in the SQL. If you create a new measure object, the Associate List of Values box is not enabled. However, if you convert ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
