Folks,
I am getting the following error after I add a filter to Q1 to do the following,
[Business View].[L_ORG].[ORG_CD] in (?OrgParam?)
Here is the error I am getting,
Cross joins (between query subjects: [Business View].[L_REL], [Business View].[L_ORG], [SD Report].[SD_Rpt_Data]) are not permitted for the user who has the identity '*'.If anyone can shed some light on this, I'll greatly appreciate it.
Thx
Hi,
Can you tell us a little more about your report? What queries does it have? What data are you using in them? What kind of objects are in the package - dimensional, relational or a mixture? Are you trying to reference an item from one query in another?
MF.
Meep. I just resolved the issue. It was just a regular report Query (non-cube or DMR) and I was referecing an item from a different Query within the main Query.
Problem has been resolved but I appreciate the quick reply.
:)
Glad it was an easy fix! :)
MF.