Maybe you should have a look here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en

and download and install the following:

- Microsoft Core XML Services (MSXML) 6.0

- Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Eric

The plug-in is not required to access AS 2005 from excel...

It's just another way to access your data.

I use the excel add-in to connect to my AS 2005 cube.

http://www.microsoft.com/downloads/details.aspx?FamilyID=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

Maybe you are missing MSMXL V6

HTH,

Eric

As far as front-end goes, I did have a look at a few tools that claim to be compliant to AS2005 but only two of them deliver a true BI...

Just for your information, The current version of PowerPlay is not compliant to AS2005 database. Actually, the entire Cognos product line is not compatible with SQL Server 2005 components.  

I dont know the exact...

If you want to deploy the Adventure work sample, just open the solution C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Enterprise\Adventure Works.sln

and deploy

Hi,

The data inside a dataset will always be coming from one and only one database if your dataset type is direct query (unless you have created views in your database...

Hi,

I did not try the following but this could work:

INSERT INTO TableName (TransactionId,CountryCode,DescriptionText)

SELECT a.TransactionId,b.CountryCode,a.DescriptionText

FROM Transaction a

CROSS JOIN CountryCode b

HTH,

Eric

Hi,

We are currently looking into AS2005 UI Tools.

So far we have selected to review the following toolsroclarity,Panorama,DataJungle and BI Portal.

I think Proclarity and Panorama...

Hi,

This might be of help for you:

http://www.theserverside.net/articles/showarticle.tss?id=HeirarchicalQueries