on 10-01-2008 10:19 AM
Hi ,
I created a query using a multiprovider.
Multiprovider contains one cube and one info object.
Cube contains the transaction data for the customer while info object contains the master data for the customer
In cube ther is an amount field.Info object contains the credit limit for the customer
i want to do exception based reporting based on amount and credit limit
But when i execute my query i am getin two lines for each customer
first line contains the data from cube and the second line contains the credit limit values from the infoobject.
i want it in one line.
Output is some thing like this:
Customer Material Date Creditlimit Amount
1 Iron 29.08.2008 1000
5000
I want the credit limit value also to come in the first line.
Regards
Ansari
Hi ,
You will always get two lines with multiprovider.
This is inherent behaviour of MP.
In case you want to display Customer Master and Transaction data in one report , try using Infoset as it displays intersection not union like multiprovider.
Also, you can try for writing routines at transformation level so as to update customer information from master data directly in cube.
Hope it helps.
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why do need the infoobject in the multiprovider ??
To access CREDIT LIMIT a key figure attribute of 0CUSTOMER.
you need to create a formula variable with replacement and choose attributes.
This formula variable can be used in key figure.
Hence you output will be in single line.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hmm ok check the below link.
http://help.sap.com/saphelp_nw04/helpdata/en/ca/5f9ac61a205a459d0e7ef313d10321/content.htm
Hope this helps.
Hi there,
That's normal with Multicubes. It does the union between two records, if you can't map some characteristics, or you have different values from both it will union both, that's why your seeing a line from the cube and a different line from the InfoObject.
If you can't map you should consider InfoSet, that will do intersection, therefore for the same customer will intersect the values.
Diogo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.