Cross joins (between query subjects:XXX) using Report Author and FM MODEL PKG

[gosoccer]

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

[MFGF]

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.

[gosoccer]

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.

:)

[MFGF]

Glad it was an easy fix! :)

MF.