Share via

2.2.4.2.2.5.1 Account

  • Article

Dimensions that are of the type Accounts might have an attribute marked as providing the Account Type (such as Income, Expense, and Balance). Measures can then have an aggregate function of ByAccount. The set of account types defined for a database map the valid account types to the aggregate functions that apply for measures marked with ByAccount.

   <xsd:complexType name="Account">
     <xsd:all>
       <xsd:element name="AccountType" type="xsd:string" />
       <xsd:element name="AggregationFunction" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Sum" />
             <xsd:enumeration value="Count" />
             <xsd:enumeration value="Min" />
             <xsd:enumeration value="Max" />
             <xsd:enumeration value="DistinctCount" />
             <xsd:enumeration value="None" />
             <xsd:enumeration value="AverageOfChildren" />
             <xsd:enumeration value="FirstChild" />
             <xsd:enumeration value="LastChild" />
             <xsd:enumeration value="FirstNonEmpty" />
             <xsd:enumeration value="LastNonEmpty" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Aliases" minOccurs="0" >
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Alias"  type="xsd:string" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="Annotations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Annotation"  type="Annotation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
     </xsd:all>
   </xsd:complexType>

The following table describes the elements that are included in the XSD schema for Account.

Element

Read-Only

Default value

Description

AccountType

[Required]

A string value that represents the name of the account type. The following list of known string values can be extended:

"Income" - Represents an Income account type.

"Expense" - Represents an Expense account type.

"Flow" - Represents a Flow account type.

"Balance" - Represents a Balance account type.

"Asset" - Represents an Asset account type.

"Liability" - Represents a Liability account type.

"Statistical" - Represents a Statistical account type.

AggregationFunction

"Sum"

The aggregation function to use for the Account Type. Each enumeration value is the name of the aggregation function that would be set by choosing that value. The possible values for the enumeration are as follows:

Sum - Calculates the sum of values for all child members.

Count - Retrieves the count of all child members.

Min - Retrieves the lowest value for all child members.

Max - Retrieves the highest value for all child members.

DistinctCount - Retrieves the count of all unique child members.

None – No aggregation is performed. All values for leaf and nonleaf members in a dimension are supplied directly from the fact table for the measure group that contains the measure. If no value can be read from the fact table for a member, the value for that member is set to null.

AverageOfChildren - Calculates the average of values for all nonempty child members.

FirstChild - Retrieves the value of the first child member.

LastChild - Retrieves the value of the last child member.

FirstNonEmpty - Retrieves the value of the first nonempty child member.

LastNonEmpty - Retrieves the value of the last nonempty child member.

Aliases

Empty

A collection of strings, each of which will be treated as an alias for the given Account Type.

Annotations

Empty

A collection of Annotation objects.