Help...
Upgraded CRN and FM to 1.1. Opened project, verified model. Saved project and published package. Opened report, report validated. However, when I run the report, and select an item in a prompt that another prompts uses as a source for cascading, I get the following error:
QE-DEF-0103 Cross joins are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Server Administrators, Directory Administrators, Report Administrators, Authors, Query Users, Consumers, System Administrators, Root User Class, Administration}'.
If I run tabular data for each of the queries, they all run
fine. I set the "Cross-Product Allowed" property to "Allow" in the dependent prompt query, the prompts work; however the queries take a long time to run. This should not result in a cross-join as the data for both prompts is coming from only one table.
If I re-create the prompts, I still get the error.
If I create a new report in 1.1 with cascading prompts, from the same data model, I do not get the error.
Upgraded CRN and FM to 1.1. Opened project, verified model. Saved project and published package. Opened report, report validated. However, when I run the report, and select an item in a prompt that another prompts uses as a source for cascading, I get the following error:
QE-DEF-0103 Cross joins are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Server Administrators, Directory Administrators, Report Administrators, Authors, Query Users, Consumers, System Administrators, Root User Class, Administration}'.
If I run tabular data for each of the queries, they all run
fine. I set the "Cross-Product Allowed" property to "Allow" in the dependent prompt query, the prompts work; however the queries take a long time to run. This should not result in a cross-join as the data for both prompts is coming from only one table.
If I re-create the prompts, I still get the error.
If I create a new report in 1.1 with cascading prompts, from the same data model, I do not get the error.