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.  Using typed-in SQL and Chart

    Posted 04/17/20 12:18 PM
    Hi everybody,

    I'm trying to show a chart that use a typed-in SQL query, although I can see the tabular data but when the report runs the chart is empty. I was trying using just a report list to see if it worked but neither.

    Welcome any suggestions.

    Thanks in advanced.



    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Using typed-in SQL and Chart

    Posted 04/20/20 02:23 PM
    Make sure the measure aggregation is set to total for detail and summary​

    ------------------------------
    Stephune Waites
    ------------------------------



  • 3.  RE: Using typed-in SQL and Chart

    Posted 04/24/20 10:42 AM
    That's right! Thanks a lot Stephune!

    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Original Message