Skip to Content
avatar image
Former Member

Error in Web Intelligence Rich Client Test

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 05, 2010 at 02:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2010 at 09:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2010 at 03:45 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded