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

WAD question: fix each chart series to a specific key figure

Hi All,

I hope you can help.

In WAD is it possible to fix each series in a chart to a specific key figure from the data provider (query)?

We need to be able to do this because the opening position of our query has a number of hidden key figures, that are displayed later in navigation.

Without being able to fix the series to key figures, in the opening view some key figures are appearing as columns rather than lines and vice versa.

Thanks and regards

IM

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2008 at 04:16 PM

    I don't think we have that control. WAD will automatically calculate the series depending on key figures. Try to rearrange them and have some logic even after hide/unhide.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2008 at 04:26 PM

    Thanks for your answer.

    Would it not be possible to use a view or similar though?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 01, 2008 at 11:09 AM

    Any more thoughts on this, guys? I'd be really grateful for any input this week.

    Regards

    IM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Can you tell it in detail, how do you want to display the chart ?

      Generally, for 2 kf's it takes 2 series like that only series will come. if you want to display only one keyfigure then hide rest of them in view and take (select) that view for the chart.

      Regards

      Pcrao.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 01, 2008 at 12:12 PM

    Thanks for your help, Pcrao.

    My scenario is:

    I have 15 key figures in the columns of my query (data provider).

    The first 12 of these KFs are to be displayed as bars (columns) and the last 3 as lines in the chart of my web query.

    I can set this no problem in WAD.

    But my problem is that because a number of my key figures are set as hide in the query designer (to be unhidden later in navigation) the last three KF's are displaying (incorrectly) as bars until I unhide all KF's in the navigation.

    In other words, it seems to me that I need to fix each series in the chart editing to a specific key figure. But I don't know how.

    Thanks again and regards

    IM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2008 at 11:41 AM

    It seems that the request cannot be satisfied.

    A little disappointing.

    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.