Skip to Content
author's profile photo Former Member
Former Member

Combining multiple data provider

Dear All,

I am working on a webi report which consumes three data providers based on BEx. My data provider provides following field

1. Stock related information

This data provider gives following columns date and quantity.

2. Purchase

This data provider gives following columns : date of GR Entry, document number and amount

3. Payment

This data provider gives following columns: date of payment, invoice number (purchase number) and amount ( There is no material in this data provider).

Intention of creating this report is to show a table that will be give stock position on daily basis and an amount paid against an invoice. Amount paid should be reflected in the table only when payment is done.

Providing sample data as below

Stock Info

Date Qty

01-Apr-16 100

02-Apr-16 90

03-Apr-16 80

04-Apr-16 70

05-Apr-16 60

06-Apr-16 100

07-Apr-16 90

08-Apr-16 80

09-Apr-16 70

10-Apr-16 60


Purchase

GRE Date Document Number Qty

06-Apr-16 1111 40

Payment

GRE Date Document Number Amount

07-Apr-16 1110 6000

09-Apr-16 1111 4000


Expected Result

Date Qty Amount

01-Apr-16 100

02-Apr-16 90

03-Apr-16 80

04-Apr-16 70

05-Apr-16 60

06-Apr-16 100

07-Apr-16 90

08-Apr-16 80

09-Apr-16 70 4000

10-Apr-16 60


Is their any we can achieve this? I think will have to use outer join and inner join combination. Since we are using BEx as source, I can not combine two queries.

Any help to resolve this issue is highly appreciated.

Regards,

Girish Oak

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 08:26 AM

    Try and make use of TimeDim() function to tweak the logic.

    Regards

    Niraj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The problem is if I merge these two data providers I get two payment rows where I want only one payment to appear as 1111 is the only common document. Dont want to display for 1110 document. Also, I will be getting stock for all days hence need to have full outer join on this resultant data set.

      Regards,

      Girish Oak

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.