If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Changing Date format possible?

Started by Steve, 18 Jul 2021 06:51:45 PM

Previous topic - Next topic

Steve

Hi

The source is a SSAS cube and the Date dimension in it has the date in the format MM-DD-YYYY . We have to run the report from the beginning of the month till today and we have the First Date and Last Date for this range defined in FM. The problem is that Cognos generates Date in another format like July 18, 2021 so the filter doesn't work.  There is another SSAS cube which has the date in the format YYYY-MM-DD and with that the filter works perfectly.

The expression we have in FM is

First date = _first_of_month(current_date) - resolves to July 1, 2021
Last Date = current_date                           - resolves to July 18, 2021

So the question is - is it possible to change the date format from July 12, 2021 to 2021-07-12 in Framework Manager?

Thanks a lot !