on 12-09-2014 4:17 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.