AMO:How we can handle the transactions in AMO

HI All,

I am working with AMO and .Net i have few queries,

1) how to handle the transactions in AMO

2)if one user is processing the cube then how to prevent other user to access it.

Please let me know.

Your suggestions are valueable to me.

Thanks in advance.

vish.

AMO is inherently transactional. If an object is being processed changes that other users submit will not be committed until after the transaction has completed.

If you need to do a series of operations, like changing a cubes structure and then processing it, but you want either both or neither of these operations to suceed, then you can use explicit transactions. The server object has beginTransaction, commitTransaction and rollbackTransaction methods.

AMO:How we can handle the transactions in AMO

HI All,

I am working with AMO and .Net i have few queries,

1) how to handle the transactions in AMO

2)if one user is processing the cube then how to prevent other user to access it.

Please let me know.

Your suggestions are valueable to me.

Thanks in advance.

vish.

AMO is inherently transactional. If an object is being processed changes that other users submit will not be committed until after the transaction has completed.

If you need to do a series of operations, like changing a cubes structure and then processing it, but you want either both or neither of these operations to suceed, then you can use explicit transactions. The server object has beginTransaction, commitTransaction and rollbackTransaction methods.

AMO:How to do ProcessPartition by using AMO

Hi All,

i need a sample code how we can do process the partition by using AMO.

Please send the sample code.

Hi there,

You can take a look here for some sample code..

Chris.
|||

Hi,

Another sample code here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516918&SiteID=1

AMO:How to create a new role by using vb.net

Hi,

I want to know is it same to create a role in Analysis Server 2000.why because there we are creating a role in Database as well as in Cube.i want to know in AS 2005 also we need to create a role like the same.

If any one knows please help me on this.

Hi,

There is a thread about creating roles with AMO here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1795829&SiteID=1

In AS2005, you need to create one Role in the Database (where you will define the users) and then Permissions as needed: DatabasePermissions, DataSourcePermissions, DimensionPermissions, CubePermissions, MiningStructurePermissions and MiningModelPermissions.

Adrian Dumitrascu