Hi Olav, thanks for your question.
The way that queries are generated when using a Crosstab differs from other visualizations on the dashboard. We would need some more context to speak specifically to your case.. Have you opened a case with IBM Support about this yet?
We can work with the Support team to see if the issue can be resolved, or if the query is indeed not supported, to get you a tech note or some other form of documentation to provide you with other options.
------------------------------
Brennan Fox
Product Quality @ IBM Cognos Analytics
------------------------------
Original Message:
Sent: Tue October 06, 2020 05:21 AM
From: Olav Sund
Subject: Error in Crosstab Dashboard
Hi,
I get the error message: "The query is not supported. The 'within detail' clause in the dataItem 'summary:id912813276' refers to measure 'id912813276' . Aggregation over measure sets is not supported." when I put in a specific filter(relative time) in a crosstab in Dashboards.
The dimension I try to filter on works fine in all other widgets. The Crosstab also works fine if I remove the filter, or with any other filter.
Everything is from a relational FM Model.
Is there something this widget does not support that all the others do?
Any suggestions on how to solve this?
Br,
Olav
------------------------------
Olav Sund
------------------------------
#CognosAnalyticswithWatson