Are you using the logical SQL to build the Analysis? If yes then it is possible to use the outer join

Hi Stephanie We just have the following variables available to default the date in parameters {$SYSDATE()$} - current date, the system date of the server on which BI Publisher is running. {$FIRST_DAY_OF_MONTH()$} - first day of the current month {$LAST_DAY_OF_MONTH()$} - last day of the current month {$FIRST_DAY_OF_YEAR)$}…

Pretty much similar to that of making a parameter nonmandatory using the NVL function. Use NVL in your list of value query and you should be good to go

Hi koti, ESS names are not stored in any of the table. You will havr to go ahead with the column which uses the location/address where the report is stored.