To add and set up a Partition Mapping Table in a Strategy 9.4.x - 10.x project, users have to follow the steps below.
Create the Partition Mapping Table (PMT):
This table must be created with the following structure:
Report: R1
Job: 677
Data Rows: 12
Data Columns: 3
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_DOLLAR_SALES) ANORMALSUM,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1,
sum(a11.TOT_DOLLAR_SALES) WJXBFS2,
sum(a11.TOT_DOLLAR_SALES) WJXBFS3,
sum(a11.TOT_DOLLAR_SALES) WJXBFS4,
sum(a11.TOT_DOLLAR_SALES) WJXBFS5,
sum(a11.TOT_DOLLAR_SALES) WJXBFS6,
sum(a11.TOT_DOLLAR_SALES) WJXBFS7
from MNTH_CATEGORY_SLS a11
join LU_MONTH a12
on (a11.MONTH_ID = a12.MONTH_ID)
where a12.YEAR_ID in (1998)
group by a11.MONTH_ID
ATTRIBUTE_IDPBTNAME
|
Report: R1
Job: 677
Data Rows: 12
Data Columns: 3
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_DOLLAR_SALES) ANORMALSUM,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1,
sum(a11.TOT_DOLLAR_SALES) WJXBFS2,
sum(a11.TOT_DOLLAR_SALES) WJXBFS3,
sum(a11.TOT_DOLLAR_SALES) WJXBFS4,
sum(a11.TOT_DOLLAR_SALES) WJXBFS5,
sum(a11.TOT_DOLLAR_SALES) WJXBFS6,
sum(a11.TOT_DOLLAR_SALES) WJXBFS7
from MNTH_CATEGORY_SLS a11
join LU_MONTH a12
on (a11.MONTH_ID = a12.MONTH_ID)
where a12.YEAR_ID in (1998)
group by a11.MONTH_ID
ATTRIBUTE_IDPBTNAME
|
Report: R1
Job: 677
Data Rows: 12
Data Columns: 3
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_DOLLAR_SALES) ANORMALSUM,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1,
sum(a11.TOT_DOLLAR_SALES) WJXBFS2,
sum(a11.TOT_DOLLAR_SALES) WJXBFS3,
sum(a11.TOT_DOLLAR_SALES) WJXBFS4,
sum(a11.TOT_DOLLAR_SALES) WJXBFS5,
sum(a11.TOT_DOLLAR_SALES) WJXBFS6,
sum(a11.TOT_DOLLAR_SALES) WJXBFS7
from MNTH_CATEGORY_SLS a11
join LU_MONTH a12
on (a11.MONTH_ID = a12.MONTH_ID)
where a12.YEAR_ID in (1998)
group by a11.MONTH_ID
ATTRIBUTE_IDPBTNAME
|
Report: R1
Job: 677
Data Rows: 12
Data Columns: 3
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_DOLLAR_SALES) ANORMALSUM,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1,
sum(a11.TOT_DOLLAR_SALES) WJXBFS2,
sum(a11.TOT_DOLLAR_SALES) WJXBFS3,
sum(a11.TOT_DOLLAR_SALES) WJXBFS4,
sum(a11.TOT_DOLLAR_SALES) WJXBFS5,
sum(a11.TOT_DOLLAR_SALES) WJXBFS6,
sum(a11.TOT_DOLLAR_SALES) WJXBFS7
from MNTH_CATEGORY_SLS a11
join LU_MONTH a12
on (a11.MONTH_ID = a12.MONTH_ID)
where a12.YEAR_ID in (1998)
group by a11.MONTH_ID
ATTRIBUTE_IDPBTNAME
|
The ATTRIBUTE_ID column name must match the column name on the partitioned base tables. This column contains the values of the attributes at which the tables are partitioned.
For example, if the partition level is at Year, this column will be named 'Year_id' and contain values such as: 1998, 1999 and 2000.
The PBTNAME column name cannot be changed. This column contains the names of the partitioned base tables. PBTNAME = Partitioned Base Table Name.
Add the PMT to the project:
- Open the Warehouse Catalog under the Schema menu. The users' Partition Mapping Table appears in the left window.
- Highlight the table and select the arrow pointing to the right.
