I need help to implement the following example in icCube: A patient can have many dental procedures (the same example applies to diagnostics). The key here is that it must be a many-to-many relationship between the procedure dimension and the table of facts, across a bridge table. Some contribution would help me a lot.
1 Answer
There are two ways of setting up many-to-many relations in icCube: Many-to-Many using a Bridge Table and Many-to-Many dimensions.
A step-by-step tutorial article explaining how to set up both methods is also available here.
Please note we at icCube use stackoverflow quoting "iccube" as support channel: https://stackoverflow.com/search?q=iccube
Thanks for posting your next questions through there! Hope it helps!