Hi , Please help me on the below sp
as at the time of execution i am getting some error message like below "
It depends what you mean by "Update Cube". If you mean updating cells values in the Write Back enabled cells and dimensions, then yoou have to first enable the WriteBack on the cells and/or dimensions.
Then you can use UPDATE CUBE statement (MDX). This could be probably possible to send from the OPENQUERY but didnt' tested it as currently don't have a cube with write back available.
If you mean re-process, then you hvae to send XMLA commands to the SSAS to instruct it to process (full process, process update,.....) particular cube in particular datase.
It could be possible to achieve this in stored proc using OLE, but much better would be to write a CLR Stored procedure and process the cube using AMO or ADOMD.NET.
Other option is to use eg. PowerShell to send XAML command for processing.
answered Sep 26 '12 at 06:11 AM