Wednesday, October 29, 2008

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

No comments: Protection Status