COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Dynamic Cubes => Topic started by: kkharbanda on 17 Oct 2014 04:45:21 PM

Title: Connecting Dynamic Cubes with SAP
Post by: kkharbanda on 17 Oct 2014 04:45:21 PM
Can we connect dynamic cubes with SAP (ECC or BW)? We currently connect SAP BW to Cognos Report using Framework Manager and looking for options to connect BW to Dynamic Cube to store data in memory. If connection if BW to Dynamic Cubes is not possible, we are open on connecting from SAP ECC as well.

Thanks,
KK
Title: Re: Connecting Dynamic Cubes with SAP
Post by: MFGF on 21 Oct 2014 10:22:09 AM
Quote from: kkharbanda on 17 Oct 2014 04:45:21 PM
Can we connect dynamic cubes with SAP (ECC or BW)? We currently connect SAP BW to Cognos Report using Framework Manager and looking for options to connect BW to Dynamic Cube to store data in memory. If connection if BW to Dynamic Cubes is not possible, we are open on connecting from SAP ECC as well.

Thanks,
KK

Hi,

It doesn't look like the data source connections to BW/ECC/Netweaver/R3 are available for use with Dynamic Cubes. Take a look at the conformance page:

http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/prereqsForProduct?deliverableId=1330380859450#!

For data sources that are (such as Oracle 12c Enterprise, for example) it lists "Available for use with Dynamic Cubes" in the notes. No such message is there for any of the SAP sources.

Cheers!

MF.