Announcing the Analysis Services Stored Procedure Project

A few months ago, a few community-spririted Analysis Services guys (including me) got together to create some example Analysis Services stored procedures. I'm happy to announce that beta 1 of our project is now available to download here:
http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures
The idea was to create a set of useful extensions to MDX to help solve common problems and at the same time provide some example source code to help people writing their own stored procedures. Please take a look and tell us what you think!

Very Nice!

How about a function that takes care of divide-by-zero and returns NULL if the denominator is 0? Ie. ReturnDivide(division). That would clean up a lot of iif mdx.

|||

We discussed this exact problem, but Mosha explained that using a sproc in this way would do more harm than good. Basically, the problem is that there's no way of marking a sproc as being deterministic (ie will always return the same result for the same cell) and so that means that if you use a sproc in a calculated member then the value returned by that calculation will never be cached. As a result, it's probably better to use IIF instead so that subsequent requests for the result returned by a calculation for any given cell in the cube will be returned from the cache.

To answer your other question about IIF, if <mdxstatement> is a calculated measure whose result can be cached, then no, it will only be executed once and the second time it's evaluated the value will be returned from the cache. So it's good idea to create a calculated measure to hold the value of <mdxstatement> even if you don't intend to display the result to the user and set its Visible property to False.

HTH,

Chris

|||

Just so I understand:
You are saying that the following MDX script will make the server calculate [measures].[summation] once in the scope iif statement:

Create Member [Measures].[Summation] AS

Aggregate({[DimMember1], [DimMember2]});

Scope ([DimMemberX]);

this = iif([Measures].[Summation] = 0, NULL, [SomeSet] / [Mesures].[Summation];

End Scope;

Whereas this statement will make it calculate it twice:

Scope ([DimMemberX]);

this = iif(aggregate({[Dimmember1], [Dimmember2]}) = 0, NULL, [Someset] / aggregate([DimMember1], [DimMember2]));

End Scope;

|||

Yes, that's what I understand.

Chris

Anchoring textbox to a page.

Hi,

In our project I have a matrix report. In that I need to anchor a textbox to the right end of the page, so that the textbox will always be at the right end of the report/page.

I also need to place the textbox at the page header. (but I am also open to solution / workarounds which does not include page header!!)

Thanks in advance

Arun.

any ideas?|||

If you just place a new textbox to the right hand side of your matrix control this will always display at the right hand side of the information displayed, also that textbox can live in the page header.....

Unless you are after something more complex it should be that simple, please provide more info if this is not quite what you are looking for.

|||

thanks for the reply,that works..

but we need soemthing more!!

| textbox | <-- textbox alligned here.

--|

Matrix |

|

--|

we need the matix report and the textbox right aligned to the right margin of the page. ( the textbox's right edge and the matrix right edge edge should align).

thanks in advance...

Arun

|||within the properties page of the matrix control you have an option to grow content right to left or left to right, the default is left to right so change this and it may give you what you are looking for, Otherwise you would have to code the position based on screen width less size of control but this is another task all together, I would assume the property should fix you issues, then the textbox place will be pushed out by the matrix.|||

sorry Andy.. that too doesnt work.. it give a mirror image of the matix that is what we dont need!!..

any other ideas?

thanks

arun

|||

Hi

After much time trying to get this to happen unfortuantely there is no automated way to right align your matrix automatically, It is certianly something i would like to see MS put in as a feature as i would find it useful, The onyl thing you can do is to place the matrix as far right as possible within the designer.

Sorry I dont have a better solution for you here.

Andy

|||

thanks Andy. i would also like to see that in SSRS as a feature!!..

for now i will try to anchor the textbox using some expression..

mean while if anyone comeacross any other ideas please keep me posted!!

thanks

Arun

Anaylsis Server 2005 and wrong results in dimensions/cube

My cubes are somehow incorrect and I can't find out why:

I created a very simple table, because of wrong results in my project cubes and inserted 102 rows:

-

USE EA_DWH
GO

CREATE TABLE [dbo].[TEST_DWH]
(
[DWSTOREDATE_INT] INT NOT NULL,
[USER_NAME] VARCHAR(20) NULL
)
GO

INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021216','USER_99')
INSERT INTO TEST_DWH VALUES('20021217','USER_03')
INSERT INTO TEST_DWH VALUES('20021218','USER_04')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021219','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_01')
INSERT INTO TEST_DWH VALUES('20021220','USER_03')
INSERT INTO TEST_DWH VALUES('20021220','USER_02')
INSERT INTO TEST_DWH VALUES('20021220','USER_02')
INSERT INTO TEST_DWH VALUES('20021220','USER_02')
INSERT INTO TEST_DWH VALUES('20021220','USER_03')
INSERT INTO TEST_DWH VALUES('20021220','USER_02')
INSERT INTO TEST_DWH VALUES('20021220','USER_02')
INSERT INTO TEST_DWH VALUES('20021220','USER_03')
GO

-

The first value of this table represents the date value as integer and the second value is the user name.

Now when building a cube (I) you will find out that the values differ to a simple group by on the sql database (II):

I count all user and the dimension is build on DWSTOREDATE_INT (logical key) as key attribute and USER_Name as regular attribute.

(I):

-

TEST DWH Count TEST DWH USER NAME Ergebnis 20021216 USER_99 22 20021216 Ergebnis 22 20021217 USER_03 1 20021217 Ergebnis 1 20021218 USER_04 1 20021218 Ergebnis 1 20021219 USER_01 62 20021219 Ergebnis 62 20021220 USER_01 16 20021220 Ergebnis 16 Gesamtergebnis 102

-

(II):

-

SQL query (SQL Server):

SELECT DWSTOREDATE_INT, USER_NAME, COUNT(*) AS Count_StoreDate_User
FROM TEST_DWH
GROUP BY DWSTOREDATE_INT, USER_NAME
ORDER BY DWSTOREDATE_INT

RESULT:

DWSTOREDATE_INT USER_NAME Count_StoreDate_User
-- --
20021216 USER_99 22
20021217 USER_03 1
20021218 USER_04 1
20021219 USER_01 62
20021220 USER_01 8
20021220 USER_02 5
20021220 USER_03 3

(7 row(s) affected)

-

I tried this example on three different computers and can't find out why this happens. On Analysis Server 2000 it works correctly.

My computer:

W2K3 (SP1), SQL Server 2005 EE (SP1 CTP)

I had the same results without SP1 CTP and installed it because I thought this issue may be corrected.

Please help me solve this problem.

Best regards

You are correct. This is one of the cases where AS2005 is different from AS2000.
In your example you have a case of dimension that is based on the non-unique key attribute.
In AS 2000 Analysis Server automatically makes a dimension key unique by concatenating all levels to the key level ( lowest level in the dimension). In AS 2005 this is no longer the case. Although in simple cases (like you have here) you might be little confused at first, the real gain comes in AS2005 being able to implement better performing and scalable dimensions.
To fix the problem in your dimension, you need to define your composite key for your dimension key attribute. Add USER_NAME column to the KeyColumn of your dimension key attribute.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Analysis Services Step by Step - connection problem

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Error 1 The project could not be deployed to the 'localhost' 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.

I downloaded the trial version from MS and installed in om my laptop from where im running my tutorial - what could be wrong? (Im a newbie to SQL so I have no clue)

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward Melomed wrote:

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

I have the following services running:

SQL Server, SQL Server Agent, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services and SQL Server VSS Writer - I can't see any Analysis related services on my services list?

|||

It is working now - thanks alot for your help.

I reinstalled my solution and for some reason I didnt have the Analasis services correctly installed.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my 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.

I am totally new in this area..

Please solve it.. Thanks.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services error

I was able to build SQL 2005 cubes from my project. However, for some reasons, it doesn't work any more, and I have the error below. Anyone can shed some light would be greatly appreciated.

Error 1 File system error: The logical file cannot be found inside the physical file. Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.6.dim\14.ERP Effective Month.Tbl Policy Coverage Data.dstore. Logical file: . Errors in the metadata manager. An error occurred when loading the Coverage dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.16.dim.xml'. Errors in the metadata manager. An error occurred when loading the Production cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Beacon DW.350.cub.xml'. 0 0

Hi,

It sounds like the file is corrupted. It looks like its only the Coverage dimension, so you may be lucky.

Can the project be built or is the error when you try to deploy the project to the server?

If the error is in the deployment try to deploy to a new database to see if the corruption is on the server itself.

If the error is on the build which tells me something is corrupted in the project files itself do the following.

1. Go to a back up of the project if you have one.

2. If not make a backup of the project now and delete the Coverage dimension from the project to see if you can build it without that dimension.

I hope that helps,

David Botzenhart

|||

It appears that it is one of the xml files for the Coverage dimension was corrupted on the SQL server. I have deleted the Coverage dimension on my project, and it failed with the same error when I rebuilt the cube. Do you know of how to fix the corrupted file on the SQL server?

Mitch Cheung