BW Macros for Advanced Formatting of BEX Reports

[former_member192249]

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

[Former Member]

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

[Former Member]

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

[former_member192249]

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

[Former Member]

Hi Dinesh,

Many thanks for your response, My exact requirement is as follows:

char1 char2 char3 keyfig1 keyfig2

value1 valu1 val1 100 10

value1 valu1 val2 200 20

value1 valu1 val3 300 25

value1 valu1 <u>Result 600 55</u>in blue color

value1 valu2 val1 200 10

value1 valu2 val2 400 20

value1 valu2 val3 300 25

value1 valu2 <u>Result 900 55</u>in blue color

value1 valu3 val1 200 10

value1 valu3 val2 400 20

value1 valu3 val3 300 25

value1 valu3 <u>Result 900 55</u>in blue color

Value1 <u><i>Result 2400 165</i></u>in green color

value2 valu1 val1 100 10

value2 valu1 val2 200 20

value2 valu1 val3 300 25

value2 valu1 <u>Result 600 55</u>in blue color

value2 valu2 val1 200 10

value2 valu2 val2 400 20

value2 valu2 val3 300 25

value2 valu2 <u>Result 900 55</u>in blue color

value2 valu3 val1 200 10

value2 valu3 val2 400 20

value2 valu3 val3 300 25

value2 valu3 <u>Result 900 55</u>in blue color

value2 <u><i>Result 2400 165</i></u>in green color

value3 valu1 val1 100 10

value3 valu1 val2 200 20

value3 valu1 val3 300 25

value3 valu1 <u>Result 600 55</u>in blue color

value3 valu2 val1 200 10

value3 valu2 val2 400 20

value3 valu2 val3 300 25

value3 valu2 <u>Result 900 55</u>in blue color

value3 valu3 val1 200 10

value3 valu3 val2 400 20

value3 valu3 val3 300 25

value3 valu3 <u>Result 900 55</u>in blue color

value3 <u><i>Result 2400 165</i></u>in green color

<b><u>Overall Result 7200 495</u></b>in RED color

Please help.

Thanks and Regards,

Satya Raj Kumar.

[Former Member]

Dear Dinesh,

I'm having problem accessing the pdf file. Can you send it to my email ID.

mathiasswagner@gmail.com

Regards,

Abir

[Former Member]

Hi Dinesh,

It will be helpfull if you send this to my email id as well ash_yyp@yahoo.com.As I cannot open this document.

Thanks,

Afsha.

[Former Member]

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.