Quote from: aliclowes on 08 Apr 2015 05:13:49 AM
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.