You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the…

There is no built-in attribute named ByAccount that can be added to a dimension; ByAccount is a valid value for a measure's AggregateFunction property, not a dimension attribute.

SQL Server Data Tools (SSDT) provides a property grid where the AggregateFunction property of any measure can be changed directly to ByAccount without writing any code. This setting instructs SSAS to use the account type classifications defined on the Accounts-typed dimension to determine correct aggregation behavior - for example summing revenue accounts but subtracting liability accounts - which satisfies the requirement with minimal development effort.

Using AMO to set the AggregateFunction property to ByAccount achieves the same result as SSDT but requires developing and deploying a separate .NET application, which increases development effort unnecessarily.

FirstNonEmpty aggregates by returning the first non-empty value along the time dimension and is used for semiadditive balance-style measures - it does not aggregate based on account type classification and would produce incorrect results for income statement accounts.