Warning message: "The relation could not be created since it leads to cyclic dependencies between data table."

Warning message: "The relation could not be created since it leads to cyclic dependencies between data table."

In the layout below, A, B, C and D represent four different data tables. Table A is related to Table B and Table D. Table B is related to Table C. If you try to set up a relation between Table C and Table D, it becomes a cyclic dependency. Spotfire does not allow this. Multiple relations are allowed, but there can only be one single path between two tables. The warning message "The relation could not be created since it leads to cyclic dependencies between data table" will be thrown.


                    -----
                    |    |
                    | A |
                    |    |
                    -----
                    /   \
                   /     \
                  /       \
              -----       -----
              |    |       |     |
              | D |       | B |
              |    |       |     |
              -----       -----
                  \       /
                   \     /
                    \   /
                    -----
                    |    |
                    | C |
                    |    |
                    -----

Symptoms:
Trying to add a data table relationship results in the warning message: "The relation could not be created since it leads to cyclic dependencies between data table."

Cause:
This is "as designed" behavior. Its purpose is to prevent cyclic dependencies among data tables. Create a copy of the table "D" and have the original table "A" connect to the original table "D".  Then have the table "C" connect to the table "Copy of D".


                    -----
                    |    |
                    | A |
                    |    |
                    -----
                    /   \
                   /     \
                  /       \
              -----       -----
              |    |       |     |
              | D |       | B |
              |    |       |     |
              -----       -----
                          /
                         /
                        /
                    -----
                    |    |
                    | C |
                    |    |
                    -----
                      /
                     /
                    /
                ------
                |        |
                |Copy|
                | of    |
                | D    |
                |        |
                ------