Default value of BeX customer Exit variable not Displayed in WeBI??

[Former Member]

Hello Experts,

We are stuck with a problem where WeBI report is created on top of BeX query and we are not able to see the default value of Bex Customer exit variable in WeBI run. Here is the complete scenario:

1. One restricted KF is created in BeX, restricted with Customer exit variable on net Due date. And this variable is mandatory, ready for input, and Default value in calculated is user exit as current Week's Monday.

2. So, by default KF data should be restricted to Monday of current week, if user does not change this value.

3. Now, WeBI report is created on top of this Bex query, and all is working fine, i.e. we are getting variable as Prompt in WeBI, but Default value is not shown while Running the Webi Report.

So, need your inputs on the same, if default values from BeX in WeBI is supported or not? If yes, why this is happening, and how to resolve it?

Please notice, the restrcition is in KF only, it is not a separate restrcition on Net Due date in Filter area or in Defualt area of BeX

and we are on SAP BW 7.1 and BOXI 3.1 SP4.

Regards,

Vipul

Edited by: VIPUL GOYAL on Nov 23, 2011 9:44 PM

[Former Member]

Need more inputs.

[Former Member]

Default value via customer exit is not supported in WeBI.

[Henry_Banks]

No. They are supported, the restriction will happen, but the value will not be visible to the users.

[Former Member]

No, but we are not able to Run the WeBI report, without giving the any value to it, as variable is mandatory. So, if I have to give value to this variable every time, then it is nvere going to run with Default value.

And our Query Design is such that, Query designer is not allowing to make this variable as optional.

[Henry_Banks]

Hi,

See 1285993 - Support of Customer Exit Variables from BEx query into WebIntelligence via OLAP universe

WebI will prompt when executed, but the default values calculated by the user exit - do not appear.

Note: If the BEx variable has property 'ready for input' set / enabled, then its WebI prompt shows ok, but no default value appears.

Cause

This behaviour expected 'by design' (in the context of the product's current limitations) as explained in the online guide below:

Please refer to Chapter 7, page 44, document link here: http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_olap_universes_en.pdf

Characteristic variable > processing type > Customer Exit is "Supported, without user entry"

--> This should be understood as meaning "User will not be shown a prompt"

regards,

H