[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference award::copis_users

Title:COPIS VAXination Users Conference
Notice:Please use conference ORCHRD::FMAP_USERS - see note 1.1
Moderator:ORCHRD::KIPNES
Created:Wed Jul 13 1988
Last Modified:Fri May 18 1990
Last Successful Update:Fri May 02 1997
Number of topics:171
Total number of notes:402

68.0. "A question on summarized/detailed information" by SHOTIM::COPUSER73 (Joe Bruno - Demand/Supply) Fri Oct 21 1988 14:08

A point of clarification on summarized/detailed information:

In the Demand/Supply specifications dated August 10, 1988 every requirement
has the user supplying a "product (aggregation or 2-5-2 option) OR file
containing products(s)".  With respect to the user entering a file containing
a list of products, the implementation should yield the results outlined in
the following example.

Assume the following 2 product files:

             File=VIDEO-1 (2-5-2 options)      File=CPU-1 (aggregate products)
                VT220-AA                          8810
                VT330-AA                          8800
                VT240-AA                          85XX


When the user enters a query and supplies either VIDEO-1 or CPU-1, they should 
be able to get a) a (one line) summarization that combines the UNITS, MLP, or
XFER COSTS of each of the products that comprise the file, and b) the UNITS,
MLP, or XFER COST for each of the members that make up the file, which
constitutes the detail.

So, at the summary level, the displays should look like:

                                UNITS
        PRODUCT        Q1     Q2     Q3     Q4
      -----------      --     --     --     --
         VIDEO-1       10     20     30     40


                                UNITS
        PRODUCT        Q1     Q2     Q3     Q4
      -----------      --     --     --     --
         CPU-1         50     60     70     80

And, at the detail level, the displays should look like:

                                UNITS
        PRODUCT        Q1     Q2     Q3     Q4
      -----------      --     --     --     --
         VT220-AA       0      5     10     10
         VT330-AA       5     10     10     20
         VT240-AA       5      5     10     10

                                UNITS
        PRODUCT        Q1     Q2     Q3     Q4
      -----------      --     --     --     --
         8810          10     20     35     10
         8800          15     20     10     50
         85XX          25     20     25     20

Is there any functionality that currently exists on COPIS/VAX that enables
these kinds of queries?

Joe
T.RTitleUserPersonal
Name
DateLines
68.1Current screen implementationCINEMX::COPDEV61Karen Underkofler DTN 269-2286Wed Oct 26 1988 08:439
    The current summary screens follow your example above.  However,
    the detail screens print information at 2-5-2 level.  When you create
    an agg composed of other aggs, information for each of the 2-5-2s
    comprising each of the aggs will be displayed.
    
    The reports and data extracts will have an option available to
    summarize at the aggregate level.  If you select that option, the
    information will be displayed in the same format as your detail
    example.