on 10-26-2015 11:12 AM
Hi,
we are having issues with optimizing (Full- as well as Lite-Optimize) an environment.
The error raised is that the OLAP Cube could not be found.
Checking the Analysis Services, one can see that there are no analysis services Cubes present any more. Maybe due to a manual but unintended deletion.
I wonder if there is a way to recreate these missing cubes?
Thanks for all your ideas,
Best regards
Marco
Hi Marco,
when OLAP get damaged for some reason SQL server, if data are still present in the fact tables, is able to recreate it .
To do it, if present, rename the damaged file, after that modify model with process model, this step will recreate the OLAP from scratch.
I see you never close the threads please remember that closing the threads in the right manner will help other users to find quickly a solution and diminuish the garbage in the forums, see please How to close a discussion and why
Regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Roberto,
thank you for your reply.
What exactly do you mean by "rename the damaged file"? Are you talking about renaming the analyis services cube? This cube is not present at all any more. However trying to process the model in BPC Administration did not recreate the cube.
Finally I created a backup through the server manager, deleted the old environment and restored the backup afterwards. This way the environment has been recreated including the analysis services cube. Therefore the issue is solved
Thanks again an best regards
Marco
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.