Graph Web Item in WAD
I have the following dilemma:
I am using the graph web item in a web template and the data provider has certain KFs that I do not want to diaplay in the graph. For example, I have data for 6 months and the averages at the end in the BEx query. But when I build the web template I want it to bring up values for only 6 months and not the averages.
Create a view on the query with only the KFs you want and use the view as your data provider rather then the query.
To create and save a iew, run the quey in the BEx, remove the KFs you do not want. Once you get the format you want, save it as a global view using the option "Save View Global" under the save icon.