MDX 'Update Cube' statement not committing... 1

[atus28]

Hi,

I have a problem, i hope someone can help me.

So, i have an Update Cube MDX statement, such as:

UPDATE CUBE [Finance]
SET (
[Time_m].[Year].&[2004].&[Q1-04].&[1],
[Line Item].[11111H Vagyon értéku jogok bruttó O-ra leirt értéke],
[Organisation].&[<N/A>], [Scenario].[Scenario].&[Actual], [Measures].[SHV Adjustment]) = 6000
USE_EQUAL_ALLOCATION

But if i run it, it won't commit, and the new data won't appear in the database.

What should i do?

Many thanks in advance,
Atus

 

[johnherman]

Have you granted UPDATE capability to the user/login running the update process?


-------------------------
John Herman is available for short and long term data warehousing consulting and contracts.

 

[atus28]

Unfortunately, yes...Don't you have any other idea?

Thanks,
Atus

 

[johnherman]

Can the user/login attempting the UPDATE browse the cube?
Have you tried running the UPDATE statement as SA? dbo?

Just a few ideas to try to narrow the scope of the problem.

-------------------------
John Herman is available for short and long term data warehousing consulting and contracts.

 

[atus28]

No, i'm sure it is not about user rights.

Maybe i should define a tarnsaction, and after executing the update command, commit the tarnsaction...

Does anybody know how to do it in MDX??

thanks,
Atus