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

converting integers to string in framework manager

Started by shark1986, 25 Apr 2022 11:39:14 AM

Previous topic - Next topic

shark1986

Hi guys, I need some help.
I'm creating a new "month name" field in Framework Manager from the existing month field.
For that I'm doing it like this:

CASE
WHEN MONTH(CREATIONDATE) = 1 THEN '01-JANUARY'
WHEN MONTH(CREATIONDATE) = 2 THEN '02-FEBRUARY' and so on.

But it's giving an error on the dashboard, asking to convert from integer to string, what's the best way to do it?
By Framework Manager it is not possible to change.

bus_pass_man

That expression works for me.  I tried it in FM, published a package with it as an query item added to a query subject and added that query item to a widget, and also created a calculation in the dashboard with the expression.  It worked in all cases.   The data type of Date is date time but that shouldn't matter as the returned value of the month function is an integer. 

CASE
WHEN month  ([Business view].[Time].[Date]  ) = 1 THEN '01-JANUARY'
WHEN month  ([Business view].[Time].[Date]  )= 2 THEN '02-FEBRUARY'
end


Can you elaborate what you mean by " it's giving an error on the dashboard" and "asking to convert from integer to string".