It's all about the answers!

Ask a question

RRDI creating cascading parameter retrieve Cross-join error


Milan Krivic (98010172139) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.