rowsourceQuery, given information about the source dimension member, row source name, and lookup columns, returns the target dimension members. Uses an index to return an array list containing one or more members in the result set. If there is no mapping, an empty list is returned.
rowsourceQuery(ArrayList<Member> current, ArrayList<Srting> 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.
rowsourceQuery is defined in the cube map as follows:
rowsourceQuery(source_dimension_name, rowsource_name, index_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), “gcIndex1”(index name), and “dcName”(lookup column name) in that order. The index columns of the row source “geographyDC” is the “source member name.”
rowsourceQuery(Geography, geographyToDC, gcDCindex1, 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 index.
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.
rowsourceQuery(Geography, geographyToDC, gcDCindex1, Dist Center Name)
If a row source is time-varying, the first element is used as the lookup value.