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
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.
Yes Thanks.