Hello,
We have a cross tab report which drill thru to another child report(cross tab). When I am trying to do the drilll thru from parent, I get the following error,
PCA-ERR-0024
The "intersectSet" operator is only applicable on sets with the same dimensions. The number of dimensions in two or more sets is different.
Parent report is designed from a different cube and Child report is designed from a different cube. We have a optional filter (prompt) which we pass into child report. I see this Issue only when I select the optional Prompt value from parent report. If we are not selecting that Optional prompt then drill thru is working fine.
Please help us on this issue.
Thanks,
Vishnu
Hi,
What kind of filter are you referring to? Is it a detail filter? If so, try replacing it with a prompt macro in a calculated item - this way you can define a default value for where the parameter is not set.
Cheers!
MF.
Thanks for the reply MFGF. But I did not understand your solution. I would really appreciate, If you could explain it in detail. how to replace the detail filter with the macro.
Thanks,
Vishnu
This is a good post explaining prompt macros.
http://www.cognoise.com/index.php?topic=9015.0