Showing posts with label WEBI. Show all posts
Showing posts with label WEBI. Show all posts

Tuesday, November 22, 2011

Searching By BEx Medium Text Problem in WebIntelligence, BO4.

In my project I faced with a problem when in a WEBI prompt window I selected value with medium text (value with text longer than 20 characters) and report didn't retrieve a data.
In this context a problem was with 0COSTCENTER hierarchy.
In other hand, when I run BEx report stand alone, and chose there in filter the same vale, BEx report retrieves data.
Firstly I checked my BEx Report from BICS connection and saw that in Characteristic properties -> display -> Text View is defined as Medium-Length Text.



It was logical, because I saw in prompt text longer than 20 characteristics, but only after selection of a long value report didn't retrieve a data.
After this, I checked InfoObject BEx definitions in RSA1 transaction, BW. To my surprise there also were good definitions: Text Type = 2 Medium-Length Text. But a report still didn't retrieve a data.


After a brainstorming with Valentin Gorelik (Senior BW Consultant), I decided to change "Provider-Specific Properties of the InfoObject". I chose in display property option "F Key and Text as Medium Text".

After these changes the WEBI start to work properly!