Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Error in Crosstab Dashboard

    Posted 10/06/20 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 10/07/20 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 10/08/20 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
    ------------------------------

    Original Message


Related Content