The problem is that the cube is not available for queries. But process structure has been made, a full process of the dimensions and of the measure groups.
This is what I did do:
I did Import the SSAS Project from my live server to my local machine (laptop). I did some changings in the project in the dimensions and measure groups and deployed the solution to the server. After this I did a process structure. I logged into Analysis Server, opened a mdx script and the cube was available. Then I did a FULL Process of all the dimensions to be sure that everything is allright with them. Then I did reprocess all my Measure Groups.
Now the cube is not available. This happend the second time now. I process the cube by using ascmd.exe executing xmla commands.
After I do a process structure again it works. I can see the cube and the measure data is available after processing the measure groups.
I cannot explain this behaviour. Can you?
Best regards,
Stefoon
What happens is that when you do a full process of a dimension. The structures of any related cubes become "unprocessed". Processing a measure group under the cube does not implicitly re-process the structure of the cube.
After you do a full process of a dimension you will need to reprocess the structure again.
|||Hi,
I think you are right. I did forget about the fact that the full process destroys the maps auf the dimensions for the cube construct.
Best regards,
Stefoon
No comments:
Post a Comment