CROSSLINK
With CROSSLINK you can retrieve specific data fields from different database formats. You can do this more efficiently with ROA and MEMBERGET functions.
Syntax
=CROSSLINK(database_type,"element_name",position)Example
=CROSSLINK(2,"[Date].[All Periods].[FY 2002]",3) returns FY 2002=CROSSLINK(2,"[Date].[All Periods].[FY 2002]",2) returns All PeriodsNote: For OLAP databases, the Database Type is 1. For Analysis Services
data sources, the Database Type is 2.