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

How to make a report based on the result of another report?

Hi, All,

I am a new guy in BW development

I made the report1, to show the "Total Sales in each country and each shop "

(the fact table is "Order")

now I want to make report2 "in each countries, the number of the shops, whose Total Sales >100000"

Can I make the report2 based on the result of report1 (use the same fact table)

thanks a lot

QY

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 12:30 PM

    You should create a condition on report1 with Total Sales > 100000. Now you can create a replacement variable (e.g. for shops) where you can choose 'Replace from Query Result' and enter report1. This variable should be used in report2 to restrict the shops.

    If the performance is bad, try to use result sets in the Reporting Agent.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 12:32 PM

    Hi,

    you don't even need two reports. What you describe can be implemented with a "condition". If you activate the condition you can see only >100000, otherwise you can see everything. Please look for documentation of conditions in the online documentation or press the condition button in the query designer and just try.

    REgards, Klaus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Klaus,

      your condition only works if the Shop is in the query. If I understood it correctly you have one query with

      Country Shop Total Sales

      and one with

      Country Number of Shops Total Sales

      and you don't want to restrict the second Total Sales but the Total Sales from the first query.

      Best regards

      Dirk

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 01:04 PM

    Thanks for the reply.

    but i need not only a condition, but the aggregation of numbers of the shops , whose total sales > 100000 in each countries (e.g. USA, germany)

    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.