XQE-PLN-0091 Cross joins error

[karthik.cognos]

Hi,
I've a Cognos FM model which has 2 layers (Database, Logical).

I have imported the tables in Database layer and created joins in this layer.
I have created model query subjects for each table in the logical layer.

When I test the datasource query subjects in the database layer...regardless of the number of datasource query subjects I pick...I'm able to test them...i.e. I see sample data as well as the query being generated under the 'query information' tab.

When I publish the model and try to create reports which use more than 2 tables in the database...I'm running into this error:

RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0091 Cross joins (between query subjects:
[Model Query Subject 1],
[Model Query Subject 2],
[Model Query Subject 3],
[Model Query Subject 4],
[Database Layer].[Data Source Query Subject 1])
are not permitted.

Not sure why I'm running into running this error while running/validating the report...when I am able to test the datasource query subjects in the database layer.

And it is bizarre that why one of the data source query subject is being picked from the database layer and all other query subjects are being picked from the business layer.

Could you please help?

Here are the tools I'm using:
Cognos FM: version 10.2.1 FP4
Database: SQL Server 2012 SP1

[Papave]

Hi,

Did you find the solution/explanation? I'm having the same problem ...

Thanks,

Papave

[bdbits]

You do not want a join across layers like the error message indicates. If you are not explicitly asking for an item out of the database layer query subject, take a look at how that table is joined to the query subjects you are including. My guess would be something is amiss with the way you have modeled the relationships.