Working on SSAS Multidimensional.
I have a couple of dimensions, let’s 30. And I built 10 cubes. All the cubes are using a couple of dimensions.
I have a job that processes 9 cubes together automatically ( it runs every day) and another manual job that processes the cube 10 alone, we use it just from time time.
My problem is when I process cube 10 alone, I lose all the data on the other 9 cubes. Hopefully, this process happens at night so the business user cannot feel it, however, I still need a solution for this.
Is it because of the shared dimensions and we should process all the cubes at once together?
Please any advice?
