I am getting the following error after trying to have the Query to use the parameter that is created as a part of a different Dimension as a
part of the filteration.
SITECD SITE NAME
Now, the following filteration is failing
[dsCube-].[XXX].[XXX].[SITECD] in (?SiteP?)
The parameter SiteP is generated from a different Query from a different Dimension that has a listing of SITES and their Names. Basically a none-fact table.
Unsupported comparison between objects in different dimensions: dimension1="[SITECD]" and dimension2="[SITE_Listing]". Error processing filter 'members([dsCube].[XXX].[XXX].[SITECD]) in (?SiteP?)'.
Thx in advance for your time!!