2 Replies Latest reply: Mar 29, 2012 12:51 PM by 910769 RSS

    RWDerived Property fomula

    910769
      Trying to dynamically setup datastorage property for one of the hiers in DRM, where all parent will be tagged as NeverShare and any level zero member in the primary hier will be a store and level zero under alternate hier will be set to Shared. Not able to figure out to embed all these pieces together.

      The below formulas works as expected when worked seperately. Need some assistance on how I can combine these two.

      Primary hier

      If(And(Equals(integer,PropValue(Children),0),Equals(String,PropValue(CFHierValue),PRIM)),Store,Never Share)

      Alt hier

      If(Or(Equals(integer,PropValue(Children),0),Equals(String,PropValue(CFHierValue),ALT)),Share,Never Share)

      Thank you
        • 1. Re: RWDerived Property fomula
          DRMRocks
          Here is a pseudo code, give a try and let me know if you see any issues,

          IF ( AND(
          NODE EXIST and NODE IN HIER(PRIM),
          GreaterThan(NumChildWith(Or(NodeIsLeaf(),not(Nodeisleaf()),1)
          ))),NeverShare,
          IF ( AND(
          NODE EXIST and NODE IN HIER(ALT)
          GreaterThan(NumChildWith(Or(NodeIsLeaf(),not(Nodeisleaf()),1)
          ))),Never Share,
          IF ( NODE IN HIER (PRIM),STORE,
          IF ( NODE IN HIER (ALT),SHARE,),)))

          Thanks,
          Murali
          • 2. Re: RWDerived Property fomula
            910769
            Got it resolved with an alternative formula.

            Thank you for your help anyways.