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 )

member A member specification.
AcctTag Valid values (defined in the database outline):
  • First
  • Last
  • Average
  • Expense
  • Two-pass

Example

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

This query returns the following grid:

Opening Inventory
117405

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com