Issue with Default value for input ready variable in WebI Report

[Former Member]

We are creating WebI Reports on top of Bex queries connected via BICS.

ISSUE: In Bex query we created input ready variable with default value as current date. This variable is used in RKF and not in characteristic restrictions. The problem which we are facing is that the default value (current date) is not appearing in the WebI Report.

BO version 4.1 SP3

Any pointers regarding the same would be helpful.

[sateesh_kumar1 · Accepted solution]

Hi Ritesh ,

We'll not get the date value display in prompt .You can make an optional variable which runs for current date if leave blank.

[Former Member · Accepted solution]

Hello Sateesh,

As per requirement the variable should show current date value, is there any other way how we can achieve it.

Regards,

Ritesh

[sateesh_kumar1 · Accepted solution]

Hi Ritesh ,

Which version you are in ?

In BI 4.1  , we have option to use  default values defined for variables.

There is check box to use the option in Set variables.

Don't select any value for prompts when developing the report.

because it saves last selected values.So when you select some value other than default , it save the value and will show .

[Former Member]

Hi Ritesh,

Please refer the below SCN Notes/ KBA

1854265 - Input option in Web Intelligence report is not available when the prompt is Bex query vari...

This is a restriction in Web Intelligence when using Bex query with variables.

Variables ready for input:

If you define variables ready for input in BEx Query Designer,
it is not possible to manually enter a string in the prompt
panel in Web Intelligence. You can only select from a list
of values. Manual input is not currently supported for BEx
queries.

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

Solution:

• This should be understood as meaning "User will not be shown a prompt"
• A filter is created in the universe, but its usage is discrete (hidden) to the Webi end-user.
• Data is being filtered during refresh.

We can do some workaround like below if user want it in Prompt.

In WEBI, We'll not able to see the date value in prompt, hence we can check the optional prompt and uncheck the Keep last values selected and give ok.

Within WEBI Report, create a variable

=If(IsPromptAnswered("Start Date")) Then ToDate(UserResponse("Start Date");"MM/dd/yyyy hh:mm:ss A") Else CurrentDate()

If the user selects any date, the WEBI Report will be generated based on the user selected date. Else WEBI Report will be generated based on Current Date.

Hope this helps to some extent...

---Raji. S