RSUM in stitch query

[wyconian]

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

[blom0344]

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..

[wyconian]

Thanks Blom that worked (apologies should have replied sooner)

Simon