List of Tables

Chapter 2. Mondrian: a first look

Table 2.1. Some products that use Mondrian

Table 2.2. Pentaho convenience commands

Chapter 3. Creating the data mart

Table 3.1. Inconsistent and inaccurate results are bad

Chapter 4. Multidimensional modeling: making analytics data accessible

Table 4.1. XML elements and attributes that map dimensional attributes onto columns

Table 4.2. Example attributes

Table 4.3. Aggregators

Table 4.4. Month and Week attribute values

Table 4.5. MDX time operators

Table 4.6. Time domains recognized by <AutoGeneratedDateTable>

Table 4.7. Contents of time_by_day_generated table

Chapter 5. How schemas grow

Table 5.1. Dimensionality of the Sales and Inventory measure groups

Table 5.2. Dimensionality of the Forecast measure group

Table 5.3. [Product] dimension stored in the product table

Table 5.4. Upper levels of [Product] dimension stored in product_class table

Table 5.5. Lower levels of [Product] dimension stored in product table

Table 5.6. Members of the [Geography] ragged hierarchy

Table 5.7. Values for a level’s hideMemberIf attribute

Chapter 6. Securing data

Table 6.1. Data access by role

Table 6.2. Session attribute to role list conversion process

Table 6.3. Comparing member grant combinations

Table 6.4. Sales data by state

Table 6.5. Results of rollup policies with member restricted to WA

Chapter 7. Maximizing Mondrian performance

Table 7.1. Cache-flushing scenarios

Chapter 9. Working with Mondrian and Pentaho

Table 9.1. Geo annotations

Appendix B. Online resources