Sql query in dashboard prompt for bi publisher parameter
I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard.
For this, I have created a report and parameter that restricts the details of his eligible plan by using the below condition.
" papf.person_id = HRC_SESSION_UTIL.GET_USER_PERSONID".
BIP Report is working fine, it is restricting report data as well as parameter data. To show this report in the dashboard I have created a Dashboard prompt by using the presentation variable. Please see the below screenshot for the same. But it does not restrict the data as per the employee.