Troubleshooting
Problem
Error message thrown when running reqports that have been migrated from Compatible Query Mode (CQM) to Dynmaic Query Mode (DQM)
Symptom
XQE-PLN-0227 An illeagal many-many cardinality is found between query subjects: [Query Subject 1] and [Query Subject 2]
Cause
Many to Many (full outer join) relationships are not supported in Dynamic Query Mode.
Resolving The Problem
Create a Bridge table in the Framework Manager Model.
For details on how to create Bridge Tables in Framework Manager, see Bridge tables in the Framework Manager User Guide. Additional recommended reading - IBM Cognos 10 Dynamic Query Mode Migration Scenarios.
Related Information
[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Authoring v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.7;11.0.6;11.0.5;11.0.4;11.0.3;11.0.2;11.0.1;11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
12 September 2022
UID
swg22009664