cancel
Showing results for 
Search instead for 
Did you mean: 

Date values not visible in Prompt screen

Former Member
0 Kudos

Hello,

I am trying to create a new BO design studio 1.2 application. I am using a bex query to get the data. it has a selection on date filed " Acceptance date" which is mandatory selection-option in the bex query.

When I execute the application the Prompt comes up with all the selection fileds as in the bex query i.e. Compaycode, sold_to etc. along with acceptance date. but when I try to select a value (use F4 help) for the "Acceptance date" I don't see any date value in F4 help that I can select, as I see for the others i.e.Compaycode, sold_to etc.

Is there a way we can get a date so that end-user can select it when he execute this report.

Also can we restrict the size of the slection screen / Prompt widow?

Thank you in advance.

regards,

Mahesh

Accepted Solutions (0)

Answers (3)

Answers (3)

TammyPowlas
Active Contributor
0 Kudos

Your infoobject settings look similar to mine; could you also share your variable settings from the BEx query?  I only see the characteristic settings and not the variable settings itself.

Thanks

Former Member
0 Kudos

Hello Tammy,

Here is the variable setting.

regards,

mahesh

TammyPowlas
Active Contributor
0 Kudos

The only difference between yours and mine is I have single value while you have selection in the basic properties details

I see my dates in the prompts

Former Member
0 Kudos

hi,

I am getting the same issue for Sold-to party (it displays no values that I can select from), but surprisingly I don't see that issue for Sale-org.

regards,

Mahesh

TammyPowlas
Active Contributor
0 Kudos

If it is working for one and not the other, then I would compare the BEx variable settings with the one that works compared to the one that doesn't

Former Member
0 Kudos

hi,

I think I got the issue, it only works when there isn't much of data for that filed in the infoprovider. Hence it gives me a message "Use the search bar to limit the result set". when I put a search string value it gives me the results matching it.

But now my concern it that the search team is Case sensitive and its case sensitive only for the fields where we don't see any data in the F4 help of the selection screen.

For fields where we see all the values in my case saleorg  it isn't case sensitive.

Regards,

Mahesh

TammyPowlas
Active Contributor
0 Kudos

Yes, it follows BEx rules in terms of being case sensitive

former_member183473
Participant
0 Kudos

I don't think you will have that option.

The best way to get something close to it, remove that from the query, and on your application mark the datasorce to load on script, and the first thing you do is open a popup where the user selects the range of data, and any other filter you might find interesting.

You can use the date filed for that, than apply those filters to your datasource, and when the user closes the popup you can load the data source.

Hope this helps.

TammyPowlas
Active Contributor
0 Kudos

What are the InfoObject settings on the Acceptance Date on the Business Explorer tab inside BW?

What are the BEx Query settings for the date field?

I have a date field mandatory prompt which shows the list of values to select from.

Last week at BI 2014 we learned there is not much we can do with the Prompt window; it is not a best practice (per last week's sessions) to have a prompt window.  Best practice is to have defaults in the BEx query and then have dropdowns to let the user interact with the dashboard.

Tammy

Former Member
0 Kudos

Hello  Tammy,

Thank you for your response. here are the settings for the date filed in BI and Bex.

regards,

Mahesh