OLAP Access in Crystal XI Evaluation Version

[Flopper]

Greetings,

I'm attempting a 'Proof of Concept' using Crystal Reports against an SQL Analysis Services Cube. I'm attempting to persuade my current employers to use Crystal within their BO environment and therefore i have only an evaluation copy of Crystal XI.

I've been trying to connect to a variety of cubes all morning, but without any success. I've tried to connect to Analysis Services and the local Sales Reports.cub file.

After selecting Add in the OLAP Connection Browser I enter the correct details, using the appropriate Microsoft OLE DB Providers... for either Analysis Services 9.0 or OLAP Services 8.0. The Test Connection button confirms the connection is ok... but the OK button is highligthed out therefore preventing me from creating the Datasource.

Is this due to the Evaluation version?

Many thanks

 

[Flopper]

Just a quick update...

I actually managed to find a 'sort of' related article on the BO website...

http://technicalsupport.businessobj...sliceId=&dialogID=1174015&stateId=1 0 1172631

This details the issue i'm noticing specifically with 'Microsoft SQL Server OLAP Services 8.0', but unfortunately the solution requires an installation of SQL Server Service Pack 3. As i'm using SQL Server 2005 this is not appropriate, and this doesn't resolve the lack of connection to a local .cub file.

Cheers

 

[Flopper]

Resolved.

The Caption field in the OLAP Connection Browser needs to be filled.