Profitability and Cost Management

Get Involved. Join the Conversation.

Topic

    Parmit Choudhury
    Filters are not working on Rules for Attributes and UDA
    Topic posted October 23, 2019 by Parmit ChoudhuryGreen Ribbon: 100+ Points, tagged Allocations, PCM, Rule Sets, Rules 
    27 Views, 2 Comments
    Title:
    Filters are not working on Rules for Attributes and UDA
    Summary:
    Filters are not working on Rules for Attributes and UDA
    Content:

    Hi,

    It appears that when we use filters in Rules for Attributes and UDA the rule fails during run.

    One of our  attribute dimension has three members. We have tagged the attributes to different Entities. In the Source tab of the Rule we have selected a parent of an alternate  hierarchy for Entity which has the all the level 0 members are shared members. We are then trying to put the filter with a specific attribute member to select only those entities which have the attribute tagged. But its not taking the attribute value while running the rule.

    We are getting the below error/warning -

    Warning while running rule: Filter defined on Source selections is resulting zero members for dimension ''***', Rule ''YYY''. Ignoring Calculation For this rule.  

    The rule is not working for UDA also when we try to filter with UDA Value.

    Any help will be appreciated.

    Best Regards

    Comment

     

    • Alecsandra Mlynarzek

      Hi Parmit, 

      We've used filters successfully on both UDAs as well as Attribute dimensions so before I venture an answer, let me see if I understand your issue correctly: you have assigned attributes to base level members of the Entity dimension. In the Source tab of a rule you are applying an attribute filter to Entities in an alternate hierarchy (shared members structure) and it does not work in the sense that it is throwing this warning that you posted. 

      So the warning says there are no members in your selection if you apply the filter criteria. Is the attribute = to a value or <> to a value? And are all your members in that section of the hierarchy associated with the attribute in your filter criteria or only some of them?

      Do you mind sharing with us the actual filter criteria setup (a screenshot would work) so we can ask more questions and assist you with the issue? 

      Kind regards,

      Alecs

      • Parmit Choudhury

        Hi Alecsandra,

        You are right, we have assigned attributes to base level members of the Entity dimension. In the Source tab of a rule we are applying an attribute filter to Entities in an alternate hierarchy (shared members structure) and it does not work in the sense that it is throwing this warning that I have posted.  The filter is working though when we  apply filter on the primary /base hierarchy but it doesn't work on the shared/alternate hierarchy. Please find the filter setup attached.

        Best Regards

        Parmit