CAN SAP AND NON SAP REPORT COMBINED IN REPORTING

[Former Member]

HI

Is it possibe to combine sap and non sap (say MS ACCESS) data and fetch a result in webi?

if it is possible what kind of schema is used?

[PPaolo · Accepted solution]

Hello,

you can also build a multi-source universe where you can join tables from Access with a relational view of your BW cubes.

If you are in XI3.1 you need to use a product called 'Data Federator' where you federate data from BW with data from Access and expose the federated tables as a virtual database.

If you are in BI4.0 you just need to create a multi-source data foundation using the Access and BW connectivity. You then can join the Access and BW tables in the data foundation.

In both scenarios, the final WebI user will not know that the report is being run on multiple sources, the user will just see a plain universe.

Please notice that with this technology you loose the hierarchical information stored in BW.

Regards

PPaolo

[Former Member]

Hi Uma,

You can Connect SAP with NON SAP. MS-Access we can connect the Database using OLEDB connection. You can use any schema either it is star or snow flake.

You can first create a unv using this Ms-Access DB:

you need to set up DSN for the connection to Access database.OLEDB is normally a better choice, unless you want to use ODBC. There is a sample universe called eFashion that comes with the installation.

Here are the steps to create a connection to the Access Database.

Need to create a DSN for the Ms Access Database:

From Start->Control Panel -> Administrative Tools ->

-> Data Sources (ODBC)

-> System DSN tab

-> Click on ADD

-> Select Microsoft Access Driver (*.mdb), Click on Finish

-> Give a Data Source Name : test_dsn

-> Under the database section, click on Select

-> Choose the .mdb file, click on OK

Login to Designer,

File-> Parameters -> Click on "New" to create connection

->Click on Next, provide a connection name

->select the Microsoft -> Ms Access 2003/2007, ODBC Drivers,Click on Next.

-> in the 3/5 window, select the DSN created above

-> Next, Next, Finish.

All the Best,

Madhu...

[former_member817653]

If you are using BO XI 3.1 then you need to create separate Universes on SAP and non-SAP data source and use 'merge dimension' feature in WEBI to co-relate the data from both the data sources. The requirement is there should be atleast 1 common dimension between the two Universes.

[Henry_Banks]

Hi,

I agree with what Mathangi says.

You need a common field to merge with, and this is done at the WebI document level, by using multiple dataprovider queries.

(1 for each source)

Regards,

Henry