Records coming in two lines in query.....
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
I want the credit limit value also to come in the first line.