Stitch queries - requirements and troubleshooting

RADSr — Fri, 20 Oct 2023 14:36:15 GMT

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?

Re: Stitch queries - requirements and troubleshooting

RADSr — Fri, 20 Oct 2023 17:31:00 GMT

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.

topic Stitch queries - requirements and troubleshooting in Administrative Discussions

Stitch queries - requirements and troubleshooting

Re: Stitch queries - requirements and troubleshooting