on 01-17-2012 9:56 AM
Hello experts,
I'm using EPM10 Excel add-in(SP04 on server) and to match my customer needs I wish to merge few cells in the first lines of the report (those cells are out of the scope of the report).
Formatting is disabled (i use only static formatting (Excel standard formatting))
My issue is when I refresh the report, the merged cells are unmerged.
How could I prevent that ?
Thanks in advance for any help.
G.
Hello G,
I have experienced the same problem.
However, this issue only occurs in case the Page Axis is used. In my case I removed the Page Axis dimensions and replaced them by EPMContextMember functions, which basically provides me with the same functionality.
For me, this solved the problem.
Best regards,
Joris.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
could you please give more details?
I see the following behavior with EPM Add-in SP07.
- If new report is created one line below the merged cells - the cells are unmerged.
- If an existing report is modified by adding page axis dimension and there is not enough space between the merged cells and the report - the cells are unmerged.
Is it what you see?
- If an existing report is refreshed or modified by adding new dimensions to row or column expansion - the merged cells are intact.
- With refresh or drill down the merged cells are intact as well.
If you observe different behavior please install EPM Add-in SP07. With SP07 and already created reports it should not be an issue.
Kind Regards,
Kirill Gromyko
SAP BPC Support Team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This problem still exists in EPM 10.0 SP 20 Patch 2 .NET 4, Build 9063.
Removing the Page Axis is not an option for me in certain reports, so the proposed solution above does not apply.
Reproduction of the issue:
I have a static report with fixed columns and rows. The actual row and column axes are hidden to prevent users from trying to expand/collapse them. This report shows 36 total months across the top. Each column header is essentially a formula that says =EPMMemberDesc([member ID hidden above]). Above those visible headers are additional headers for each set of 12 months (ie. "Previous Year", "Current Year", "Next Year"). Those headers are formatted to merge and center across all 12 months that apply to them. Each time the report is refreshed they are de-merged and left-aligned.
Well, the issue appears often. Sure, I can work around it for this one report, but some customers are very particular about formatting details. Also, I simplified the example to make the image easier to understand. It's not always this cut and dry.
Customers don't generally like to hear "I'm sorry but BPC can't merge cells."
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.