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

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