Description OK in BO Reporter ==> Description K.O. in Web

Good evening!

I have another problem with BusinessObjects Enterprise 6.

Using B.O. Reporter, of course, I can insert a DESCRIPTION that will appear con the W.I. Web Panel, showing corporate documents.

This works great in B.O. Reporter, but when publishing to corporate documents any comment is TRUNCATED!!

I can see on W.I. only the last X WORDS of the comment, with X variable (random!!).

How can I fix this?

Please help me, I have no idea on how to bypass this bug!!

Thanks very much in advance for your cooperation,


Christian Konrads :it: (BOB member since 2004-07-21)

What version are you on ?
I am running 6.1a and the comments appear correctly if this is what you are looking for:

ISR Customer History Report 
This report displays a CCN customer's order and related shipment history information. The report is "prompted" requiring key entry of a customer's CCN number when the report is run (refreshed). 
Domain: Document
From: salesadmin
Date: 04/16/2004 02:01:03 PM
Size: 133 K
Edit  Delete  Properties  

From the Corporate Docs menu, view details option. They also show up when I select the document properties. Have you tried to refreshed the list?


Michele Pinti (BOB member since 2002-06-17)

What version are you on ?

BusinessObjects Enterprise 6, WebIntelligence 6.

From the Corporate Docs menu, view details option. They also show up
when I select the document properties. Have you tried to refreshed the
list?

Yes, I refreshed the list but 80-90% of the descriptions appear truncated.

For example, the description:

“This report plots the dropped calls on the selected area”

appers as:

“Description: ped calls on the selected area”

I don’t understand WHY :frowning:


Christian Konrads :it: (BOB member since 2004-07-21)

The descriptions are stored in multiple records each storing 255 bytes. It looks as if you are missing the first entry. If you are seeing the full description using full client then it sounds like a bug in the Webi software and there may not be any workaround and you may have to open an issue with tech support.

6.0 6.1a 6.1b ?


Michele Pinti (BOB member since 2002-06-17)

6.0 6.1a 6.1b ?

Hello Michele, how can I see what version of WebIntelligence am I using?

I cannot have access to the unix directories in which are stored the files necessary for the Web Server.

I don’t know login & password.


Christian Konrads :it: (BOB member since 2004-07-21)

A collegue told me that we are using WebIntelligence version 6.1b

:slight_smile:


Christian Konrads :it: (BOB member since 2004-07-21)

… for HP-UX!!


Christian Konrads :it: (BOB member since 2004-07-21)

The descriptions are stored in multiple records each storing 255 bytes

I can try to leave 255 blanks, and then to begin the real description.

If the bug leaves out the first entry (populated with all blanks), it will work.


Christian Konrads :it: (BOB member since 2004-07-21)

I tried to write AAA…AAA (255 times) BEFORE the description, but it doesn’t work :frowning:

The system seems to fetch the last:

length(description)-255

characters…

Absurd!! :open_mouth:


Christian Konrads :it: (BOB member since 2004-07-21)

OK!!! :wink:

The case is closed.

Now I explain what’s happening!!

The algorithm for the DESCRIPTIONS (File / Properties) in B.O. Enterprise 6 and WebIntelligence 6 is the following:

IF LENGTH(DESCRIPTION) < 255 THEN PRINT DESCRIPTION;
IF LENGTH(DESCRIPTION) >= 255 THEN PRINT SUBSTR(DESCRIPTION, 255, LENGTH(DESCRIPTION)-255)

I am not sure if the number is 255 or 254…

EXAMPLE NO. 1:

Description = ‘This is a test’

WebIntelligence 6.1b writes: This is a test

EXAMPLE NO. 2:

Description = ‘Questo Report illustra una sintesi ed un dettaglio dei soli Allarmi Ericsson TACS DECODIFICATI. La prima cartella contiene la sintesi totalizzante gli Allarmi DECODIFICATI raggruppati per SLOGAN, mentre con la seconda cartella risulta possibile scendere in dettaglio e visualizzare il singolo Allarme DECODIFICATO.’

WebIntelligence 6.1b writes:

ere in dettaglio e visualizzare il singolo Allarme DECODIFICATO.

Thanks for your cooperation, the number ‘255’ helped me to understand! :wink:


Christian Konrads :it: (BOB member since 2004-07-21)

BTW, I had this same issue with the Universe description and there is the same 255 character limit on that. I had opened a case and Tech Support told me about the limit. I had to type it in Word to keep track of how many characters I had and then copy and paste it into Designer.


mtrembla (BOB member since 2003-08-18)

[…] with the Universe description and there is the same 255 character
limit on that […]

Very interesting, I’ll remember this.

Thanks.


Christian Konrads :it: (BOB member since 2004-07-21)