First thanks in advance for your time!
I'm having trouble with the concept of the context. In all of the examples I search and reviewed they are always the same example. With that being said I have this example. I
have a table that looks like this.
Fac | # of orders | # of alternatives
SJN | 7 | 15
Fac = detail object, # of orders = measure, # of alternatives = measure.
The problem is that the value 15 is the value of the all of the data values that are possible for alternatives. In this case each of the orders should have some combination of alternatives. So for example one of the 7 orders may have 3 alternatives, the next order may have 5 and another may have 8 with the total of all 7 orders having say 104 total alternatives. The there are three queries. The first gathers the orders. The other two gather the alternatives and then lastly documentation. The later (documentation) is not part of the example. If I were to remove the column # of orders and substitute the orders number themselves the # of alternatives would be a column of the value 15, where they should be the count for the individual order id. I've tried using IN, Forall, Foreach, etc but I never get the correct values? Please give me some guidance. This is an important concept and I'm missing something!
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.