Spotfire Client: Error when adding realations between tables "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 and 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 |
                    |    |
                    -----


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    |
                |        |
                ------