Characters from object description not appearing in Webi

building semantic layer
1

I’m sure there’s a simple fix for this but it’s driving me nuts. I have an object description that has ‘<’ in it, but when I look at the object in Webi, the ‘<’ disappears. Is there some sort of format I need to use when including ‘<’ in the object description in Designer?

Any help is much appreciated!

Thanks,
Bert

bcmaroon98 (BOB member since 2010-11-12)

2

Hi Bert,

You want to include '< ’ sign in the webi report so just put this in one variable along with the orginal description and do the stuff.Some times it behaves weird.you can directly fix at webi end.

var1 =[Column name] +"<"
or if its in between =substr([Column name],1,4)+"<" +substr([Colunm name],4,8);

county :india: (BOB member since 2011-08-04)

3

Thanks for the response. I should clarify - this is the metadata description for the object that appears during mouseover when creating a report from the universe. Within designer, the description says something like ‘<2%’, but when you mouseover the object when creating a report in Webi, it shows just ‘2%’.

Bert

bcmaroon98 (BOB member since 2010-11-12)

4

Put &#60 2% as description. Since “<” is an opening HTML tag it is creating issue. > is not a problem :slight_smile:

Thanks,

SAP_BO_Addict :canada: (BOB member since 2003-09-18)

5

Sorry if you want to avoid space after “<” then put &#60;2% as description.

SAP_BO_Addict :canada: (BOB member since 2003-09-18)

6

That worked perfectly. Thanks a ton!

bcmaroon98 (BOB member since 2010-11-12)

7

To be honest you are better off getting out of the habit of doing this entirely. It can cause unexpected results down the line.

There is probably less chance of that happening with a description as it is only used in two places, i.e. the query panel and the report object panel…

Naming conventions for objects should be carefully considered, for example, especially when interfacing with other parts of the BO suite or other applications.

Special characters to avoid include the following :

[ ] = &amp; @ ƒ $ % * < > , : ; ? ! ß £ ~ § µ + # . / \ ' ( ) { } "

Reserved words to avoid include the following :

DATE,SELECT,UPDATE,BETWEEN,SET and INSERT

Mak 1 :uk: (BOB member since 2005-01-06)