Skip to Content

Webi Merging two BEx

Hi Experts,

I have a requirement to show the report based on Owner. Please find the example below.

Query 1:

Query 2:

Expected result:

Need to so the value based on owner with aggregated.

Please let me know if you have any idea, whether this can be done via UNX or directly in Webi or some other reporting tool.

Thanks!

Regards,
Ramesh

query-1.png (2.5 kB)
query-2.png (5.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 05 at 10:11 AM

    follow these steps.

    merge material object.

    Create V owner detail variable.

    Drag V Owner and week's measure object in the table.If you want to exclude null row without owner name then add filter on V owner variable and exclude null values.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06 at 03:05 AM

    Hi Amit,

    Thanks for the help. It worked for me.

    Regards,
    Ramesh J

    Add comment
    10|10000 characters needed characters exceeded