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

AMO with VB.Net

Hi All,

I am working on a project that require me to build cubes programmatically i.e., using AMO object and VB.Net. I am trying to find a sample that builds cubes using VB.Net.

I can add further features to it based on the sample.

Can any one help me at their earliest?

Thanks

Sekhar PC

Check the following two links:

http://www.asptoday.com/Content.aspx?id=2351

and

http://sorosjing.cnblogs.com/archive/2005/12/08/292848.html

Have fun.

Yones

|||

Hi,

Thank you for your reply.

When I tried to create a cube by exactly following the sample, always it threw an error "Could not deploy the cube".

Is there a better sample that help to create cube using AMO and dotnet? A sample that get deployed though the source is AdventureWorks only.

Thanks

SekharPC

|||

Thanks for the reply.

When I tried to implement the steps given in the above listed website, everytime I got an error message saying "Could not create cubes". Then I copied and pasted and tried to create cubes using AdventureWorks database. Still the error continued.

Can a better sample be found which I can use to create my cubes dynamically?

An early reply will be of great help to me.

Thanks

SekharPC

|||

There is great C# sample in http://msdn2.microsoft.com/en-us/library/ms345091.aspx

it was very useful for me.

Mohsen

AMO with VB.Net

Hi All,

I am working on a project that require me to build cubes programmatically i.e., using AMO object and VB.Net. I am trying to find a sample that builds cubes using VB.Net.

I can add further features to it based on the sample.

Can any one help me at their earliest?

Thanks

Sekhar PC

Check the following two links:

http://www.asptoday.com/Content.aspx?id=2351

and

http://sorosjing.cnblogs.com/archive/2005/12/08/292848.html

Have fun.

Yones

|||

Hi,

Thank you for your reply.

When I tried to create a cube by exactly following the sample, always it threw an error "Could not deploy the cube".

Is there a better sample that help to create cube using AMO and dotnet? A sample that get deployed though the source is AdventureWorks only.

Thanks

SekharPC

|||

Thanks for the reply.

When I tried to implement the steps given in the above listed website, everytime I got an error message saying "Could not create cubes". Then I copied and pasted and tried to create cubes using AdventureWorks database. Still the error continued.

Can a better sample be found which I can use to create my cubes dynamically?

An early reply will be of great help to me.

Thanks

SekharPC

|||

There is great C# sample in http://msdn2.microsoft.com/en-us/library/ms345091.aspx

it was very useful for me.

Mohsen

AMO with VB.Net

Hi All,

I am working on a project that require me to build cubes programmatically i.e., using AMO object and VB.Net. I am trying to find a sample that builds cubes using VB.Net.

I can add further features to it based on the sample.

Can any one help me at their earliest?

Thanks

Sekhar PC

Check the following two links:

http://www.asptoday.com/Content.aspx?id=2351

and

http://sorosjing.cnblogs.com/archive/2005/12/08/292848.html

Have fun.

Yones

|||

Hi,

Thank you for your reply.

When I tried to create a cube by exactly following the sample, always it threw an error "Could not deploy the cube".

Is there a better sample that help to create cube using AMO and dotnet? A sample that get deployed though the source is AdventureWorks only.

Thanks

SekharPC

|||

Thanks for the reply.

When I tried to implement the steps given in the above listed website, everytime I got an error message saying "Could not create cubes". Then I copied and pasted and tried to create cubes using AdventureWorks database. Still the error continued.

Can a better sample be found which I can use to create my cubes dynamically?

An early reply will be of great help to me.

Thanks

SekharPC

|||

There is great C# sample in http://msdn2.microsoft.com/en-us/library/ms345091.aspx

it was very useful for me.

Mohsen

AMO with VB.Net

Hi All,

I am working on a project that require me to build cubes programmatically i.e., using AMO object and VB.Net. I am trying to find a sample that builds cubes using VB.Net.

I can add further features to it based on the sample.

Can any one help me at their earliest?

Thanks

Sekhar PC

Check the following two links:

http://www.asptoday.com/Content.aspx?id=2351

and

http://sorosjing.cnblogs.com/archive/2005/12/08/292848.html

Have fun.

Yones

|||

Hi,

Thank you for your reply.

When I tried to create a cube by exactly following the sample, always it threw an error "Could not deploy the cube".

Is there a better sample that help to create cube using AMO and dotnet? A sample that get deployed though the source is AdventureWorks only.

Thanks

SekharPC

|||

Thanks for the reply.

When I tried to implement the steps given in the above listed website, everytime I got an error message saying "Could not create cubes". Then I copied and pasted and tried to create cubes using AdventureWorks database. Still the error continued.

Can a better sample be found which I can use to create my cubes dynamically?

An early reply will be of great help to me.

Thanks

SekharPC

|||

There is great C# sample in http://msdn2.microsoft.com/en-us/library/ms345091.aspx

it was very useful for me.

Mohsen