It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882
×12,008
×7,478
×145
×42

question asked: Jan 22 '13, 8:50 a.m.
question was seen: 6,239 times
last updated: Jan 22 '13, 11:52 a.m.

Related questions

RRDI creating cascading parameter retrieve Cross-join error

0
Milan Krivic (980●13●176●143) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Alanna Zito (1.3k●3) | 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.