|
Hi , Please help me on the below sp as at the time of execution i am getting some error message like below " "
(comments are locked)
|
|
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.
(comments are locked)
|


have u considered updating the tables and processing the cube.
nope,i haven't tried like your suggestion as it was asked to update the cube only and the cube will not be processed.
Can you describe, what you want to achieve? The title tells update cube but in the stored proc it seems like you try to update data in table using data from cube.
I just want to update the cube using stored procedure.
Dear Pavel,I am trying to update my cells value of my cube which is Write Back enabled and at the same time i am using OPENQUERY statement to execute this update but as you are aware that OPENQUERY alway takes a select statement so here what is the way out to update my cube's cells.
At the same time i am able to update my cube's cells with ADOMD.NET'S COMMANDTYPE.COMMANDTEXT(IF I DON'T USE STORED PROC) but i am not able to run the same update statement using STORED PROCEDURE.