VIRTUS no more used in BI4 since 01/2021
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
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
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
The authorization control is come from BWise system. Is was define in Derived Tables:
