Are you trying to do it in T-SQL, or MDX/DAX/DMX?

Sorry to hijack, but some poor old chap is struggling:

http://www.sqlservercentral.com/Forums/Topic1272592-2799-1.aspx#bm1272921

😉

no, physical. OS installs as 64it, tried 32 and 64bit sql installers, same issue.

1. Are you installing the SQL Cluster as a domain user with sufficient access to the AD OU where the objects need to be created.

2. Does the setup account have...

That could be due to a lot of things.

Maybe post the error?

You'll need to look at the syntax when working with dashes in text:

select * from [Site1-DV-SS-01].[Database].[Schema].[Table]

Try this.

The same reason why any Application Developer should...

is your package using any network data sources that require authentication?

1. There is no way i can check if calling application is recieving the output from my sql server side. And the code is really working or not. There is...

The account you are installing with, must have modify rights to the container/OU where the new virtual objects will be created.

Its as easy as pie...

here are a few setup references...

http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?ID=337

http://technet.microsoft.com/en-us/sharepoint/ee692578

http://blogs.devhorizon.com/reza/2010/05/03/bi-center-and-data-connection-errors-when-using-performancepoint-dashboard-designer/

http://technet.microsoft.com/en-us/library/ee748644.aspx

In essence, you will need the following:

1. SSAS Cube

2. Sharepoint with performance point service

3. Unattended service account

4. Secure Store Proxy...

Microsoft SQL Server Integration Services (SSIS) 😉

Be careful or your setup might do the opposite of what you require.

SQL Server & Windows will create the resource groups based on what you provide in the setup.

Run Cluster...

How many results are returned by this statement?

SELECT count(*) FROM dbo.tblDependents as a inner join dbo.tblHOF as b on a.FamilyID = b.FamilyID group by a.FamilyID

your group by clause could return...

It depends. On the CPU allocation you will need...