Skip to Content
avatar image
Former Member

Records coming in two lines in query.....

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

  1. 5000

I want the credit limit value also to come in the first line.

Regards

Ansari

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 01, 2008 at 09:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 01, 2008 at 09:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Praveen G

      Praveen thanks for that reply.

      I have got 80% work done now.

      i got the two colomns together in the output now.

      how to use exceptions and compare these two fields now so that based on that i can change the color of the field..

  • avatar image
    Former Member
    Oct 01, 2008 at 09:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded