SE.INDEX

Returns the index number of an element in a subset.

Syntax

SE.INDEX(Database alias,Dimension,Subset,Element)

Subset is the subset of which Element is a member, and Element is the element whose position within the subset you want to determine.

The Profit dimension of the Sales cube of the Best Practices sample database has a subset called Monetary. This formula returns 1 - the index of the Change in Inventory element.

SE.INDEX("Best Practices OLAP","Profit","Monetary","Change in Inventory")

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.