Circular reference through dataset

[Francois]

I do not know how we obtained this … but I have a circular reference between two tables using datasets.

Everything happens in the same group called “HR”

This table called “Employees” in database “HR management” seems to be based on a dataset called “Full Employee View”

Dataset “Full Employee View” is in a database called “Ressources Shared Information”.

.

It is related to a table named “Ressources”

But this table is based on a dataset called “HR Shared information”

which happens to be from my first table

I do not know what was done to get this, I am not the one using it.
I think I can just delete one of the dataset to get back a proper source (my first table).
But I can not imagine how we can end up with this circular reference ?

Some idea to try to avoid to get there ? I do not know what happens if I try to sync the first table (which is not done because people think it is the source).

[rdb]

@Francois

But I can not imagine how we can end up with this circular reference ?

You can create CDS from any view of an imported CDS. In some circumstances, this may be sensible, for example if the 2nd CDS is based on a filtered view of the imported CDS.

Yet, you can also create circular references if you do not pay attention.

(Kudos to the person who did this. This is a first as far as I know.)

@Francois

I think I can just delete one of the dataset to get back a proper source (my first table).

Correct. If you delete a CDS, all tables in which you imported the CDS will become regular tables.

[Francois]

Thanks for the answer … I will clean it !
But I still not understand how this can happen.
Being based on a dataset for a table is something which is set a its creation. It can not be done afterward ?
So when I create Table 1 from dataset A coming from some view of Table 2, Table 2 can not be already related to a dataset coming from Table 1 because Table 1 does not yet exist …

[rdb]

@Francois

Being based on a dataset for a table is something which is set a its creation. It can not be done afterward ?

This is not correct. A table can be linked to a CDS after its creation.

[Francois]

Thanks !
I was not aware of this option. Now I understand how we got this situation … setting a circular reference seems quite easy in fact. I will play on sandbox bases to test how bad it can be !