Hi
I realise this is a well discussed subject, I've checked the other threads but haven't read anything that helps.
The basic question is how do I get c8 to stop adding the RSUM clause?
A bit more detail:
I'm working on a model that doesn't have any measures so we've created a number of factless facts so we can join dimensions together. We have a number of quieries that report accross multiple facts for example
Query 1 goes from d_firm to f_controlled_function to d_individual
and
from d_firm to f_perm_activity to d_perm_activity
and picks up data items from d_firm, d_individual and and d_perm_activity.
I would expect to see (and want) a stitch query coalescing on d_firm but C8 is also adding the RSUM clause and using that to join the queriies as well as the skey from d_firm. That's messing up the stitch and return the wrong results.
Does anyone have any ideas on how I can do this without the RSUM (if I take the rsum out and run the query manually it works fine).
Any help much appreciated
Simon
No measures would indicate that a stitch is not useful. Avoid setting cardinalities AS IF true facts are present (avoid 1:n)
Cognos will probably add a distinct clause to the one SQL statement to ensure that it returns unique rows as output..
Thanks Blom that worked (apologies should have replied sooner)
Simon