When removing a series, ensure that you do not remove any base series (e.g., Series1, Series2, etc.) before removing dependent join series. Removing a base series before removing the reference of that series in the join will also result in the removal of that join series.
In the Pricefx Agents, a join series is defined on top of existing base series. The join:
-
Has its own alias (e.g.,
j1). -
References base series aliases (for example,
s1,s2, etc.) in the following places:-
joinDimensions – maps dimensions from each source series.
-
measures – expressions such as
s1.price - s2.price,s1_margin / s2_margin, and similar calculations.
-
If you delete a base series that is referenced by a join, the join definition would point to a non-existent source (for example, still referring to s2), which would break the Agent configuration.
To prevent this inconsistency and avoid runtime errors, the Agent is designed so that when a base series participating in a join is removed, the corresponding join series is automatically removed as well.
Implications
-
Removing a base series will, by design, also remove any join series that depends on it.
-
If you want to preserve the join series, you must take one of the following actions before deleting the base series:
-
Modify the join definition to remove references to the base series (by updating Join Dimensions and Measures), or
-
Duplicate or replace the base series and reconfigure the join to reference the new series before deleting the original one.
-