cancel
Showing results for 
Search instead for 
Did you mean: 

EPM 10 Excel Add-in : can't use merged cell out of report range

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks a lot Joris,

I did what you propose and it solve the issue.

Points granted.

Regards

G.

Answers (1)

Answers (1)

kirill_gromyko
Active Participant
0 Kudos

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

Former Member
0 Kudos

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.

former_member186338
Active Contributor
0 Kudos

But why not to put "Previous Year" in K column without merge? Not ideal but...

Vadim

Former Member
0 Kudos

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."   

former_member186338
Active Contributor
0 Kudos

If you have static report you can always adjust the group header to be centered somehow. And many customers don't like to have merge cells at all - unpredictable navigation using keyboard...

Vadim