IBM Support

Cannot filter across TM1 Cubes in the Same Package - Error: Reference to multiple cubes/namespaces in the same query is not supported

Troubleshooting


Problem

When using the filter bar in dashboards or drilling through from one dashboard to another, you receive an error.
We can't load this visualization.
or
Reference to multiple cubes/namespaces in the same query is not supported
The filters passed to the target may include:
- Visualization filter
- This Tab filters
- All Tab filters
- Intersection point selection

Cause

Currently, if your package contains more than one TM1 cube, even though you may have the same dimension in more than one of the cubes, you cannot use the filter bar to filter on that common dimension across the cubes. The same issue applies for drilling from one dashboard to another based on the same package with multiple TM1 cubes. Since the drill through may pass items on the filter bar, if it is on a common dimension from one cube, visualizations from the other cubes will fail.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z0000001jleAAA","label":"Dashboards"}],"ARM Case Number":"TS006001593","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
06 July 2021

UID

ibm16468529