Troubleshooting
Problem
Packages with many to many relationships not working in dashboard and stories.
Cause
DQM Package:
Many to Many (full outer join) relationships are not supported in Dynamic Query Mode.
Dynamic query mode assumes that a bridge table has been used to resolve a many-to-many relationship between dimensions.
CQM Package:
When using a CQM Package in Dashboard it will internally treated as DQM.
This implies that DQM restriction apply and also a JDBC connection is required.
Resolving The Problem
Use bridge table to resolve a many-to-many relationship between dimensions.
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Dashboard","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x;11.1.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
13 March 2019
UID
ibm10875970