Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Two records after adding Proj type

Hi,

  I have an below webi output based on two sources. SAP and Oracle

Case 1 output:

ordnum(merged dimen of SAP and Ora)    plant (merged dimen)    profictr (merged dimen)    Amt1    Amt2          Am1-Amt2

342                                                       XXXX                           792                               238482   200             238282   

Case 2 Issue: Adding Proj type into the Case 1 output

ordnum(merged dimen of SAP and Ora)    plant (merged dimen)    profictr (merged dimen)    Amt1       Amt2       Am1-Amt2     Proj type

342                                                      XXXX                           792                                               200          200               Projects

342                                                       XXXX                           792                               238482                    238482            Project

From Case 2 output, i just added proj type dimension into case 1 and the amount is splitted up into two records.

Now what iam trying is endoutput should be case 2 should have one records only as like case 1 having Proj type as additional column. Both Projects and project is of type Projects proj type.

Appreciate your help.

Thanks,

Dinya.

Not what you were looking for? View more on this topic or Ask a question