Cognos Analytics

 View Only
Expand all | Collapse all

uncorrected date format settings

  • 1.  uncorrected date format settings

    Posted Tue July 07, 2020 12:39 PM
    Hello everyone!

    please help me figure out why I can't configure the date format.
    I put the date format 'dd.mm.yyyy' in the Framework and publish the package. However, in Cognos Analytics, I still get values similar to"1980-01-01 00:00:00".
    Why can this happen?


    Also, I can't set the date format if it is in the hierarchy.
    For example, I want to configure the date format, but I can choose either text or " default"


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

    #CognosAnalyticswithWatson


  • 2.  RE: uncorrected date format settings

    Posted Wed July 08, 2020 05:54 AM
    Hi Alexandra,

    you cannot format the hierarchy nor level objects, because these are text items, a label/ caption.
    This is why you only have 'Text' as option to apply a format to.

    You are able to apply formats on members or their properties.

    The format in Framework Manager defines how data is represented in your report.
    In case of a DMR model this format will not specify how the hierarchy or level caption will be presented. To do so you've to use appropriate functions, like CAST() so the required values populates the label/ caption.

    I hope this helps.

    Kind regards

    #CognosAnalyticswithWatson