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

WebI: Relating One BEx DataProvider to a Second via a Third

I have a complex reconciliation scenario in WebI where I need to use two fields in one data source to two fields on a middle data source, and then use a third field on that middle data source to relate to a final data source. To make it interesting, these data sources need to be BEx queries.

To illustrate the common fields and how I've merged them so far:

  • [Company Code]
    • BEx1
    • BEx3
  • [Fund Code]
    • BEx1
    • BEx3
  • [Series Code]
    • BEx1
    • BEx2
    • BEx3
  • [Currency]
    • BEx1
    • BEx3
  • [Account Number]
    • BEx1
    • BEx2
  • [Result Type]
    • BEx2
    • BEx3

You can see that I'm using BEx1.[Account Number] and BEx1.[Series Code] through the same fields on BEx2 to get BEx2.[Result Type] which relates to BEx3. Basically, I'm trying to convert BEx1 records by account number to result type instead, then I can group both data sources in the report.

The report so far:

[Company Code]

[Fund Code]

[Series Code]

[Currency]

[*v_AccountNumber]

[*v_ResultType #MULTIVALUE/#INCOMPATIBLE]

[BEx1.KF (properly broken out by account number)]

[BEx3.KF (Repeating its total sum)]

So far, I've got the four merged fields common to BEx1 and BEx3 in a table displaying properly and BEx1.[Account Number] (as a detail variable) displaying too, but BEx3.[Result Type] as #MULTIVALUE (also as a detail variable). This suggests to me that I haven't actually managed to convert the account numbers to the result types.

I've tried calculation contexts with the IN operator but it's ineffectual or results in #INCOMPATIBLE errors.

The final piece of complexity is that BEx2 might have a result type based on [Account Number] and [Series Code], but if it doesn't, I'm to use just [Account Number] to get it. I'm assuming I can handle this via IF condition though, after the initial problem above has been resolved.

Any advice is appreciated.

Thanks,

Chris

BOBJ 4.1 SP5 P3

SAP BW 7.40 SP9

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 18, 2015 at 10:48 PM

    Hi,

    Multi-value error in detail variable means there are more then one records for parent value. ideally there should be 1:1 records mapping when you are creating detail variables.otherwise you will get the multivalued error.

    other thing you can try to merge the object where lowest level of data.in this if you will create detail variable for above one and less chance of more then one record.

    like

    Country,State,city object merge the city objects and create detail variables state and country.

    Amit

    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.