Does the OLAP engine provide real-time information?
Yes. An OLAP model can be configured to use any relational database – however, we recommend that you don’t use it for analysis directly against transactional databases because it can cause the performance of the transaction system to be degraded. It is optimal to build an OLAP model against a data mart.