A universe from SAP ECC 6.0 and SAP BW 7.3... Possible?

[Former Member]

Hello,

We are looking to create one universe from two SAP data sources;

1) SAP ECC 6.0 with EHP5 and

2) SAP BW 7.3

Can this be done?

In UDT there is a SAP BW connection that can satisfy need for cubes but connection to ECC is a challenge.

I think it's possible in in CR 2011 but exploring webi options.

Any suggestion / work around ?.

Thanks,

[Henry_Banks]

Hi,

With Feature Pack 03 (ramp up registration open now, and RU starts ~16 March), you will be able to use IDT driver to access ECC (R/3) data. and generate a universe.

In the current, 4.0 SP02 Patch2.x codeline, you cannot do the above.

today, You can create a Multi Source-enabled Universe (UNX in IDT) for relational BW-SQL access to underlying BW table schema (by passing OLAP engine and all BEx semantic concepts.)

But - if you have the XI 3.1 Data Federator product already - then you can go from IDT, and use the DF XI3.1 as a datasource into a UNX universe.

I have not tried combining BW-SQL and DF 3.1 connections into a MSU universe.

Yes, using CR 2011, you can consume ECC.

I'd recommend joining ramp up (go via your account team) and evaluating the new features asap.

Regards,

H

[Former Member]

Hi Ravi,

Using XI 3 DF is not an option since our client want just BI4

Hi Henry,

I guess we have to wait until ramp up release of FP3 for us to utilize IDT multisource feature to point to

ECC standard transparent tables and BW cubes in one Universe.

Submitted the ramp up form for FP3 and hopefully nomination get approved.

trying to follow through below suggestion;

"today, You can create a Multi Source-enabled Universe (UNX in IDT) for relational BW-SQL access to underlying BW table schema (by passing OLAP engine and all BEx semantic concepts.)"

Would you simplify little more since IDT is new experience for us?

Thanks Again,

Mohammad

[Henry_Banks]

Hi,

there are lots of online learning maps to show you how:

https://websmp107.sap-ag.de/~sapidb/011000358700001251712010E

https://websmp107.sap-ag.de/~sapidb/011000358700001251722010E

https://websmp107.sap-ag.de/~sapidb/011000358700001251732010E

all taken from here "IDT learning map" : www.service.sap.com/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700001171182010E&;

Regards,

H

[Former Member]

Hi Mohammed,

We can create universe on top of SAP ECC data source using Data fedarator connection.

please check the given below link for creating universe on top of ECC data source.