Cross joins between query subjects are not permitted.

[nimishabrahamc]

Hi,

I have one package which has Views. I have another package which has a Stored Procedure. I want to create filter parameters for the store procedure from the views which I have created.

After creating the parameters (from the view), when I run the report (table created from the stored procedure)  I get an error

"Cross joins (between query subjects: [DB_DS].[SP_ABC_REPORT], [DB_DS].[VW_XYZ]) are not permitted."

Kindly help me solve this.

Thanks,
acn

[bdbits]

I would venture a guess that your FM model has no relationship between SP_ABC_REPORT and VW_XYZ.

You need to visit with whoever does your modeling.

[nimishabrahamc]

Yes Thanks.