Getting ?(question mark) in place of ' (apostrophe) in WEBI

building reports webintelligence
1

HI All,

I have data like Microsoft’s products in DB(Oracle DB). And this is LOB in data base. I am developing report on top of it. In Webi for the same text(Microsoft’s Product) I am getting (Microsoft?s) in webi report. When I am trying for the same in Deski, it is working fine.
BO Version: XI R2.

Please help.

Ram

boram (BOB member since 2011-06-21)

2

try to substr the LOB to 4000 chars as BO can’t accept more the 4000 chars.

But still i’m not sure why the 's is not working, may be try to use
Translate() oracle function to translate 's to something relevant to your report

jprasanthram :switzerland: (BOB member since 2010-12-10)

3

I tried with substrng() but no luck. :frowning:

boram (BOB member since 2011-06-21)

4

how abt Translate()?

jprasanthram :switzerland: (BOB member since 2010-12-10)

5

Try applying Replace function and see.

=Replace([Object];"?";"'")

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

6

No luck with translate function also :frowning:

boram (BOB member since 2011-06-21)

7

Hi All,

Any luck with this problem. I am too facing similar issue. I am on both XIR2 and XIR3 version and both have the same error. In XIR2 I see a ? mark in place of apostophe, whereas, on XIR3 I see an inverted ? mark.

I am on Oracle 11 database and the field type is CLOB.

An immediate help is appreciated.

Thanks,
Anushka

anubidesi (BOB member since 2011-07-15)

8

Can any one help me on this???

boram (BOB member since 2011-06-21)

9

Can anyone let me know solution where apostrophe is converted to inverted question mark
Iam on BO4.0

Krithi_chandu (BOB member since 2005-10-13)

10

For anyone looking into this post. Check the clob in Oracle. Mine was stored as inverted question marks in the clob.

Krithi_chandu (BOB member since 2005-10-13)