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

Regardning merdging data of a DSO

Hello Everybody,

My scenario is customer expecting report on Posting Date. Data flow : 2 BW 3.5 data sources are there. from there via infosource data directly coming to ODS. Issue is in the table related to 1st data source they are not maintaining Posting Date. only log indicator is there. this confirmation data.In the second data source we have posting date. Now i need to merge both records.

For Ex : If i check for one Day for the first data source i got 60 records with posting date. in that only 10 records are posted with log indicator X. In the second data source for the same day i got 36 records with all the data with out posting date.

I need total 46 records into cube. we can check these data using Transaction ID. In BI 7 we can write end routine. Please suggest me what to do in BW 3.5.

This is the data in DSO.

Tran ID Postinga Date Document Date Log Indicator KF1 KF2 KF3 1 25.10.2012 X 100 100 2 25.10.2012 X 100 100 3 25.10.2012 100 100 4 25.10.2012 X 100 100 5 25.10.2012 100 100 6 25.10.2012 X 100 100 2 25.10.2012 25.10.2012 X 100 4 25.10.2012 25.10.2012 X 100 4 25.10.2012 25.10.2012 100 6 25.10.2012 25.10.2012 X 100

I am expecting it like

Tran ID Postinga Date Document Date Log Indicator KF1 KF2 KF3 1 25.10.2012 X 100 100 2 25.10.2012 25.10.2012 X 100 100 100 3 25.10.2012 100 100 4 25.10.2012 25.10.2012 x 100 100 100 5 25.10.2012 100 100 6 25.10.2012 25.10.2012 X 100 100 100

Please help me. I hope you are able to understand my requirement. Need to merge the rows which have posting date in to above rows which dont have posting date but have log indicator.

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2013 at 01:33 PM

    Issue resolved. Copy the posting date using Transfer id from ODS table and place the same in Posting Date using Update routine . In cube data is fine. Thanks to reply.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 27, 2013 at 02:59 PM

    Hi,

    What are the keyfield in DSO 1 and 2 ?

    Also let us know about the Kfs you are getting from dso 1 and 2.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

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.