Accounts Element
Collapse the table of content
Expand the table of content

Accounts Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Contains the collection of account types that are defined in a Database element.

  
<Database>  
   ...  
   <Accounts>  
      <Account>...</Account>  
   </Accounts>  
   ...  
</Database>  

CharacteristicDescription
Data type and lengthNone (collection)
Default valueNone (collection)
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementsDatabase
Child elementsAccount

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 Accounts element holds a collection of Account elements, which represent account types and the aggregation function that should be used for each account type.

An account type must be listed if the aggregate function is different from the default used by Microsoft SQL Server 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 AccountCollection.

AccountType Element (ASSL)
Collections (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft