How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?

[msinha8]

Hello ,

I have a requirement to configure two dashboard parameters: “No of Days” and “Total Days”.

• By default, these parameters should take values 1 and 10 respectively.

• At the same time, users should be able to select any value between -100 and 100 from a dropdown.

To implement this, I created a session variable with the following SQL:

SELECT LEVEL - 101 AS days FROM dual CONNECT BY LEVEL <= 201

I then used this session variable as the source for the dashboard presentation variable. However, instead of showing a dropdown, it displays the values as a list.

Could someone please advise on:

1. How to set default values for these presentation variables (NoOfDays = 1, TotalDays = 10)?

2. How to configure the dashboard parameters so users can select from a dynamic or static list ranging from -100 to 100, displayed as a dropdown rather than a list?

Is there a recommended way in Incorta to:

1. Set default values for presentation variables (NoOfDays = 1, TotalDays = 10)

2. Still allow user selection from a dynamic or static list ranging from -100 to 100?

Any guidance on how to achieve would be greatly appreciated!

Thanks in advance

[anurag]

Can we meet to review this?

Please log a support ticket and request support for a meeting. Or email me to setup this meeting.

[mritunjay_sinha]

Hi Anurag,

Thanks for the update and as per your suggestion, Request #57793 is created.

Regards,