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 outline):
-
First -
Last -
Average -
Expense -
TwoPass
-
Example
SELECT
Filter([Measures].Members, IsAccType([Measures].CurrentMember, First))
ON COLUMNS
FROM Sample.BasicThe above query returns the following output:
Table 4-87 Output Grid from MDX Example
| Opening Inventory |
|---|
| 117405 |