Skip to Content
author's profile photo Former Member
Former Member

Graphical Display in BEX

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2008 at 12:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.