Hello!
We have an ASO cube on PBCS, where we do have a large structure with some dynamic calculation on some dimensions. Due to that, depending on the SmartView query we run, we get invalid grid, due to the fact that the caches aren't enough to run that required query.
In order to overcome the issue, we are using Aggregate Views on that ASO cube.
I've ran the Enable query tracking job to activate the query tracking and gather query data, and after some time ran the Execute Aggregation Process in order to create the views based on query tracking, as according to the documentation.
I do have some doubts regarding this process:
- Do I need to run that process daily, or after running once, the views will be kept after system maintenance? I do see that there are some materialized views on the ASO cube using Calc Manager that are days old
- Are the views updated as new queries are executed? Or do I need to run the Optmize Aggregate Process job again?
- I have scheduled two jobs, one to collect query data, another to optmize the aggregate process, but the last one fails daily stating that “Query tracking information does not exist. If query tracking is not currently disabled, please disable and re-enable.” Why would that be?
Any advices are helpful
Thanks!