Skip to Content

Unable to enter interval values in prompts

Hello Experts,

We are using DS 1.6 SP4 Patch 1 on BI Platform 4.2 SP2 Patch 2. I have an application that uses a BEx query with a mandatory interval variable as a data source. This variable uses a customer exit to pre-populate with the current Fiscal Year/Period but I do not believe that is relevant to this issue. Is it just me or does the standard Prompts dialog not allow a user to enter an "Ends at" value?

I am able to clear the pre-populated date range and select a new "Starts at" value but when I click the Select Ranges button to go back and select an end date I am unable to Add to List; it is grayed out.

I thought maybe a different type of BEx variable would help but it must be a range so no luck there. When the prompt first appears the user can click the text and manually type in a value there without going into the prompt details but this isn't a long term solution. Thank you for any help.

Michael

Add comment
10|10000 characters needed characters exceeded

  • Hi Michael,

    From your screenshots it looks like your application is rendering in SAPUI5 mode rather than SAPUI5 M mode as in Tammy's successful example. If so, can you try the same query in M Mode to check if you still have the same issue there?

    Regards,

    Mustafa.

  • Get RSS Feed

5 Answers

  • Jun 27, 2017 at 02:50 PM

    Hi Michael,

    It sounds like what you are asking for is a value help list for interval variables. I can confirm that in SAPUI5 M Mode, as seen in Tammy's screenshot, value help is unfortunately not supported for range selections. The start and end values must be typed in manually. I know this is not ideal but it appears to be a current limitation of Design Studio.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 26, 2017 at 08:32 PM

    Hi Michael,

    I don't have a customer exit and I can replicate the issue - I have a mandatory interval and this is how my prompt screen appears with the date:

    I'm running Design Studio in m mode

    Do you want to compare BEx query variable settings?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 07:16 PM

    Tammy,

    I tried replacing my customer exit variable with the below SAP-delivered one and still get the same behavior in prompts.

    .

    I then tried an interval variable on a different non-compounded characteristic and it also had the same behavior. Any other ideas before I create an Incident?

    Thanks,
    Michael

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 08:55 PM

    Michael - can you download the latest patch for Design Studio 1.6? Looks like SP5 was released earlier this month.

    Which version/SP of BW are you using? In the sandbox where I tried this I am on BW740

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Michael - my sandbox is BW740 SP12 (so behind yours)

      While SP5 doesn't mention this, there could have been other SP's before that fixed it.

      I agree, it would be good to hear from others in the community about their experiences

  • Jul 24, 2017 at 03:25 PM

    I have found the solution to this: it was our custom .css file causing the issue.

    After upgrading to the latest Design Studio patch (SP5) we were still unable to choose both a Start and End Date. While creating a new basic application to send as an Incident to SAP I noticed the interval was in fact working. Inspecting the elements though a browser lead me to some css code we were using to make a Checkbox Group expand horizontally instead of vertically. Commenting this out returned the Start and End values in the interval variable:

    .sapUiVltCell{ display: inline-table !important; padding-left: 5px; padding-right: 5px; padding-bottom: 1px; padding-top: 1px; }

    Thanks for the suggestions everyone!

    Michael

    Add comment
    10|10000 characters needed characters exceeded