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’.