Skip to Content
0

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

Nov 14, 2016 at 02:10 PM

364

avatar image
  • 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

variable-1.png (25.5 kB)
variable-2.png (39.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Poovarasan Boopalan Nov 14, 2016 at 02:55 PM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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.

0
Hans Segers
Nov 27, 2016 at 02:19 PM
0

Thanks Mustafa, it is working

Regards

Hans

Share
10 |10000 characters needed characters left characters exceeded