There is an olap cube. In Excel, I create a pivot table for which the source is a cube.
The group of measures from which I take a measure contains partitions.
I build the report in the context of three attributes.
In the profiler I see:
The reading of the data of the "Inventory2022Q1" section has begun.
Reading the data of the "Inventory2021Q1" section is completed.
Such messages are repeated many times.
That is, for one request, the cube reads the same information many times.
Maybe there is not enough memory for this request? there is a lot of memory on the server.
Can you tell me if there is a setting that will help?