Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    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 comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    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 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
    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 comment
    10|10000 characters needed characters exceeded

    • Former Member

      For this you could use local aggregation in the result query (context menu-> calculate-> result as->summation. Then you'd see the details and the sum of the details (I think).

      Regards, Klaus