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
