Issue with Drill thru Report designed from 2 different cube package

[vishnuvarthan]

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

[MFGF]

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.

[vishnuvarthan]

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

[Lynn]

This is a good post explaining prompt macros.

http://www.cognoise.com/index.php?topic=9015.0