Static Lists of Values

A list of values based on a business layer on a query object is the most frequently used type of list of values. However, in some cases, you may want to provide users with a list based on a static data set. This can be useful if querying your dimension tables is particularly slow or if your universe accesses a transaction system and normalized database. The static list can be loaded from a flat file (text, CSV, or PRN), or you can manually enter values.

Static Lists of Values from Imported Data

In the following example, you will create a list of values based on a static list for Article ID. The list includes the Article ID, Article Description, and Category. First, create this static list by creating a query and saving ...

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.