Cognos Analytics

 View Only
  • 1.  Error in Crosstab Dashboard

    Posted Tue October 06, 2020 03:54 PM
    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


  • 2.  RE: Error in Crosstab Dashboard

    Posted Wed October 07, 2020 10:20 AM

    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
    ------------------------------



  • 3.  RE: Error in Crosstab Dashboard

    Posted Thu October 08, 2020 09:08 AM
    Hi Brennan,
    Yes, I have already opened a case, and had a webex with the support department. The case number is TS004305105, if you want to take a look.



    ------------------------------
    Olav Sund
    ------------------------------