I don't want my cube to sort my measures and dimensions alphabetically

My cube has multiple measures and dimensions, and I want them to show in the field list of my pivot table in a specific order. However, when I preview them in BI Development Studio Browser, it automatically sorts in alphabetical. I don't want Analysis Service to reorder my measures and dimensions. Is there a way to diable the sorting feature of SSAS?

I'm afraid it's not possible:(. Oledb specification explicitly states that measure schema rowset (same true for dimensions) are sorted by name.

http://msdn2.microsoft.com/es-es/library/ms126250.aspx

You can try (and I have not tries this approach myself) to name dimensions and measures so, the form a specific order and give captions that are what you want your user to see. The more I think about this approach the less I like it.

I can't dissable a dimension level

SQL Server 2005 april CTP
Hi, I have an snowflake dimension with 2 levels which I used in a cube. But I need to link it to the top level.
In AS 2000, the only thing I used to do is to disable the next level from the linked level. Now i'm trying to do this with no success.
How can I do that?
For example:
Dimension: Warehouse
Level 1: Warehouse
Level 2: Rack
I have linked my cube to the level Warehouse and I want to disable level Rack but AS raises this error: Errors in the metadata manager. The attribute for the 'Rack' source attribute, of the 'Rack' source cube level, is disabled.
I need to disable this level because it isn't linked to the cube.
Any ideas?
Thanks in advance.It was my error. I have mystake definning the key of the dimension. I fixed the key. Then in dimension usage you only have to define the correct granularity of the dimension and that's all.

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

sql

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

i cant create a model

I try to create relational database but i cant develop a model. after i create a database i will create an OLAP cube for my project.i dont want to complex model but i cant create a simple database. it may be marketing, CRM or another. i dont know what fields and tables i should create. i saw sample databases such as northwind and foodmart but i must create original database for my project. please help meeeeeeWhat has the teacher covered so far? Do you have the original assignment (a URL or scanned copy would help us a lot)?

By the way, beware of asking other folks to actually do your homework for you... Asking for help is fine, but it is risky to let them actually do the assignment for you! :rolleyes:

-PatP

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

Hw can the cube be modified after deployment?

Hi,

We used cube in our project.

And the project is released to production environment.

Now we need to modify the cube.

Can anyone have any idea what are the ways we can handle this?

Appreciate any suggestion.

Sachin!

If this is an SSAS2005 cube you will have a project in BI-Developer Studio? Open the project and make the changes and redeploy the script to the SSAS2005 server.

The other way is to reingeneer a deployed cube. BI-Dev Studio have a project for this as well: "Import Analysis Services 9 database". Once you have a new project you can start making changes.

HTH

Thomas Ivarsson

|||The third alternative is to connect online to the cube. In Visual Studio go to File -> Open -> Analysis Services Database, and you will end up making changes directly to the cube on the server without having to deploy the changes - just hitting Save will make the changes immediatelly.|||

But without a blueprint/copy of what you have done. You should always work with a project?

/Thomas Ivarsson

|||In online mode you still have a project - it's just online project - everything is on the server. It is ultimately up to the developer in which mode he wants to work. (BTW, in AS2000 the only available mode was online mode).|||

We have deployed product at many client locations.

Now we need to add few things to the cube

But it is not feasible to go and change manually at all locations and same time client may not want that.

We are looking after creating an update for the product.

Now the question is how to update cube? One option is delete existing cube and create again with new xmla script and process cube.

Can you please suggest any other way to do so?