Quiz/QTP help

[Oswald, Jeff]

Hmmm.  As I haven't seen someone step up to this, let me toss out my
thoughts (he says, dusting off his PowerHouse skills)

It was pretty easy until you said all stores and all *items*... then you'd
just:

    Access subfileB link to subfileA optional

but what you want needs a cross-product of stores and items, then linked to
sales.  Lets say you had something like a company id in subfileB.  
CO-ID    STORE-NO
A           1
A           2
A           3
A           4

Then I'd build a subfileC
CO-ID   ITEM-NO
A          10001
A          10002
A          10003
A          10004

and then I could:

     Access subfileB 
        link CO-ID of subfileB to CO-ID of subfileC
<---- gives you list of all stores and items
        link STORE-ID of subfileB, ITEM-NO of subfileC
           to STORE-ID, ITEM-NO of subfileA optional
<---- gives qty sold where it exists

I think that would do it for you... Bob, anyone else, better ideas?

(Repressed PowerPlay/Impromptu person, craving the challenges of PowerHouse
<grin>)

-jeff


Jeffrey H Oswald                         jeff.oswald@cognos.com
Sr. Technical Advisor                       joswald@acm.org
Cognos Professional Services
"trust this man less than Matt Ohmes, really, trust me on this."

> ----------
> From: 	Tracy White
> Reply To: 	ltwhite@ma.ultranet.com
> Sent: 	Tuesday, December 08, 1998 4:38 PM
> To: 	POWERH-L@LISTS.SWAU.EDU
> Subject: 	Quiz/QTP help
> 
> We have been flummoxed at my office by what sounds like it
> ought to be easy:
> 
> From a subfileA containing sales data by store and item:
> STORE-NO ITEM-NO QTY-SOLD
> 1                10001    5
> 2                10003    7
> 4                10004    6
> 
> and a subfileB containing a list of all stores:
> 1
> 2
> 3
> 4
> 
> we wish to create a subfile of all item and store
> combinations, with QTY-SOLD = 0 for the 'dummy' records:
> STORE-NO ITEM-NO QTY-SOLD
> 1                10001    5
> 2                10001    0
> 3                10001    0
> 4                10001    0
> 1                10003    0
> 2                10003    7
> 3                10003    0
> 4                10003    0
> 1                10004    0
> 2                10004    0
> 3                10004    0
> 4                10004    6
> 
> Does anyone have any advice on how to reach this final
> state?
> 
> PH7.29x on HP3000.
> 
> Thanks,
> Tracy White
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.