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

[Former Member]

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

[Former Member]

To use atleast one measure has resolved the issue.

[Former Member]

Hi Adil,

Thanks for your info as yes, once customer select one measure, the prompt will work.

And Ingo, the version is XIR2.

thanks and regards

nora

[IngoH]

hi Nora,

is this XIr2 or XIr3 ?

Ingo

[adil_madid]

"To process BW variables in Web Intelligence, you must include at least one measure in the Web Intelligence query."

Quoted from SAP olap universe guide page 44.

Regards,

Adil