How to create charts or graphs for BW Statistic Report workbooks

[Former Member]

To All:

I successfully created 5 BW Statistic Report workbooks. Now i have the requirement to add automated excel graphs for these 5 workbooks.

My 5 BW Statistic workbooks are divided in to two

categories, three worbooks are for load analysis and two are for Query performance analysis.

please give me an idea or documentation for how to add charts or graphs to these workbooks. my email is rafi.sap@gmail.com.

Thank you for your generous help.

[Former Member]

Majeed Bhai,

Thank for your reply.

yes, i am able to draw a graph. but the graph is totally messed up because i have lot of crappy data (#, blanks, and totals). the issue is how to draw a good chat with the existing data. i will send you and email with type of graphs that i am looking for. thank you.

Rafi Ahmed

[majeed_mohammedabdul]

Hi rafi,

As u are using workbooks, u can use the chart functionality of the Excel and draw the charts giving the range.

U have different kinds of charts available there.

Just goto ur workbook and on that sheet or on a diff sheet just say insert > chart and give the range there and u can easily draw charts there

Hope this helps

regards

Majeed

[Former Member]

One option is that you can use Web application designer to create good charts and graphs. Please refer to WAD help. Chart is one of the several web items you can use on your web template.

Thanks,

Dinesh

[Former Member]

Dineshgi,

Thanks for writing me an email from your busy schedule.But if you have any documents or link please forward to my email listed below.Again thank you for your help.

Rafi Ahmed

[Former Member]

Did you look at the Business Content wkbks for Technical Content - they provide queries on query performance, compression, and rollup time, and load performance - all with charts/graphs.