We are planning to create a set of four reports that will be on the dashboard for every user. When each user clicks the report, it will generate on the fly and content of the report and navigability will be created as per the access level of the user.
I understand that the report sections can be tied to security by using $USER_NAME in a join on a security table to display only data the user can see, but is that the only way?
Also, how about navigability (javascript) on the report. Can a drill down link be inactivated for a department level user and activated for a higher level user?
I understand that the report sections can be tied to security by using $USER_NAME in a join on a security table to display only data the user can see, but is that the only way?
Also, how about navigability (javascript) on the report. Can a drill down link be inactivated for a department level user and activated for a higher level user?