Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strange symbols ("@{ }@") in prompts field value

Status
Not open for further replies.

Lee73

Technical User
Jan 16, 2004
20
0
0
IT
Hi all,

I passed recently to BO ver 6.1.a with the implementation of webi.
I noticed that in some refresh test, the reports that contain parameters
sometimes take strange symbol like "@{ }@" plus the parameters value expecially when the prompts field is displayed in the rep.

For example: I have a prompt variable for Site like Milan, Rome...

Sometimes in the report the Site prompt is shown like "@{Milan; @{Rome }@" ...

Is there someone that have already faced this issue?
Can you help me?
Thanks in advance

Sabry
 
Can't say I have. What is the RDBMS you are working with?

If it is just down to characters @,{,} you may get away with nested REPLACE functions to prune them out.....

T. Blom
Information analyst
tbl@shimano-eu.com
 
I believe this is a known bug and has been fixed in one of the hotfixes.

I am only having those characters show up if I have a comman in one of my actual values that is part of the LOV. I those characters weren't there, I'd have a problem.

Steve Krandel
Westbay Solutions
 
Hi Bloom0344 and Skrandel,

thanks for your suggestions, in fact I already tried to solve this bug with Replace formula, I think it's not the best solution.

Skrandel do you remember what hotfix did you use? As I already installed the Hotfix103 but nothing happens.

Thanks

Sabry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top