Why is the user security set for custom reports not working?

• Related Articles

• The user security set for custom reports (BCM) donot work. Why?

  The User_ID parameter should be used in the custom report and report query should join with the ADMIN_USER_STORE table.

• ARC admin data security is automatically set for a user. Is it a functionality of ARC?

  The data security will not get set for any user automatically unless some one specifically assigns it. Also, if the tables related to security are fiddled manually then the security might get assigned. There are 4 tables related to security that ...

• Unable to assign data security for a User. The security is set at Role level. How can it be corrected?

  If the security is assigned at Role level, then check if the equivalent security tables for Role is available in the Warehouse. If there are no tables created or wrong tables being created, then create required tables (e.g.: ADMIN_ROLE_STORE and ...

• Why cannot I select items in Custom Reports?

  This problem can occur if there are extra trailing white space characters in the 'Desc' field of a DIM table, the description field in filter pop up shows multiple records for the same sub category as these descriptions are showing after ...

• The BCM reports, though defined correctly, are not working. Why?

  The parametres 'Start Date Key' and 'End Date Key' are mandatory for BCM reports. Ensure that they are defined properly.