Error in Web Intelligence Rich Client Test

[Former Member]

I am taking the SAP BusinessObjects XI 3.0/3.1: Universe Design course online. Following the steps in the exercise on creating classes and objects, I received an error when testing the objects in Web Intelligence Rich Client. I created a Client Name dimrension using the format CLIENT.CLIENT_LASTNAME + ", "+CLIENT.CLIENT_FIRSTNAME in Universe Designer. When testing I came up with an error, WIS 00011

The Object(s): Client Name contain multiple attributes. This syntax is no longer supported in this version. See your Business Objects Administrator.

I followed the instructions in the exercise. Does anyone know what I did wrong?

[Former Member · Accepted solution]

When you write a select statement the different columns are separated by a comma, as this:

select a, b, c from table

BusinessObjects doesn't like to see that syntax (multiple columns) in a single object, so they look for a comma. It appears that in the version you are using they have broken the parsing process, and they don't realize that your comma is inside quotes and that you're not really using multiple columns.

You can fix this by using a function to return a comma character. If you are using MS Access, that function would be Chr(). The comma character is number 44, so you could try this:

CLIENT.CLIENT_LASTNAME + " " + Chr(44) + " " +CLIENT.CLIENT_FIRSTNAME

But you should know that the syntax you have works fine most of the time.

[Former Member]

Hi Jacqueline,

This is a bug that we found in BO XI R3. We have to use concatenation operator instead of normal operation (CLIENT.CLIENT_LASTNAME + ", "+CLIENT.CLIENT_FIRSTNAME) what you have used. This will work if we use conctenate(CLIENT.CLIENT_LASTNAME ,", ",CLIENT.CLIENT_FIRSTNAME).

But the same functionality (CLIENT.CLIENT_LASTNAME + ", "+CLIENT.CLIENT_FIRSTNAME) we can use it in report designer (rich client, deski, webi) and it works but will not work in designer, thats sad part from BO XI R3. Hope they will resolve this one in next release or in next patch.

Please let me know if you need more information.

Regards,

Chitha.

[Former Member]

Jacqueline,

Probably the online training has not (yet) been updated to match the latest version(s).

However depending on the database you are using you could check which syntax the database needs for concatenating 2 or more strings.

E.g. the syntax could be something like: CONCAT(str1,str2,str3)

or what worked for me was: str1 || ', ' || str2

Regards,

Harry