Can you use Cubes created using SQL Server Analysis Services 2008 in Crystal Reports 2008?

Yes and No.

There are three options for using the cube in Crystal Reports 2008:

• Using Olap Server

• Using Local Cube file(.CUB)

• Using HTTP Cube

Using OLAP Server: Yes

Using Local Cube file (.CUB): NO

When I tried to use a Local Cube file created in VS 2008, I could not. SSAS 2008 creates CUBEs with the extension .cube
Crystal Reports 2008 will look for a CUBE with the extension .cub. This is the only choice while browsing for a cube in Crystal Reports 2008.

Using HTTP Cube: Not tested yet