Unable to enter interval values in prompts

[schulerm1]

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

[MustafaBensan]

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.

[schulerm1]

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

[MustafaBensan]

Hi Michael,

Thanks for sharing the cause and resolution. I guess we have to be careful of potential side-effects of using custom CSS 🙂

Mustafa.

[TammyPowlas]

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

[schulerm1]

Tammy,

Our BW is 740 SP15. I checked the documentation of SP5 and didn't see any mention of this issue... We have been forced to upgrade to the latest DS SP literally every time one becomes available due to issues so I'd hate to bother my systems admin with another upgrade unless I'm sure this solves the issue.

Is your version of Design Studio the only difference that you can tell? I'd be interested if there are others reading this who may also have this issue.

Thanks,

Michael

[TammyPowlas]

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

[schulerm1]

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

[MustafaBensan]

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.

[TammyPowlas]

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?

[schulerm1]

Hi Tammy,

My application is in SAPUI5 mode but when I save it as M Mode there are still prompt issues. First, the entry fields are collapsed and the pre-populated value of Fiscal Year/Period flashes in and out of visibility in both Chrome and IE11 (definitely a bug or some other issue):

Also, when I go into the details of the Interval variable I am still unable to choose both a From and To variable from the list (though I can specify the range under Define Conditions).

Here are the settings of my BEx interval variable; I don't think any other variable type will work for my needs.

Just to be clear, your M-Mode prompt screen DOES have the same issue as mine? Thanks for your help!

[TammyPowlas]

Hi Michael - I am not experiencing this issue. My settings are similar to yours - could you try this with another date that has no exit on it? See my settings below: