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