Versions Compared

Version Old Version 2 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

  • By Hierarchy_Expression
    Description:
    This function is used to evaluate a hierarchy expression and returns a set that contains all members of the specified hierarchy, which includes all calculated members in the hierarchy.

    Syntax:
    Hierarchy_Expression.AllMembers

    Return Type:
    SET

    Parameters:

Parameter

Description

Hierarchy_Expression

It is a valid MDX expression that returns a hierarchy.

Example:

Code Block
languagejava
SELECT 
[Measures].[Internet Order Quanlity] ON columns,
   Non empty [Date].[Calendar].AllMembers ON rows
FROM  
   [AdventureWorksMF]

  • By Level_Expression
    Description:
    This function is used to evaluate a level expression and returns a set that contains all members of the specified level, which includes all calculated members in the level.
    Syntax:
    Level_Expression.AllMembers
    Return Type:
    SET

    Parameters:

Parameter

Description

Level_Expression

It is a valid MDX expression that returns a level.

Example:

Code Block
languagejava
SELECT 
[Measures].[Internet Order Quanlity] ON columns,
   [Date].[Calendar].[Calendar Year].AllMembers ON rows
FROM  
   [AdventureWorksMF]