SAP Design Studio 1.6 SP03 - Prompt Screen - "Select from List " - no values are displayed

[hans_segers]

• SAP Design Studio 1.6 SP03
• BIP Modus
• source : Calculation View in HANA SPS10

Dear all,

I'm showing the prompt screen in my Analysis Application to display the variables defined in the HANA view.

One of the variables is based on a DATE field.

Two questions :

• The list of values are not displayed in the Prompt Screen
• How can I display a calendar control (date-picker) ?

Screenshot of Prompt Screen : the list of values is empty

Definition of the Variable in the HANA view :

Thanks for sharing your ideas

Hans

[former_member265529]

Hi Hans,

The prompt screen shows only 1000 values in list. If the object has more than 1000 values it will prompt the user to search a keyword to reduce the list to below 1000 values.

So It will not display the list in your case as the dates list will have more than 1000 values.

To select the date from calendar, you can use the Date field component to set value for the prompt.

Thanks,

Poovarasan

[hans_segers]

Thanks Poovarasan.

The problem with the Date field component is the returned value : it is in Text-format, not in Date Format.

There is no conversion function Text --> Date.

I'll try it anyway.

Thanks

Hans

[MustafaBensan]

Hi Hans,

The data type of the variable is not directly relevant. i.e. the fact that the Date Field returns a string value does not make it incompatible with your date variable data type. The Date Field returns the date in internal format: "YYYYMMDD". This should be compatible when you apply setVariableValue(date, <datevalue>) because it requires internal format.

Regards,

Mustafa.

[hans_segers]

Thanks Mustafa, it is working

Regards

Hans