Cognos Analytics

 View Only

  • 1.  Changing relative date default column in Data Module

    Posted Thu January 09, 2020 06:00 AM
    Hi,

    we are building Data Module for analyzing revenue data. Maybe there is simple solution but we haven't found it so far.
    Our main date column is FLIGHT_DATE and we want that column to be source for Relative Date Analysis (and not "Today")
    which is passed in _as_of_date parameter.

    For example, today (9/1/2020) current month for relative date analysis is 1/2020. 
    We would like that current month is referenced to month of FLIGHT_DATE, if we choose FLIGHT_DATE in 12/2019 for analysis we would like that 12/2019 is current month and 11/2019 is previous month.
    Also, acceptable option is also that we can maybe choose _as_of_date and provide a value of that date.

    Can the default _as_of_date be changed (not hardcoded, it should be passed from other column) or paired in any way that it does not reference on "Today"?

    Now we have a situation that we cannot compare data from 12/2019 with data from 11/2019 (there is no default measure for prior -1), and we cannot compare 12/2019 with 12/2018 (there is not default measure for that, we only have Same month last year which means 1/2019).

    Thanks in advance for answers and sorry if question is not well explained

    ------------------------------
    Dino Juričić
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Changing relative date default column in Data Module

    Posted Mon January 13, 2020 05:09 PM
    You cannot set _as_of_date from another column, but it can be changed to a specific date for many users as per 
    https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/t_ca_rel_date_set_as_of_date.html

    and the users themselves can change it as per https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/t_ca_rel_date_customize.html

    ------------------------------
    JASON TAVOULARIS
    ------------------------------

    Original Message


  • 3.  RE: Changing relative date default column in Data Module

    Posted Tue January 14, 2020 12:27 PM
    I'm wondering if there is a way to extrapolate the relative difference between your base period (FLIGHT_DATE) and the default _as_of_date parameter? This would require some conditional/lookup logic in your filter expressions, and might even be "easier" to just calculate these relative dates manually vs. using the built-in features. It sounds like you'll have to go back to the old-fashioned way of calculating relative dates, using the built-in date functions in the reports expression builder.

    ------------------------------
    Albert Valdez
    albert@intelalytics.com
    ------------------------------

    Original Message


  • 4.  RE: Changing relative date default column in Data Module

    Posted Tue January 14, 2020 02:37 PM
    Hi Dino,

    With regards to:      Can the default _as_of_date be changed (not hardcoded, it should be passed from other column) or paired in any way that it does not reference on "Today"?

    As mentioned in a previous message, the user can change the global parameter.  Another way would be to create a Date Prompt for the report and associate it with the parameter _as_of_date
    The user will then be prompted to select an _as_of_date value, which by default is set to the value of the global parameter.
    //Henk


    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message