Graphical Display in BEX

[Former Member]

Good day

I need to update a graph from a query, but the graph must always include selected columns of the result area as well as new columns that may be added due to additional CALMONTH's. I do not want to display all columns. ie. currently only data for 200801 will disply in the query and without changing the source of the graph on a monthly basis, the graph must automatically pick up when 200802, 200803 etc is displayed in the refreshed query.

If I use the graph in BEX from the toolbar, then it will refresh will all the columns when refreshed, not just the required columns. If I use the Excel wizard to create a graph, then the graph will only display the areas that were selected when the graph was created.

Can someone please assist me?

Thanks

Cj Faurie

[Former Member · Accepted solution]

hello,

Instead of using the calmonth inside the structure you can use it outside the structure with the restrcited to the calmonth needed

In that case only the calmonth which has the values in teh cube will be displayed and chart created will only on those calmonth.

thanks