cancel
Showing results for 
Search instead for 
Did you mean: 

Stitch queries - requirements and troubleshooting

RADSr
Partner
Partner

I have two "fact" tables  ( one is actually a snapshot table so I'm not trying to get measures from it so much as I'm trying to get point in time attributes from it ) both joined to a date and a customer table where the "fact" is the child.

In DW terms date and customer are the conformed dimensions.

I *think* I know that Incorta can stitch the two together, but I'm not sure 1) how to do it since I've got it wrong now 😉  or 2) how to adjust/troubleshoot such a requirement.

Hoping someone can point me to a doc or lend a hand? 

 

1 REPLY 1

RADSr
Partner
Partner

Thank you @anurag !

Simple rule, but important!  Incorta will stitch queries properly when *only* parent table columns are included in the grouping area of an aggregate table.   

Filters seem to require the same, so if you have customer account in both the child and parent tables which you choose makes a difference in both areas.