Is it possible to have a conditional survivorship rule based on a SemQL filter (akin to the filter on privileges)?
F
Fathia Jama
started a topic
over 2 years ago
We have an entity that is only partially sourced (ID matched). The records that are authored directly in Semarchy end up with an override strategy that is not adequate.
Best Answer
F
Fathia Jama
said
over 2 years ago
in such complex situations, you should select the Consolidation StrategyCustom Ranking and write this kind of Ranking Expression
case PublisherID when 'PUB1' then
case when <your_conditions_for_actual_publishers> then 1 else 2 end
when 'PUB2' then
case when <your_conditions_for_authored_masters> then 1 else 2 end
else 3 end ASC, <your_other_conditions_that_could_apply_to_both> ASC
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
in such complex situations, you should select the Consolidation StrategyCustom Ranking and write this kind of Ranking Expression
case PublisherID when 'PUB1' then
case when <your_conditions_for_actual_publishers> then 1 else 2 end
when 'PUB2' then
case when <your_conditions_for_authored_masters> then 1 else 2 end
else 3 end ASC, <your_other_conditions_that_could_apply_to_both> ASC
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
Fathia Jama
We have an entity that is only partially sourced (ID matched). The records that are authored directly in Semarchy end up with an override strategy that is not adequate.
in such complex situations, you should select the Consolidation Strategy Custom Ranking and write this kind of Ranking Expression
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
Fathia Jama
in such complex situations, you should select the Consolidation Strategy Custom Ranking and write this kind of Ranking Expression
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 274 topics