Description:
This function is used to return the current tuple from a set during iteration.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
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 |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
| Code Block | ||
|---|---|---|
| ||
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] |