Monday, 11 August 2014

OBIEE BISystemUser !!

About BISystemUser:


  •  BISystemUser is an internal administrator user created during installation in the Weblogic LDAP store for trusted communication between components. The password is created at random.
  •  It owns the Oracle BI Server system processes and is not exposed in any user interface.
  •  BISystemUser is used for service-to-service authentication.
  • This is not an ordinary user account but rather a set of credentials used to authenticate services within the system to each other.
  • The credentials of this account are stored in the Credential Store under the system.user key.
  • This role is required by Oracle Business Intelligence system components for inter-component communication.
  •  The BISystem Role must exist (with the BIAdministrator role), for Oracle Business Intelligence to function correctly.
  •  This user name is entered by the person performing the installation, it can be any desired name, and does not need to be named Administrator.
  •   The password entered during installation can be changed later using the administration interface for the identity store provider.
  •   An administrative user is a member of the BIAdministrators group and has all rights granted to the Oracle Business Intelligence Administrator user in earlier releases, except impersonation. The administrator user cannot impersonate other users.
  • The single administrative user is shared by Oracle Business Intelligence and Oracle WebLogic Server. This user is automatically made a member of the Oracle WebLogic Server default Administrators group after installation. This enables this user to perform all Oracle WebLogic Server administration tasks, including the ability to manage Oracle WebLogic Server embedded directory server.
  • This is a highly privileged user whose credentials should be protected from non-administrative users.
  •  Using a separate user for secure inter-component communication enables you to change the password for the system administrator account without affecting communication between components.
  • The name of this user can be changed or a different user can be created for inter-component communication.
  •   Role Name: BISystem
  •  Members : BISystemUser.
  • Role Permissions: 

               oracle.bi.scheduler.manageJobs
               oracle.bi.server.manageRepositories
               oracle.bi.server.impersonateUser
               oracle.bi.server.queryUserPopulation

  • Default Credentials:

                map: oracle.bi.system
                key: system.user

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...