Hi experts,
I have a SSAS tabular cube with an estimated size of 16345 MB.
Its set to have a full processing through sql agent job.
This cube has four fact tables and each fact table has been set to get processed individually ,one after the other, through job steps.
The issue is that it has been failing with memory allocation error at step4 (processing 'factsalesprice' table) resulting in the server fail over.
Can somebody explain it to me how to troubleshoot this issue? what are the steps to be taken to come up with a solution?
1)Does creating partitions on this table and only processing the ones needed would help? is there a way I can first estimate the memory allocated to this table for processing and then partition based on the memory size?
2)I am a developer and was told to redesign the cube if needed. so not sure where to start or how to approach the issue !
few things
1)Database engine and the SSAS services are on the same server (No option to separate them)
2)Increasing the RAM size etc (Again not an option)
3)Its a enterprise edition
please can someone help me?
Thanks