Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  date shows wrong format in report studio

    Posted Thu July 23, 2020 02:25 PM
    I'm using Cognos studio report to customize the email subject which has this year value
    The set up looks right in FM, but when email comes out it shows '103,020' instead of '200'

    I also tried to add CAST as varchar(4) in FM, but still same. Any one can help please?



    ------------------------------
    ella
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: date shows wrong format in report studio

    Posted Thu July 23, 2020 07:59 PM

    Your calculation probably has a usage set to measure.   Because of that, the 2020 is being treated as a number rather than what you want, which is the year portion of the current date.  103,020 is 2020 * 51.

    If you set it to attribute you will probably see something more in line with your expectations.



    ------------------------------
    IAN HENDERSON
    ------------------------------

    Original Message


  • 3.  RE: date shows wrong format in report studio

    Posted Thu July 23, 2020 10:18 PM
    Did I set as measure in FM or report studio?



    Original Message


  • 4.  RE: date shows wrong format in report studio

    Posted Fri July 24, 2020 06:35 AM
    You would do this in Framework Manager.  Usage is a property of the query item.

    ------------------------------
    IAN HENDERSON
    ------------------------------

    Original Message


  • 5.  RE: date shows wrong format in report studio

    Posted Fri July 24, 2020 01:55 PM
    You are right!! it works!! thank you

    ------------------------------
    ella ye
    ------------------------------

    Original Message


Related Content