Sample Outdoors Company models, Powercubes, and packages
The sample Outdoors Company Framework Manager models that are included with the extended samples illustrate modeling techniques and support the samples. The models are based on the GO data warehouse and the GO sales transactional databases and are the basis for the sample reports and queries. Each model contains two packages for publishing analysis (dimensional) and query views of the data.
To look at the sample models, you must have access to Framework Manager, the modeling tool in IBM® Cognos® Business Intelligence. You also need to set up the sample databases and connections. See Downloading and configuring the extended samples.
GO Data Warehouse
The GO Data Warehouse model, great_outdoors_data_warehouse.cpf, is based on the database GOSALESDW. It contains data about human resources, sales and marketing, and finance, which is grouped into business areas. In the Database view, the three business areas are grouped into separate namespaces. The Database view contains a fourth namespace (GO Data) for the common information.
The Database view is similar to the structure of the underlying database. All tables (database query subjects) are unchanged. This enables IBM Cognos Analytics to retrieve metadata directly from the package in most cases, instead of using a metadata call to the database. The following changes and additions were made in the Database view:
- Joins were added as necessary.
- To allow for aggregation at different levels of granularity, some model query subjects were created. For example, see the relationships between Time and Sales or Sales fact.
- To allow single joins to be made between the lookup tables and each level in a dimension, lookup tables were copied. For example, see the Products look up tables.
The Business view contains only model query subjects, with no joins. The following changes and additions were made in the Business view:
- Calculations were added to the model query subjects. For example, the time dimension contains language calculations.
- Where the database has multiple hierarchies, new dimensions were created to organize each hierarchy. For example, the employee hierarchies are organized into several categories, such as manager and region.
The GO Sales transactional database
The GO Sales model, great_outdoors_sales.cpf, is based on the GOSALES database, which is structured as a transactional database. It contains principally sales data.
The Database view is similar to the underlying database structure. The following changes and additions were made in the Database view:
- To make it possible to join the fact tables to the time dimension, model query subjects and multipart joins are used.
- Other joins were added as necessary.
The Business view contains only model query subjects, with no joins. The following changes and additions were made in the Business view:
- Calculations were added to the model query subjects.
- Model query subjects that were created in the Database view to enable joins on the time dimension were linked as reference shortcuts.
- Where the database has multiple hierarchies, new dimensions were created to organize each hierarchy.
- Sales Staff is a subset of the slowly changing Employee dimension. There is no unique Employee key in GO Sales, so a filter retrieves the current record only. This model does not use historical data.
The samples PowerCubes
The following cubes are delivered with the Sample Outdoors samples in English, French, German, Japanese, and Chinese:
- sales_and_marketing.mdc
- employee_expenses.mdc
- go_accessories.mdc
- go_americas.mdc
- go_asia_pacific.mdc
- great_outdoors_sales_en.mdc
- great_outdoors_7.mdc
The samples packages
The Sample Outdoors samples include six packages. A brief description of each available package is provided.
Go Data Warehouse (analysis) is a dimensionally modeled view of the GOSALESDW database. This package can be used in all studios, including IBM Cognos Analysis Studio. Using this package, you can drill up and down.
Go Sales (analysis) is a dimensionally modeled view of the GOSALES database. This package can be used in all studios, including Analysis Studio. Using this package, you can drill up and down.
Go Data Warehouse (query) is a non-dimensional view of the GOSALESDW database. This package can be used in all studios except Analysis Studio, and is useful for reporting when there is no need for drilling up and down.
Go Sales (query) is a non-dimension view of the GOSALES database. This package can be used in all studios except Analysis Studio, and is useful for reporting when there is no need for drilling up and down.
Sales and Marketing (cube) is an OLAP package, based on the sales_and_marketing.mdc cube.
Great Outdoor Sales (cube) is an OLAP package, based on the great_outdoors_sales_en.mdc cube.