MS Analysis cubes

[aliclowes]

Hi

Is it possible to connect Data Manager to MS analysis cubes so that we can pull data from a cube into our data warehouse

Thanks

Alison

[MFGF]

Hi

Is it possible to connect Data Manager to MS analysis cubes so that we can pull data from a cube into our data warehouse

Thanks

Alison

Hi,

If you have Cognos 10 BI, you can create a data source in BI to point to a MSAS cube, and publish a package for the cube. In Data Manager, you can then add a connection using the "Published FM Package" option. With these package connections pointing to cubes, you can't code SQL as you would with a "normal" connection in Data Manager - instead, you drag in levels and measures to define the data to retrieve.

Cheers!

MF.