Hi everybody
I want create database connect analytics services in SQL 2008.
Step 1: I have database Analytisc services in SQL server 2008 R2.
Step 2: I create new datasource in Frameword Manager. I select type Microsoft Analytisc services 2008.
Server name: localhost
Database name: SSAS_TestFootmart.
But When I testing connection Failed. Why ???
Thanks all !
Hard to tell without details of the error message or knowing your Cognos version, but before you can make a connection you must have the SQL Server Analysis Services client installed on the Cognos Server and also on the computer where Framework Manger is installed.
If you have the client installed everywhere, verify the credentials used to make the connection.