List of Listings

Chapter 1. Beyond reporting: business analytics

Listing 1.1. Query for orders by city

Listing 1.2. Query for orders by customer

Chapter 2. Mondrian: a first look

Listing 2.1. Comparing quarters across years

Chapter 4. Multidimensional modeling: making analytics data accessible

Listing 4.1. Sales schema

Listing 4.2. Physical schema

Listing 4.3. Physical schema with columns

Listing 4.4. Calculated column with expressions for multiple SQL dialects

Listing 4.5. Table alias examples

Listing 4.6. Multiple uses of the same table

Listing 4.7. Customers hierarchy

Listing 4.8. Labeling a time dimension and its attributes

Chapter 5. How schemas grow

Listing 5.1. Schema containing Sales and Warehouse cubes

Listing 5.2. Sales and Warehouse cubes using shared dimensions

Listing 5.3. Sales cube with multiple measure groups

Listing 5.4. The Forecast measure group

Listing 5.5. MDX query on parent-child hierarchy

Listing 5.6. Calculated member defined in a cube

Listing 5.7. Calculated member defined in a cube using compact notation

Listing 5.8. Calculated member defined in an MDX query

Chapter 6. Securing data

Listing 6.1. Declaring roles

Listing 6.2. One-to-one role mapper configuration

Listing 6.3. Lookup-map role mapper configuration

Listing 6.4. User-session role mapper configuration

Listing 6.5. User-state role mapper

Listing 6.6. User-state role mapper configuration

Listing 6.7. Granting access to the entire schema

Listing 6.8. Granting access to none of the schema