Hi, all experts,
Is there any way for us to process the updated cube partly ? In my case I only want to add KPIs to my cube which are related to a few measure groups. In this case, it seems like we have to process the whole partitions related to these measure groups which the new added KPIs are related to. But as to large cube with miliions of records, this could take a reasonable time. Therefore, I am wondering if there is any way that we are able to update and process only the new added properties such as these new added KPIs to the cube instead of having to process the large chunk of the cube data? I personally think it will be really great to have this feature.
Is there any way to achieve this in SQL Server 2005 Analysis Services? I am looking forward to hearing from you shortly and thanks a lot for your advices.
With best regards,
Yours sincerely,
Hi,
I think you just need to deploy your project.
Regards
|||Hi,
Thanks. But as what I have always seen in my BIDS , whenever I deploy a project, the system process it first and then deploy it.
I am not quite sure what you really mean by deploy here if that is not the 'deploy' I understand.
Regards,
|||Lucas is right, you just need to deploy without processing.
There is an option under the deployment settings of the project that sets whether the project is processed after it is deployed. I think the default setting is "Always Process", but you can change this to "Never" and the project will be deployed without initiating a processing operation.
For changes to things like the calc script and KPI's, you do not need to reprocess your data, deploying your changes is enough.
No comments:
Post a Comment