Dear all.
If you done grouping in excel the client creates a session cube with the following MDX.
CREATE
SESSION CUBE [<Cubename>_XL_GROUPING1]....
This session cube will be created physically on the disk. So the report is very complex it runs into the problem that for e.g. 8 sheets 8 shadow copies on the server disk are created and the SSAS database became forth time larger.
Our cube has a size of 170 Gybte. After a while the server is running out of resources, so how can we restrict or disable this behavior?
Before this issue I thought SSAS will read only from the DATA folder and writes
only
to disk during processing. But actually this is not the case.
Cheers,
Nils