It's all about the answers!

Ask a question

RRDI creating cascading parameter retrieve Cross-join error


Milan Krivic (9707155128) | asked Jan 22 '13, 8:50 a.m.
edited Jan 22 '13, 8:51 a.m.
Hi,

When creating cascading report parameter in RRDI, getting the following error:

Cross joins (between query subjects... (in my case: different query subjects)): are not permitted for the user who has the identity '*'.

Actually, for report data, I am using one query, and for reporting parameter, I am using other query.

I tried to build Cascading parameter regarding Projects and it's categories. When I test it before displaying data, it populate project categories based on selected project, but on displaying data, it displays mentioned error about cross joins not permitted.

When I remove Project cascade from Category parameter in options, everything works well.

Any idea how to solve this?

One answer



permanent link
Alanna Zito (1.3k3) | answered Jan 22 '13, 11:52 a.m.
JAZZ DEVELOPER
Hi Milan,

This technote - http://www-01.ibm.com/support/docview.wss?uid=swg21341798 - has some information about what this error message means, and how you can enable cross joins for your query.

Your answer


Register or to post your answer.