SAP Lumira usage for Data representation layer with data caching option

Hi SAP team,

We are developing a data warehouse solution on top of the warehouse we need to build a Data representation tool which should be able to provide us the mechanism to create a report on the fly and generate dashboards

Currently we are planning to use SAP BO 4.0 but it does not provide a caching mechanism (unlike Qlikview which provides cahching)

Can you please help us understand if SAP lumira provides caching so that our queries for daily information will not hit DB once the data is extracted

Also for any adhoc reporting whenever needed like SAP BO we want to have a way by which the data will be fetched out of database server

Thanks,

Sonal Shinde