Skip to Content

Merge option in Excel and WEBI report

Hi Experts,

I have been working on a requirement wherein I have to create a WEBI report based on an excel file in BO3.1.

If I create a WEBI report based on the table below. it works as expected.

Prices Company Name XXXXX Company 1 YYYYY Company 1 11111 Company 2 22222 Company 2 33333 Company 2

Our requirement is to merge the duplicate entries of the column "Company Name" as below and to create a webi report.

Prices Company Name XXXXX Company 1 YYYYY 11111 Company 2 22222 33333

I have created a webi report based on the above table which has merged cells, however it did not work as expected. Please have a look at the screenshot below.

This report should have the merged cells as we have them in the excel file. I have tried this in BI4.1SP06 as well, however got the same results. 😔

I am not a developer but still I have tried my best to explain our issue and the requirement.

Appreciate all your help. 😊

~SwapnilY

Capture.JPG (18.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 30, 2015 at 08:32 AM

    Hi Swapnil,

    This can achieve by applying Breaks on company name.

    Please follow the steps mentioned below:

    1. Right click on table and Goto "Break" -> Click "Manage Breaks"

    2. Click on Add button and add Dimension "Company".

    3. On right hand side you will see drop down for "Duplicate Values" -> Select "Merge" in it.

    4. Now click OK.

    Hope this will help you :-)

    Regards,

    Veer


    Img-1.jpg (43.4 kB)
    Img-1.jpg (12.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Swapnil Yavalkar

      Hi Swapnil,

      I am glad that the solution works for you,

      Please find answers to your questions below:

      - As you can see the column names(Company and Price) are getting repeated for all the rows, is there a way to get rid of them?

      - Can we have these column names only in the first row of the report?

      Answer:

      > There is no option to omit redundant column names however you can use following trick:

      1. Right click on existing column headings and hide it.

      2. Create dummy row just above first row.

      3. Enter desired column names and apply cell formatting (colors, fonts etc.)  so that it looks like original table heading.

      Please let me know in case of any quires.

      Regards,

      Veer

  • avatar image
    Former Member
    Oct 30, 2015 at 02:33 PM

    Apply break on comapany name and go to breaksetting manage a break there select duplicate values option select merge option u will see like this 

    Name

    Comapany

    xxxxxxx

    Company 1

    yyyyyyyy

    Company 1

    Name

    Comapany

    AAAAAA

    Company 4

    zzzzzzzzz

    Company 4

    then delete the row and change setings in manage break option uncheck the header 

    xxxxxxx

    Company 1

    yyyyyyyy

    AAAAAA

    Company 4

    zzzzzzzzz

    select table table properties and check the table header .

    Name

    Comapany

    xxxxxxx

    Company 1

    yyyyyyyy

    AAAAAA

    Company 4

    zzzzzzzzz

    hope it works Thanks and regards Dinesh
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 05:52 AM

    Hi Swapnil,

    So basically you want to see Company 1 appearing first and then Company 2.

    In that case please select Company name column and sort it as per your requirement.

    Please let me know in case of any issues.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded