Build Graph in WAD

[former_member227148]

Hi friends

I have some questions,

1- i have a query containig, put this Query into my (Table Web Item); having 15 Columns and more them 40+ Rows in my (Table Web Item). I want to build a graph on this query, but not using the whole contents of the table. the nature of graph is Bar chart.

1- First i make the graph on the First 3 columns only.

2- Next i build the 2nd Graph on 4th to 8th columns,

3- Build 3rd graph from 11 to 13 and using 15th coulmn.

What's the solution,that build a number of graph using diffrent portin of the table.

one solution create more quries per graph which i want. Build the graphs in my Web Template by using those Quries.

can we Filter the Columns on DATAProvider Level. so only the required Columns are get. by using this Filtered DataProvider with our Web ITEM we develop our graph.??????

please guide me . How to deal with this.

Thanks in advance.

[Former Member]

Hi,

within 3.0/3.1 you should do the following: Stick to your one query but build different QueryViews on this query (in Analzyer Menu option Save view globally; in WAD use the option to create Views on queries). So filter the relevant columns and save the views; use these views as different DataProviders.

In future within BW 3.5 you'll have the possibility to hide series within the ChartDesigner.

Heike