Skip to Content
0
Former Member
Sep 04, 2008 at 02:57 AM

SAP BW query has mandatory variable, but in webi, it's not prompt

18 Views

Hi,

I have a customer who created a BW query with a mandatory variable. But when he created the webi report and run the query, even he select the variable's object, the prompt is not working unless he select some other key figure.

Here is the definision of the filter in Universe Designer;

The value in the WHERE panel is: <FILTER KEY="[ZTDISTSM]"><CONDITION

OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('District

(Single, Mand)','A','DISTRICT\Lov[ZTDISTSM]

Base',mono,primary_key)"/></CONDITION></FILTER>

Please help if you have any idea.

thanks and regards

nora