Member Specification

A member is a named hierarchical element in a database outline. Represent a member using the following rules:

Syntax

<member> ::= 
           <member-name-specification>
         | <member_value_expression>
<member-name-specification>

A member name can be specified in the following ways:

  1. By specifying the actual name or the alias; for example, Cola, Actual, COGS, and [100].

    If the member name starts with number or contains spaces, it should be within braces; for example, [100]. Braces are recommended for all member names, for clarity and code readability.

    For attribute members, the long name (qualified to uniquely identify the member) should be used; for example, [Ounces_12] instead of just [12].

  2. By specifying dimension name or any one of the ancestor member names as a prefix to the member name; for example, [Product].[100-10] and [Diet].[100-10] This is a recommended practice for all member names, as it eliminates ambiguity and enables you to refer accurately to shared members.

    Note: Use only one ancestor in the qualification. Analytic Services returns an error if multiple ancestors are included. For example, [Market].[New York] is a valid name for New York, and so is [East].[New York]. However, [Market].[East].[New York] returns an error.

  3. By specifying the name of a calculated member defined in the WITH section.
<member_value_expression> Output from any function that returns a member. As an alternative to referencing the member by name or alias, you can use a function that returns a member in place of <member>. For a list of functions that return a member, see Functions by Return Value.

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