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

Presenting/Selecting the "result rows" in a query

Hi,

Here is a description of my problem:

I have a query which returns values for materials grouped by purchasing groups:

Group 1 Material A KyeFigure

Group 1 Material B KyeFigure

-


Result: KyeFigure

Group 2 Material C KyeFigure

Group 2 Material D KyeFigure

-


Result: KyeFigure

I'm using a Web application designer chart to present the values graphically. I would like only to present the result rows in the chart, not item values. But since the chart picks all KFs presented in the table (items as well) this is not the case. I've tried to find a way in the chart-settings without any luck - it seems not possible. The documentation states that you're supposed to design your table the way you want it to show in the chart. However, I'm not allowed to redesign the cube or the report. It is not possible to drill up characteristics either (this affects the calculation).

My question is: Is there a way to extract the result rows into a new table and then base my chart on that one or simply somehow present only the result rows in a chart?

Best Regards

/Daniel

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 09:27 PM

    Hi,

    Create a Query View for the report with only the Purchasing group and the Key figure and use the query view for the Chart in the web report.

    Hope that helps!

    Rishi

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Daniel,

      You can create the query view in BEx Analyzer. After you execute the query, use filters, drill downs etc to get to the exact "view" of data that you would like you chart to present. Save this query view. Then in your web template assign this query view as the data provider.

      Hope this helps...

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.