rowsourceLookup, given information about source dimension member, row source name, and lookup columns, returns the target dimension member. Uses key lookup to return an array list containing one member in the result set. If there is no mapping, an empty list is returned.
rowsourceLookup(ArrayList<Member> current, Arraylist<String> extraParams, Dimension d, String namespace)where current is the source dimension member name that is currently being mapped, d is the target dimension, and namespace is the namespace in the target dimension used to construct the result member list.
rowsourceLookup is defined in the cube map as follows:
rowsourceLookup(source_dimension_name, rowsource_name, lookup_column)
In the following example, the source dimension member is passed in the current list. The extraParams string list contains “geographyDC”(row source name) and “dcName”(lookup column name) in that order. The key column of the row source “geographyDC” is the “source member name.”
rowsourceLookup(Geography, geographyToDC, dcName)
extraParams can contain more than two strings passed to the row source key. The first string in extraParams is the row source name and the last string is the lookup column for the target member name, the source member name, and the intermediate strings in extraParams for the row source key.
If a string contains a space, do not enclose it in quotation marks. In the following example, the lookup column “Dist Center Name“ is not enclosed in quotation marks.
rowsourceLookup(Geography, geographyToDC, Dist Center Name)
If a row source is time-varying, the first element is used as the lookup value.