A very common practice for ATG customers is to add properties to existing repository items, for instance by extending the product catalog. The example in this section describes in detail the changes you would need to make if you had added a new attribute, weight, to the SKUs in your catalog. The example assumes that you have already made this change to your repository, and now want to include weight information in your reports.
To add an attribute to a dimension:
Alter the
ARF_SKUtable by adding a new column to represent weight. This column will contain a numeric attribute in your standard measurement system (for instance, pounds or kilograms). The table then contains the following columns:ID
NSKU_ID
...
WEIGHTExtend the
/atg/reporting/datawarehouse/dataWarehouseRepository.xmlfile to expose theweightproperty as in this simplified sample:
<item-descriptor name="sku">
<table name="ARF_SKU">
<property name="weight" column-name="WEIGHT" type="double"/>
</table>
Map the
weightproperty in the product catalog to the weightpropertyin the data warehouse. This mapping is crucial for loading the product catalog dimension. The/atg/reporting/datawarehouse/process/Definition/DimensionProperties.xmlfile contains adata-warehouse-repository-itemelement, which has aproperty-mappingschild element. For this example, we’ll add a newwarehouse-propertyelement under that, identifying how to map the data.<data-warehouse-repository-item item="sku">
<property-mappings>
<warehouse-property name="weight">
<production-property name="catalog.sku.weight"/>
</warehouse-property>
</property-mappings>
</data-warehouse-repository-item>This XML snippet maps the SKU’s
weightproperty in the product catalog to theweightproperty in the data warehouse.Use the Framework Manager to modify the metadata model to include the new attribute (Note: This tool is available only for Windows, and is an optional part of the ACI installation. See the Cognos Framework Manager User Guide). Copy the model to your local project before editing to prevent your changes being overwritten by future ATG updates.
The model is located in the
<ATG9dir>/DCS/DW/cpfdirectory. Modify the [ARF_SKU] query subject in the Database View, the [Sku] query subject in the Model View, and the [Catalog] regular dimension in the dimensional view.Republish the metadata model with your changes.
Copy and modify the provided reports, or create new reports that use the new attribute.
