VIRTUS no more used in BI4 since 01/2021
Contacts
BWise application owner : Hiroaki TAKAHASHI (IT) → hiroaki.takahashi@solvay.com
Deputy Head of internal Audit : Patrice CHELIM
Virtus application administrator : Jocelyn MATHIEU → jocelyn.mathieu@solvay.com
Overview
BWise offers the Governance, Risk and Compliance (GRC) platform of software and services, to help companies worldwide track, measure and manage key organizational risks, including the risk of non-compliance
All the doc are in Google Site : https://sites.google.com/a/solvay.com/virtus/manuals
DWH Generator(Data Loading)
new server (2020) : Production DB = WDCSLVBP31\SLV1_DBPRD
In BWise Application server : D:\BWise\WebServer\DataWarehouse\BWise2DatawareHouse.exe
The NT task
Full Dump will be run dairy at 2:00AM FR time, it will refresh all the Data Ware House data.
After FullDump all the customized SQL script will be run in below folder
D:\BWise\WebServer\DataWarehouse\SqlAfterFullDump
Increment Dump will be run each 2 hour, to append the Increment data into DWH
After FullDump all the customized SQL script will be run in below folder
D:\BWise\WebServer\DataWarehouse\SqlAfterIncrDump
For detail please read the doc "BWise - BO - Data Warehouse Generator Documentation BWise 4.1 SP6.pdf" I Google site
Data Model
Authorization Control
The authorization control is come from BWise system. Is was define in Derived Tables:
Main BI4 Core Reports
