IsAccType

The MDX IsAccType function returns TRUE if the member has the associated accounts tag. Account tags apply only to Essbase dimensions marked as Accounts. A FALSE value is returned for all other dimension types.

Syntax

IsAccType ( member , AcctTag )

Parameters

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:

Table 4-87 Output Grid from MDX Example

Opening Inventory
117405