cancel
Showing results for 
Search instead for 
Did you mean: 

Is it reliable to use Business Objects on top of ECC or else to go with BW with BO

Former Member
0 Kudos

Hi Techies,

I am working on a BO Platform 4.1, My requirement is to create Webi Reports. I am bit confused that is it relaible to use SAP Business Objects on top of ECC. or else it is good to use BW on top of ECC and then to BO.

If so , do we get real time data if we create a Universes on top of ECC as datasource.

I have seen many threads that we can access the ABAP Functions and INFOSETS and Queries directly into IDT and create a universe on top of it.

I Started creating a universe in IDT.

1. Created a Relational Connection

2. But was not able to create a Multi source Datafoundation

I was not able to select the Secured Connections they are greyed out, as attached in Screenshot.

I am able to create a single source DF layer in which we cant join the other infosets.

Awaiting for your quick response.

Thanks & Regards

Amjad Ali.

Accepted Solutions (0)

Answers (3)

Answers (3)

andreapancotti
Explorer
0 Kudos

Dear All,

the link provided by Amit Kumar are not available... where I can find this information now?

Best regards,

MJ

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Do you want to connect both ECC and BW sources??.

Create connections shortcut and use them (SAP JCO and SAP NW BW) as middleware.

.

Thanks,

Jothi

Former Member
0 Kudos

Hi jyothi,

Yeah, i have created the Relational Connections and also Secured those connections by publishing to the repository and created the shortcut connectios. and while creating the Multisource DF , i am able to view the list of Shortcut connections but are greyed , unable to select those...

regards,

Amjad

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Do you have ODBC.OLEDB connection?. if ODBC, then do you have 2 ODBC connctions set up on your machine and then try creating DF. All the client tools uses 32 bit database drivers

Also, Check Adaptive Job Server is up and running.

Verify your rights on creating IDT.

Thanks,

Jothi

amitrathi239
Active Contributor
0 Kudos

It's more depend on the requirement to connect with ECC or SAP BW.

With ECC you have limited connectivity options.In BW you have more transposed data for reporting..

For creating data foundation you need to create connection shortcuts in the project first..after that you can select the connection shortcut.

Former Member
0 Kudos

Hi amit

Could you brief me in detail about the limited connectivity with ecc.

amitrathi239
Active Contributor
0 Kudos

Multisource universe ECC JCO connector can connect to ABAP Functions and INFOSETS only.This is more required when real time reporting is required.

SAP BW is more about historical reporting which is n-1 from ECC system.In BW is more transformed data from ECC system which is actually for reporting only.

SAP BO can connect DSO/Cube/Multiprovider/BEx queries with SAP BW.

Multisource universe can connect DSO/Cube/Multiprovider.

BICS connection can connect Multiprovider/BEx queries.