BPC reports - zebra formatting

[former_member206194]

Hi Experts,

We are going live soon with BPC-NW and have some questions regarding BPC-Excel reports, all done with EVDRE() function. Our BPC service pack level is 05, we are using Excel 2007 SP2 for the client and BW 7.01 ABAP Stack (Enh Pack 1) on the server side.

We want to produce a report with zebra formatting (alternating formats) and, so far, we haven't been able to find out how to do it.

Has anyone found a way to do this?

Best regards,

Joao

[Jeffrey_Holdema · Accepted solution]

Please have a look at a new blog I have written to demonstrate how to achieve the zebra stripe effect in the BPC report.

/people/jeffrey.holdeman/blog/2009/11/10/how-to-achieve-zebra-formatting-in-a-bpc-for-excel-report

Best regards,

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

Corrected the URL to the blog.

Edited by: Jeffrey Holdeman on Nov 12, 2009 6:10 PM

[former_member206194 · Accepted solution]

Dear Jeffrey,

I'm afraid I can't login into your blog - can you provide me with the credentials?

Thank you.

Joao

[former_member206194 · Accepted solution]

Dear Jeffrey,

I've managed to find your blog on SDN at /people/jeffrey.holdeman/blog/2009/11/10/how-to-achieve-zebra-formatting-in-a-bpc-for-excel-report and it is indeed a clever and most valuable solution.

Thank you very much.

Best regards,

Joao

[Jeffrey_Holdema · Accepted solution]

You are welcome. I updated my previous reply message with the correct permalink to the blog.

Best regards,

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group