Embedded calc works in FM but not in RS

[AjaxNU]

Hi,

I created an embedded calculation in Framework Manager that tests fine there but gives incorrect results in Report Studio.Ã,  The calculation is a case statement with some vendor-specific functions (DB2).Ã,  In RS, instead of returning a different value for different inputs, it only returns the value from the first WHEN-THEN clause.Ã,  An excerpt of the calculation is:

CASE right ( rtrim ( char ( [Import View].[Period Dimension].[PERIOD_ID] )), 2 )
WHEN '01' THEN 'January ' || left ( ltrim ( char ( [Import View].[Period Dimension].[PERIOD_ID] )), 4)
WHEN '02' THEN 'February ' || left ( ltrim ( char ( [Import View].[Period Dimension].[PERIOD_ID] )), 4)

The [PERIOD_ID] query item is an integer, e.g. 200510.Ã,  Any ideas on what's breaking the calculation would be very helpful!

Thanks,
Aja