In addition, field attributes used by Data Mart might be inadvertently changed for some other purpose in a way that undermines their intended use in the Mart. The following sections describe some simple ways to minimize this risk.
Restrict Access to Data Mart Fields
You can restrict the field attributes so that only one user or business group is authorized to change them. This requires that your Data Mart field attributes not be used for OLAP reports or other uses.
Limit the Number of Entities per Model Manager
Similar to the number of entities per OLAP process you can also control the number of entities per model manager. You can increase or decrease the default value of 1,000.
Use a Naming Convention to Clarify Mart Usage
You can reduce use of your Data Mart fields for unintended purposes by prepending them with “dm” or a similar convention.
Use Comments to Identify Mart Fields
Each field attribute features a Comments section displayed in the Data Mart field selector. You can display a standard comment during model field selection, leading you to select only designated Mart field attributes.
Usage Indicator in the Mart Field Add Window
A blue dot next to any field in the Add window, linked from the model UI Fields tab, indicates that the field is used in another model. Your field attribute list may contain multiple field attributes with the same description. If so, the blue dot indicates which of those same-named fields you have used elsewhere in the Mart. You can then reselect the blue-dot fields to maintain consistency of business definition across models.
Add Comment