Importing Data in TM1(10.1) using SAP BEx Query or InfoCube

Post Reply
roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

Importing Data in TM1(10.1) using SAP BEx Query or InfoCube

Post by roy2087 »

Hi,

I want to import data from SAP BW.
I have read that , there are 2 ways to go about it.
a) Use SAP BEx Queries
b) Use SAP BW InfoCubes

Questions:-

1) Which is more feasible or easier to do (BEx or InfoCubes) ?

2) If I use BEx Queries, how do I incorporate it in TM1.
(Do I use IBM Package Connector?)

Thanks,
Roy.
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: Importing Data in TM1(10.1) using SAP BEx Query or InfoC

Post by dr.nybble »

The main method is using TM1 Package Connector with BEx Queries. It leverages BI packages as the data source, so if you are already using BI it is pretty straightforward.
roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

Re: Importing Data in TM1(10.1) using SAP BEx Query or InfoC

Post by roy2087 »

Yes. We are using Cognos BI for reporting.
Thanks for the reply.
Post Reply