How to implement many-to-many relationship between a dimension and the fact table in Iccube?

0

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.

The star scheme consists of the tables: patient, procedure, fact table, and bridge table linking procedure and the fact table, the fact table has a primary key, and the bridge has a key composed of the table key of facts and the key to the procedure

Alejandra Tapia Ortega

Posted 2019-08-13T17:25:00.293

Reputation: 1

Answers

0

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!

pinkpanther

Posted 2019-08-13T17:25:00.293

Reputation: 1

Asked: 2019-08-13T17:25:00.293

Viewed: 28 times

Active: 2019-08-15T06:30:41.433