Skip to Content
0
May 13, 2010 at 01:14 PM

It will not parse! Creating a new object in the universe

27 Views

Hi, we have a universe and BO reports. They work fine for our clients. We are on BO XI r3.1. Now, one client captures an additional piece of info. They would like to report against this and add it high up on our drilling heirarchy. "Sure, no problem". For the following I was logged in as administrator.

The additional data field is a 3 character code.

1) We added an additional column to the actual database table.

2) In Universe Designer, I refreshed universe structure and could see the additional column

3) Created an object 'Acode' that refers to db.new_field

4) Exported universe

Maybe worth mentioning that I can see this object and use it in reports fine in Infoview.

Now, I need to create a new object that will be one of 2 strings based on the 3 character code (Acode) i.e. the 'Atype' can be X or Y.

Here's my code and it just will not parse:

CASE

WHEN @Select(AFolder\Acode) = 'CEL'

THEN 'X'

ELSE u2018Yu2019

END

Error I get is:

Parse failed:Eception:DBD ODBC SQL Server driverStatement could not be prepared.State 42000

I'd appreciate any help, believe me I have searched the forums!

Thanks, Eddie