Hi bo team

[Former Member]

Hi i am new to IDT but i have a doubt,that is Actually we are creating multi source universe by using IDT right.

1.What are the requirements for creating multi source universe?

2.it supports or not creating universe on top of sap and non sap data sources? if it supports.how its possible?

Thanks & regards

Lavankumar

[former_member4998 · Accepted solution]

Hi

1.What are the requirements for creating multi source universe?

If you want to display data from multipule data  bases (SQL,Oracle, etc) into the reports, then you can create multi-source universe.

For that you need to create multpile connections and pointing to one universe (Muilti-Source).

http://scn.sap.com/docs/DOC-22055

https://www.youtube.com/watch?v=6QHhFSNLDG0

https://www.youtube.com/watch?v=hDd-U8VVGzM

https://www.youtube.com/watch?v=BNb2b2T7tuc

2.it supports or not creating universe on top of sap and non sap data sources? if it supports.how its possible?

Find the below links for more info.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d056e1bc-2794-2e10-959e-8779c5623...

http://events.asug.com/2012BOUC/0915_Building_a_Multi_Source_Universe.pdf

[Former Member · Accepted solution]

Hi Sreenu,

              Thanks for your links and answer.i know how to build the multi source universe but how it possible to build universe creation on top of sap bw source and oracle r sql server data souce...whith out common dimention its not possible to build msu right.....

regards,

Lavan

[former_member4998 · Accepted solution]

Hi

it possible to build universe creation on top of sap bw source and oracle r sql server data source...

Is it possible to create universe on top of SAP BW and Oracle/SQL

Yes, It's possible . But you need to connect BW using relational connection

with out common dimension its not possible to build right....

Yes, without common dimension/Common data not possible to link, if both DB have common dimension, then you can able to build Multi Source universe.

For ex: From BW have

Material       Price

0022           20

0012           22

0011           12

0010           14

From Oracle

Product        Plant       Product Name

0022                12           Maggi

0012                22           Kitkat

0010                22           Milk

So you can link using Material (BW) to Product (Oracle), beacuse comman dimetion, so without comman dimention you not able to build multi-source universe.

Please find the below link for more info.

http://scn.sap.com/docs/DOC-38685

[Former Member · Accepted solution]

Hi Sreenu,

               Thank you very much,now i am very clear about this topic...the fact is after your explanation i understood very clearly....thank you...

regards,

Lavan.

[Henry_Banks]

Hi,

you should ask this question under "semantic layer"  ( I will move this discussion there shortly)

  There is some information in the help guides (Information Design Tool User Guide)

Also tutorial on SCN http://scn.sap.com/docs/DOC-22055
and other papers there http://scn.sap.com/docs/DOC-42050 , http://scn.sap.com/docs/DOC-38685 

Also, wiki here http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+BW+Data+Sources+for+4.x
and config here http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+BW+With+RFC+JCO+Connections+In+Information+Design+Tool

Regards,
H

[Former Member]

Hi Henry,

          Sorry for this and don't do this again and thanks for your valuable links....

with regards,

Lavan