Skip to Content
Dec 11, 2018 at 06:10 PM

Design studio : Avoid Empty value day Period in Cascaded Dropdown box.

123 Views Last edit Dec 25, 2018 at 11:47 AM 4 rev


Working on- SAP BusinessObjects Design Studio Release 1.6 SP5 Patch 3 (Version: 16.5.4)

Dashboard on Top of single source Universe, But don't have Access.

I have three cascaded dropdown box. 1)Year, 2)Month, 3)No.of day.

Let's suppose Year=2018, Month=12, Day=11

So, The "No. of day" Dropdown box should show till 11th, It should not show the day of 12, 13, 14,........, 31.

B'coz Data is not available for the next no.of day

*** If in the year 2017, the 11th month, the data is available for only till the day 23rd then in the Dropdown box

No.of day Should Show Til 23rd, it should not show (24, 25, 26.....30) the rest no.of day.

*** Same as for month And Year Respectively.

***************** If Data is not available It (The Year, Month, Day ) Should not be Populated ************************

And Year, Month, Day Show The Latest update data (In which day data was updated) AS "Default".