The previous section describes how to cache data. This section describes approaches to use the caching in smarter ways.

Although it is useful to use a single dataset for both ETL and reporting purposes, it is often advisable to split those two tasks into two separate datasets.

In this scenario, you create one ETL dataset which loads the data from a source and saves the data in an SQL database. This is achieved using the Specify Datamart and DataMart table name fields on the cache tab.

See caching a dataset in the datamart

A second dataset is created on top of the data in this datamarted table for dashboards and reports.

This way you can prevent the source data being accessed except during a caching window you specify.

Revision: 5
Last modified: Oct 03, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment