Setup Planning
This page contains information about preparations that need to be done prior to installing b+s Reporting Interface and CCBI.
Be aware that the Reporting Interface gets installed with the corresponding DB schema of the connected CCE system while doing the setup. If the CCE version has been upgraded in the meantime you need to re-setup the reporting interface to get the newest CCE version in place.
Setup Types
The same software and installation instructions can be used to setup new systems or to upgrade previous versions of the reporting interface and CCBI.
Upgrades differ if the database needs to be moved onto another database server. Based on these options we differentiate between 3 types of setup within the workflow:
- New System
- Common Ground Upgrade (remaining on the same server)
- Technology Refresh Upgrade (moving to new server infrastructure)
Components to install
The Reporting Interface needs to be installed on all servers that are used as a primary or secondary (fallback) datasource of CUIC. The PBI database and the gateway are only needed on one side, if no cold standby setup is required.
Preparations
Check System Requirements
Make sure that all requirements of the dedicated database server for the Reporting Interface are fulfilled.
Specification of Configuration
The following tasks (refer to the corresponding chapters in the Design chapter) need to be specified and implemented before data is loaded into the data mart:
- Historical depth of the data load (depends on availability)
- Retain time for historical data
- Max. 20 Not Ready Reason Code Categories including the code-mapping to be shown in historical displays
Required User Accounts
SQL Login for Setup
An SQL login with the role "sysadmin" is required to run the installation on the database server.
SQL User on DAWs
There must be an SQL login in place on all DAWs where the Reporting Interfaces will connect to. This user (normally named as "bsreporting") needs datareader permissions on AWDB and HDS.
Maintenance window
For the setup of CCBI there is no need for a maintenance window. If you need to upgrade an existing b+s Reporting Interface, follow the corresponding recommendations.