Account Element (ASSL)
Contains details about an account type within a Database element.
Syntax
<Accounts>
<Account>
<AccountType>...</AccountType>
<AggregationFunction>...</AggregationFunction>
<Aliases>...</Aliases>
<Annotations>...</Annotations>
</Account>
</Accounts>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data type and length | None |
| Default value | None |
| Cardinality | 0-n: Optional element that can occur more than once. |
Element Relationships
| Relationship | Element |
|---|---|
| Parent elements | Accounts |
| Child elements | AccountType, AggregationFunction, Aliases, Annotations |
Remarks
Dimensions, whose Type element is set to Accounts, can have an attribute that specifies the account type, such as Income, Expense, and so on, represented by members in the dimension. The account type is then used by Measure elements, whose AggregationFunction element is set to ByAccount, to determine the aggregation function to use when aggregating the members of that dimension. The Account element represents a single account type and the aggregation function that should be used by such measures.
An account type must be listed if the aggregate function is different from the default used by Analysis Services for each account type.
The set of valid account types is fixed.
The corresponding element in the Analysis Management Objects (AMO) object model is Account.