Question:
Hello,
I have 3 ODS with the following charact and key figures
ODS 1
Char. - A / B / C
Key figure - 1
ODS 2
Char. - A / B / D
Key Figure - 2
ODS 3
Char. - A / E
Key Figure - not applicable
Imagine that:
A (Sales Order) B (Material) C (Customer) D (Invoice) E (Plant)
1 (Quantity) 2 (amount)
I want to get a report with
Line: A B C D E
Column: 1 2
If I use a Multiprovider to get this report the better I can get is:
Line: A B
Column: 1 2
Is this correct?
Is there any way to load these 3 ODS data to an unique ODS with records kind of : A B C D E 1 2 ? Put all the info in the same record, where the Key would be A (sales document)?
Some ideas would be appreciated.....
thanks
Answer:
Hello to our guest
Is there any way to load these 3 ODS data to an unique ODS with records kind of : A B C D E 1 2 ?
Load the data from ODS1, ODS2 and ODS3 to a new ODS. It is important that you activate all the requests together (this is impotant because the requestID is a part of the key, and you need to eliminate seperate requestIDs).
Put all the info in the same record, where the Key would be A (sales document)?
If the sales order is a unik ID, as I imagin it should be, you are on the right track.
If I use a Multiprovider to get this report the better I can get is:
Line: A B
Column: 1 2
Is this correct?
It is difficult to answer this question. I will assume that what you are asking is if the result is correct from a technical point og view. The answer to this question is "YES". But what about your scope?
Good luck with your report
L2L
Answer:
Thanks for your answer L2L,
Can you please let me know in detail what do you mean by activate the requests togueter? how should I proceed to get a unique record line assuming that I have a key (it can be one object as in my example or a group of infoobjects) and additionally the request ID?
Have you done this? do you think is the best way?
This question would solve me several issues that I never had before. For instance now I need to extend my 0MATERIAL infoobject and load Zdata into it. So I have created a ZDatasource, an infosource, etc etc but I am not able to load the ZData into my "extended" 0MATERIAL, using the material number as Key and get one record for each material combining data from the two infosources!!! I hope I was clear!!!
About the Multiprovider, I wrote what I can get from it and not what i need to get. I was hopping someone tell me I was wrong!!!! But in general what I need to confirm is the following: from multiproviders I only can get key figures from both InfoCubes if I have the choosen characteristics in both infocubes... example:
Infocube A
Char. A B C
Key Figue 1
Infocube B
Char. A B D
Key Figure 2
I can get on report
A B 1
But I cant get
A B C D
Is this true? the multicube gives me key figures from both cubes based on commom characteristics and if I choose a charact that is not common it will not work?
Thanks in advance
Best Regards
EF