Skip to Content

Formatting using Merge cells for Local Members in EPM Report

Hi Everyone,

I've added a localmember into my EPM Report but I can neither use the Formatting Sheet option to merge a few cells nor can I use the Excel formatting. After EPM Refresh, the Excel Merge & Centre formatting is ignored by the system and those cells become unmerged again.

The requirement is to add a comment box for users to input comment at the end of the report i.e. after the last row of a dynamic EPM report i.e. both columns and rows of this report contracts and expands depending on a particular EPMContextMember.

Has anyone come across this issue before?



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 18, 2016 at 01:22 PM

    Merge cells is not compatible with EPM dynamic reports.

    For the rest - please post a screenshot and explain what you want to achieve using the screenshot!


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2016 at 09:56 AM

    Hello Chatterjee,

    if you don't want automatic column width please disable the following option and adjust manually the length of column. find the attached screen shot as reference.

    otherwise go to your formatting sheet and add a member/ property specific. see below screen shot as reference.

    Hope this will helpful for you..

    Thank you very much

    Best Regards,

    Saida Reddy Gogireddy

    pastedImage_0.png (22.9 kB)
    pastedImage_1.png (154.7 kB)
    Add comment
    10|10000 characters needed characters exceeded