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.  Cognos Analitics

    Posted 07/06/20 09:51 AM
    Hello everyone!
    Colleagues, I really need your advice on how to create a report with the following format in Cognos Analitics:

    I only have the value "amount of money" and the dimensions "date" and "Person", and I need to display in the report the value for a specific date, and the change from the previous date.
    for example, 01.02.2018 Person1 had 50 of the money, and 01.03.2018 Person1 had 61, so field № 3 is equal to 11 (61-50).
    As you can see, there is no "change" column after the first field, because there is nothing to compare it with.
    Do you have any ideas on how to generate such a report?
    P.S. user selects the start date and end date of the report independently in the invitation

    ​​​​

    ------------------------------
    Alexandra Astakhova
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Analitics

    Posted 07/06/20 08:59 PM
    you can use moving-total function i think

    ------------------------------
    JinHo Ko
    ------------------------------



  • 3.  RE: Cognos Analitics

    Posted 07/07/20 12:17 PM
    I use Cognos 11.1.
    I read that this function was used in version 8. Can I use any analogs?

    ------------------------------
    Alexandra Miroshina
    ------------------------------

    Original Message


  • 4.  RE: Cognos Analitics

    Posted 07/07/20 09:26 PM
    What did you say??
    Are you student or beginner?
    Did you try to find moving-total function at 11.1.x?
    There is no reason remove moving-total functions on cognos analytics
    Windowing-summary functions is very important on OLAP!!!!!

    ------------------------------
    JinHo Ko
    ------------------------------

    Original Message


  • 5.  RE: Cognos Analitics

    Posted 07/08/20 08:46 AM
    Would something like this be acceptable?


    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 6.  RE: Cognos Analitics

    Posted 07/08/20 11:39 AM

    Yes!
    this is what I need!!
    Also, I would like  to see the information for 2006  after the column " Revenue 2004-2005", like this:



    Зplease, can you tell me how to do this?


    ------------------------------
    Alexandra Miroshina
    ------------------------------

    Original Message


  • 7.  RE: Cognos Analitics

    Posted 07/08/20 12:09 PM

    What I did here was add the following calculations to precalculate the values. This is obviously not dynamic as we have no way to know if your data has 2004 or 2005 data prior to running the calculation. Or if there will be 2006 data.

    I don't know of any way to place this anywhere but at the end of the crosstab due to the dynamic nature of a crosstab. The dimensional data that makes up the crosstab dimension is determined at runtime, not statically. We just query the rows in the Year column and display them in sequence.

    Quantity2004
    if ([Sales (query)].[Time].[Year] = '2004') then ( [Sales (query)].[Sales].[Quantity] ) else (0)

    Quantity2005
    if ([Sales (query)].[Time].[Year] = '2005') then ( [Sales (query)].[Sales].[Quantity] ) else (0)

    Quantity 2004-2005
    [Quantity2004]-[Quantity2005]



    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


Related Content