Question regarding designing a Dashboard Prompt.

Question

Hi,

I want to design a dashboard prompt consisting of several column based prompts.

For example,

Year, Month, Day (Month limited to Year, Day is limited to Year and Month). Year is mandatory. Initialised to 2016 (current year).

Product Category, Product Sub-category and Product (limitation of values is as per above but with respect to Product dimension)

Top n for Sales Quantity. This is mandatory. Initialised to 10.

Top n for Sales Volume. This also is mandatory. Initialised to 10.

'n' can be any value between 1 and 100.

Now, I want to add a prompt based on Sales Person. This should be limited to All Prompts.

The issue now is since the 'n' is mandatory and initialised to 10, the LOV for Sales Person prompt is always empty. The reason is the top n prompts are based on column "0"."0" for Sales Quantity and "1"."1" for Sales Volume. The logical or physical SQL generated for the Sales Person prompt is something like 'select sales_person from subject_area where year = current_year and 0 = 10 and 1 = 10'.

If I delete the top n initialised values from the prompt (in which case Apply button gets disabled) then I can see an LOV for Sales Person prompt. When I select a few values, and enter values for the two top n prompts, then my selected values for the sales people disappear. This is true, as well, when I make the top-n prompts optional.

Is there any way to design the Sales Person prompt constrained to 'All Prompts' where I can select sales people when the top-n prompts are populated with values, ideally within the same dashboard prompt?

OBI EE version is 11.1.1.7.0.

Thanks in advance.

Regards,

Manoj.

Manoj Dixit · Answer

Hi Gianni,

I have resolved the issue now by replacing the two column based prompts by variable prompts. And now I can see the Sales Person LOV.

Regards,

Manoj.

Manoj Dixit · Answer

Hello Gianni,

It's a Client requirement as the number of rows is too high and the values are not user friendly to remember (actual dimension is different). It consists of some codes with descriptions concatenated. So the Client thinks that it will help the end users to select options from a limited number of choices.

The top n prompts were designed for there wasn't a suitable answer to the below.

Number presentation variable data type displaying decimal places on Prompt.

I shall recheck tomorrow whether or not the issue can be resolved.

Thanks for your reply.

Regards,

Manoj.

Gianni Ceresa · Answer

Why do you want to keep it constrained with "All Prompts" ?

Just select manually all the columns except for the 2 Top n giving you problems ....

Or change the Top n prompts to be variables problems and not column based (this is just the value of "n" and not the value of the column itself, so a variable prompt would be fine ...)