The Aggregation Policy determines how Teradata OLAP Connector computes aggregates for a level of the hierarchy if the user security role does not have complete access to requested elements. In Teradata Schema Workbench, the two values for Aggregation Policy are as follows:
-
Unrestricted – If the policy is set to Unrestricted, rolled-up aggregate values include all the members, regardless of member security.
For example, this might allow a Western Sales Manager to figure out eastern sales by subtracting western sales from national sales.
-
Restricted – If the policy is set to Restricted, rolled-up aggregate values exclude members for which the user does not have access to.
In contrast to unrestricted, a restricted policy might display deceptive totals for national sales, since eastern sales are not included in the national sales that a security-restricted Western Sales Manager would see.
The following example uses the SampleSchema Product dimension and Store Sales measure. Example 1 shows all the children for the Drink product family in Excel. The current user has complete access to the Drink product family and its children.
Let us modify the role to restrict access of the user to Dairy. Example 2 shows the role after it has been modified, and the user’s view no longer includes Dairy. The aggregation policy is currently set to Unrestricted. Notice the rolled up aggregate value for Drink still includes the value from Dairy, which is not accessible.
Let us modify the roll up policy to Restricted. Example 3 shows the role after it has been modified. Notice the Store Sales value for Drink has changed, and it no longer includes the Store Sales value for Dairy.