Risk Management

Get Involved. Join the Conversation.

Topic

    Rajendra Verma
    Regarding Grouping when using Similar Filter
    Topic posted March 28, 2019 by Rajendra VermaGreen Ribbon: 100+ Points, tagged Advanced Controls, Risk Management 
    112 Views, 1 Comment
    Title:
    Regarding Grouping when using Similar Filter
    Summary:
    Explains the usage of “Generate Results for Similar Groups” option for Similar Filter
    Content:

    Scenario:

    Model Logic with following filters:
    1. UDO Approved PO totals.Supplier ID(1) Equals UDO Approved PO totals.Supplier ID(1)
    2. Similar filter Equals[UDO Approved PO totals.Supplier ID(1)] Created Date]  Similar Within (+/-) Days 30

    Output shows following:

    UDO Approved PO totals.Supplier Name UDO Approved PO totals.Number(1) UDO Approved PO totals.Created Date UDO Approved PO totals.Supplier ID(1) Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] Group Grouping Value
    Art Of Food 2110002487 10/30/2018 20945 10/30/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 10/30/2018
    Art Of Food 2110002488 10/30/2018 20945 10/30/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 10/30/2018
    Art Of Food 2110002567 11/27/2018 20945 10/30/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 10/30/2018
    Art Of Food 2110002568 11/27/2018 20945 10/30/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 10/30/2018
    Art Of Food 2110002567 11/27/2018 20945 12/14/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 12/14/2018
    Art Of Food 2110002568 11/27/2018 20945 12/14/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 12/14/2018
    Art Of Food 2110002631 12/14/2018 20945 12/14/2018 Equals[UDO Approved PO totals.Supplier ID(1)] AND Similar[Equals[UDO Approved PO totals.Supplier ID(1)].Created Date] 20945 AND 12/14/2018

     

    Question:

    Record value for row 3 and 4 and same as row 5 and 6, and they belong to two different group. Why?
     

    Answer:

    This is expected behavior if Similar filter has “Generate Results for Similar Groups” checked under Advanced options. If requirement is to have records included into only single group then have the “Generate Results for Similar Groups” unchecked under Advanced options for Similar filter in TCG Model logic.

    Comment