Question:
Hi All,
We have a custom DataSource of whicih our BW modeling is based on. Now due to DataMart, we have to feed the same InfoSOurce with the combination of 80FIAP_O03 and 80FIGL_O02 export datasources.
How can we do this?
Thanks in advance.
- Gary
Answer:
An infosource is a 1 to 1 relationship for pulling data from a datasource.
What you can do is feed multiple infosources into one ODS or InfoCube.
If you feed them into a common ODS you can then deliver that to whatever you want. Alternatively you can feed each to its own ODS and then build a further ODS or InfoCube based on those two ODS's.
Answer:
Hi Bob,
I see what you are saying. We do not mind sending to two ODS and then feeding an another combined ODS. Would you explain us how can we do with the example I am giving here.
The larger ODS has the following fields, ODS Name: ZAllODS
GL Acct. Vendor Doc# Item # Amount
The smaller ODS has the following fields
1. Name: ZAPODS
Vendor Doc# Item# Amount
190876 100000009 1 $600,000
2. Name: ZGLODS
GL Acct. Doc# Item# Amount
145000 100000009 1 $600,000
234000 100000009 2 $500,000
Now we want to have in the combined ODS as the following
GL Acct. Vendor Doc# Item # Amount
145000 190876 100000009 1 $600,000
234000 100000009 2 $500,000
Is this possible?
Thanks in advance?
- Gary
Answer:
1. Name: ZAPODS
Vendor Doc# Item# Amount
190876 100000009 1 $600,000
2. Name: ZGLODS
GL Acct. Doc# Item# Amount
145000 100000009 1 $600,000
234000 100000009 2 $500,000
3. Name RESODS
GL Acct. Vendor Doc# Item # Amount
145000 190876 100000009 1 $600,000
234000 100000009 2 $500,000
Create RESODS with key fields Doc# and Item, Vendor and Gl Acct and Amounts as data fields;
create update rules to RESODS from ZGLODS, map GLAcct Doc# Item# and Amount to the corresponding fields
In the update rule for Vendor, add some abap code to read the vendor from ZAPODS based on the doc# and Item#.
That's it
Ch
Answer:
CHC
One quick thought if all r key figures how abt building MULTICUBE on top of all ODS.
THnkx
Msrpa
Answer:
because not everybody is using version 3
Answer:
HI
Multicube is there in 2.1 c
Msrpa
Answer:
Come on, Mrspa, up to now we managed not to have this kind of challenges between "who knows more than who"....
Multicube in 2.1C is not capable to create a multicube on an ODS, is it ?
Of course, when I first started to answer Gary's concern, I could have thought about proposing a multicube on basic cube solution instead of going further with his idea about ods; to this point you are right.