Dimension Security

A dimension is a collection of business attributes or a hierarchy structure that you use to group or aggregate numeric measures. All Oracle Transactional Business Intelligence dimensions are unsecured, except for the Assignment Manager dimension.

Therefore, when you select a single dimension, such as the worker or department dimension, you can see all worker and department data unfiltered. Oracle Transactional Business Intelligence data security isn't applied until you select more than one dimension or one dimension plus one or more metrics.

For example, if you select Department Name from the Workforce Management - Worker Assignment Real Time subject area, then you can view all departments. When you add Assignment Count to the report, data security is applied and you can view workers only in the departments that you can access.

Assignment Manager

Assignment Manager is a hierarchical structure representing the reporting relationship between workers and managers. This dimension is the only secured HCM dimension in Oracle Transactional Business Intelligence. The Assignment Manager hierarchy is restricted to line managers. If the signed-in user doesn't have direct reports, then he or she sees no data when you include Assignment Manager in the report.

Reserve the use of Assignment Manager for line managers only. Some other job roles, such as human resource analyst, may need access to manager information. In these cases, use the Manager Name in the Worker dimension instead of the Assignment Manager hierarchy.