Cross-join issue XQE-PLN-0091

[antoxic87]

Hello, experts!

I'm using Cognos 10.2. I've designed a dynamic cube with jdbc(need for dynamic query) connection to oracle 11g. Cube validation performs well. I've a dimension on a fact table in the cube. I create report with this dimension and measures from fact table in Report Studio. it crashes when I run it whis XQE-PLN-0091 eror "Cross joins (between query subjects:... "]) are not permitted. This issue is actual only when I use dimension and measure from same fact table.

How can I use both dimension and measure from same fact table in my query?

[MFGF]

Hi,

It sounds to me like an issue with the design of your cube data. The rules from IBM say that Dynamic Cubes should only be built over star or snowflake schema databases. In both of these, the descriptive items are in the dimension tables and the measures are in the fact tables (with keys that link to the dimensions). If you have both descriptive data and measures in one table, that doesn't sound like a star or snowflake schema to me :)

Regards,

MF.

[antoxic87]

Hi, I agreed that star schema is little bit enchanced in my case.
But this words exist in document "User Guide IBM Cognos Dynamic Cubes" : "Cognos Dynamic Cubes also supports degenerate dimensions. A degenerate dimension is a regular dimension that is based on data in the fact table. When modeling a dynamic cube based on a degenerate dimension, you do not need to specify a measure-to-dimension join."