ROLAP Cube

Comeback of role up Cube
Rolap cubes would be a great way to have real time data in your DWH with the advantage that you can have audit trails (timestamp and username can be automatically written into a table), but: Performances for bulk data entry are not acceptable They cannot be used in dataflows reliably These two issues cause the ROLAP cubes…
How to trigger SQL server actions
1. Abstract This article discusses the possibilities of using ROLAP cubes to write flags into an SQL server, thus triggering actions on the database side, and how to process this flag. 2. Context Usually, data pre-calculations are loaded into Board from a SQL server, but there are times when we need to initiate actions on…

Discussion List