Skip to content

account-element-assl.md

Latest commit

 

History

History
75 lines (61 loc) · 3.32 KB

account-element-assl.md

File metadata and controls

75 lines (61 loc) · 3.32 KB
title Account Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Account Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
Account
helpviewer_keywords
Account element
ms.assetid 0bb7d06c-0158-4ab2-b2b1-cb50ba24f7c0
caps.latest.revision 41
author Minewiskan
ms.author owend
manager erikre

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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] for each account type.

The set of valid account types is fixed.

The corresponding element in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.Account.

See Also

Database Element (ASSL)
Objects (ASSL)