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 !