11. If there are no problems with your design, you can now create the cube and
confirm your results in your OLAP reporting component.
If there are problems with your model design, review the Check Model
messages to identify the issues.
Example - Consolidating Quarterly Data (Single-source Model)
You want to consolidate data using a quarterly time array.
Procedure
Your source data contains the total number of sales for each product by quarter.
You define the Q1, Q2, Q3, and Q4 columns as members of a time array, as
follows:
DATE PRODUCT Q1 Q2 Q3 Q4
200601 Product1 100 200 150 400
200601 Product2 100 175 150 350
200601 Product3 75 100 100 100
200701 Product1 110 210 160 420
200701 Product2 125 200 175 375
200701 Product3 125 150 150 150
Results
Your OLAP reports show the following.
Product 2006 2007 2006+2007
Product1 850 900 1750
Product2 775 875 1650
Product3 375 575 950
TOTALS 2000 2350 4350
Observe how using time arrays yields compact and efficiently processed cubes and
reports.
Example - Consolidating Monthly Data (Multiple-source Model)
You want to consolidate data from more than one source, using a monthly time
array.
You have one data source for each year of data. Each source file contains the total
number of items sold by retailer type (independent stores compared to department
stores) by month.
Procedure
You define the Month01 column in each data source as the first column in a
twelve-member array. You then rename the initial column names, so that Cognos
Transformer can differentiate between the two, changing the initial column in the
second array (2007) to A2Month_01, to distinguish it from Month_01 in 2006.
The consolidated data for Array 1 (2006 Months) is as follows:
DATE TYPE 01 02 03 04 05 06 07 08 09 10 11 12 200601 Sports 05 06 07 05 04 03 06
04 08 02 01 09 200601 General 10 13 07 05 14 15 06 15 08 12 10 05
The consolidated data for Array 2 (2007 Months) is as follows:
DATE TYPE 01 02 03 04 05 06 07 08 09 10 11 12 200701 Sports 10 13 07 05 14 15 06
15 08 12 10 05 200701 General 20 26 14 10 28 30 12 30 16 24 20 10
Chapter 3. Data Sources for Your Model 53
To Next Page
Loading...
Need help?
General