Skip to Content

BW Macros for Advanced Formatting of BEX Reports

Hi BW Gurus,

Would like to bring to ur attention for a small solution which i have proposed for SAP Tech Ed. As a BW consultant, you would have come across a situation where you had to decide a reporting tool that was flexible, reliable, user friendly, less expensive and that can be used with less training but still have all the features of Excel.

Topic : BW Macros for Advanced Formatting of BEX Reports

Abstract : The workshop will help you to provide advanced formatting with Bex Reports. You will also learn how to add and retain Formats in Bex reports with BW Macros. Advanced formatting includes retaining of formats with excel shawdow boxes, automatic print settings, comments, hiding rows or columns, adding calculations, changing color, maintaining report titles. etc. The solution will help the business users/ power users to maintain different formats of a report without going for any 3rd party tools like Crystal or Business objects. As most of the business users are familiar with Excel, it would be easy for them to maintain or change the reports rather depending on IT for each change.

For additional details please have a look at this

http://www.netsaptech.com/sdn/BWMacrosforFormatting.pdf

If you feel that this presentation is going to help you dont forget to vote the presentation at sdn.sap.com for SAPTech Ed 2006 - Las Vegas.

For details on how to vote click the below link.

http://www.netsaptech.com/sdn/sdn.htm

Bio of the Author.

http://www.netsaptech.com/resume/MMDinesh_Org.doc

Regards,

Dinesh Mukundu

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 03, 2006 at 11:15 AM

    Hi Dinesh,

    I am currently in the requirement of following, request your help on this.

    In my BEx report I require to show the aggregation values in different colors.

    That is suppose my report has 3 characteristics and 2 keyfigures. When the 'Result' appears for characteristic1 it should be shown in blue color(not specific) and when the result appears for characteristic2 it should be shown in red color and when result appears for characteristic3 it should be shown in green color and similarly.

    Please help..

    Thanks and Regards,

    Satya Raj Kumar.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2006 at 05:21 PM

    Hi

    If i understand your problem, you want to set the color of the result section of the keyfiures.

    char1 char2 char3 kf1 kf2

    xxx yyy zzz 10 20

    aaa bbb ccc 11 22

    Result 21 42

    red green for the result section.

    If this is not ur question, can u pass the snapshot of the output u are looking for simulating in Excel.

    Rgds

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2006 at 02:32 PM

    Hello Dinesh,

    I try see the document on http://www.netsaptech.com/sdn/BWMacrosforFormatting.pdf

    but I get the following erros: "The requested document was not found on this server."

    Any change for you to send me in my e-mail address at susana.messias@gmail.com?

    Thanks a lot!

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:45 PM

    Hi Dinesh

    Can you tell me how to compare r/3 report values and bw report values by using excel macro or vlookup program, if you know step by step can you tell me?

    Thnx

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.