CURRENT

Description:

This function is used to return the current tuple from a set during iteration.

Note

This function only works with sets that are named, either using a set alias or by defining a named set. Also, it is only valid during an iteration over a set.

Syntax:

Set_Expression.Current

Return Type:
TUPLE

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.

Example:

with member [Measures].[Current] as 
([Product].[Hierarchy].[Product_Category].MEMBERS.current.item(0), 
[Measures].[Order_Quantity]) 
SELECT {[Measures].[Current],[Measures].[Sale_Amount]} on columns, 
[Product].[Hierarchy].[Product_Category] on rows 
from [Dell]