Skip to Content
avatar image
Ramesh Jothimani

Webi Merging two BEx

Feb 05, 2018 at 05:18 AM | 46 Views

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)
expected-result.png (3.0 kB)
SAP BusinessObjects - Web Intelligence (WebI)
SAP BusinessObjects Business Intelligence platform
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    AMIT KUMAR
    Feb 05, 2018 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

  • avatar image
    Ramesh Jothimani
    Feb 06, 2018 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