IBM Business Analytics

 View Only
  • 1.  Performing operations like finding maximum revenue recorded by a customer

    Posted Sun April 09, 2023 04:20 AM

    I am still in the early stages of learning to use Cognos Analytics. 

    Unable to perform a simple stuff like which customer recorded maximum revenue in 2022.

    https://www.canva.com/design/DAFfmMcIcTc/vMXnkbCUk0yg1oLQbmXdGw/edit?utm_content=DAFfmMcIcTc&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

    Could not locate a filter or any search bar to write function/query.

    In Exploration I could find interesting insights but unable to perform particular action like customer name with maximum revenue.




    ------------------------------
    Rajeev Bagra
    ------------------------------


  • 2.  RE: Performing operations like finding maximum revenue recorded by a customer

    Posted Sun April 09, 2023 06:25 AM
    Create a query and pull in the customer and the revenue. Then open the properties panel for the revenue field and set the aggregation to total. It works like a SUM and GROUP BY statement in SQL. Hope thats a starting point for you.

    Logan Whitaker

    PMO, HEB Supply Chain Planning & Operations

    o: 210.938.6043 m: 210.429.3181

    e: whitaker.logan@heb.com







  • 3.  RE: Performing operations like finding maximum revenue recorded by a customer

    Posted Sun April 09, 2023 07:20 AM

    Thanks for the support.

    Create query from which place. I searched but could not locate any query button. I guess it must be under Exploration tab.

    Screenshot



    ------------------------------
    Rajeev Bagra
    ------------------------------



  • 4.  RE: Performing operations like finding maximum revenue recorded by a customer

    Posted Mon April 10, 2023 01:51 AM

    I also tried Report option. But could not locate any option to create query from Report.



    ------------------------------
    Rajeev Bagra
    ------------------------------



  • 5.  RE: Performing operations like finding maximum revenue recorded by a customer

    Posted Tue April 11, 2023 05:22 AM

    In the screenshot you've posted above, you can see New Report > Pages > Page1 at the top. If you click on New Report it should give you a drop down with Pages, Prompt Pages, Queries etc. If you click on Queries you can create a new query or edit an existing one. Hope that helps.



    ------------------------------
    Chris Turner
    ------------------------------