IsAccType

Returns TRUE if the member has the associated accounts tag. Account tags apply only to dimensions marked as Accounts dimensions. A FALSE value is returned for all other dimensions.

Syntax

IsAccType ( member , AcctTag )
ParameterDescription

member

A member specification.

AcctTag

Valid values (defined in the database outline):

  • First

  • Last

  • Average

  • Expense

  • TwoPass

Example

SELECT
Filter([Measures].Members, IsAccType([Measures].CurrentMember, First))
ON COLUMNS
FROM Sample.Basic

This query returns the following grid:

Opening Inventory
117405