Loyalty Management - Update of Dynamic Attribute

[Former Member]

Hi All,

I have another question in reference to the calculation of the value for a dynamic attribute.

Calculation should be as:

    Actual Value of Dynamic Attribute Z_DEMO_DYNAMIC_ATTRIBUTE

+  Loyalty Points

=  Total Value -> by this value dynamic attribute has to be updated (the formula I use in the version can be seen in the Attachment)

The problem is, that right now the logic just takes the newst value and does not take into account the value of the dynamic attribute that already has been calculated before.

How do I have to change the formula?

BR/

Oliver

[Former Member · Accepted solution]

Hello Oliver

As for me your formula configuratiom is right. I have add an example of my formula for updating dynattr. With LP it is working too. And i think order of variables in formula doesn't matter

I have 2 suggestions.

Maybe you have some other rule which is affect dynattr value? Or it is some cache issue. Whatever please post log of some member activity for updating dynattr . Maybe we will figure out cause of the problem.

Regards, EL

[Former Member · Accepted solution]

Hi Evgeny, thank you very much for your effort. Yes it seems like your reward rule is of some structure like my one. In the following there is the log of the only member activity that was created:

Processed at 04/06/2013 09:01:37

  Member Activity (Generic).Category = 'ACCRUAL'

  Member Activity (Generic).Type = 'PRODUCT'

  Member Activity (Generic).Card Guid = ''

  Member Activity (Generic).Activity Guid = '0010001210'

  Member Activity (Generic).Membership Guid = '10000317'

  Member Activity (Generic).Member Guid = '8000001374'

  Member Activity (Generic).Partner = ''

  Member Activity (Generic).Program Guid = 'Z_LOY_DEMO_2'

  Member Activity (Specific).Campaign = ''

  Member Activity (Specific).Loyalty Points = '110.00'

  Member Activity (Specific).Z_DEMO_DYNAMIC_ATTRIBUT = ''

Reward rule group: Sales Order; Version: 003

  Applicable: Yes

  Reward rule: Sales Order Accrual; Version: 001

      Condition met: Row #1

      Action: Earn Points

          Earned points 110,00, Redeemable, Loyalty Points expiring on 05.06.2013

      Condition met: Row #1

      Action: Update Attribute 1

          Attribute has been updated from to

      Condition met: Row #1

      Action: Update Attribute 2

          Attribute has been updated from to

  Reward rule: Update Dyn. Attribute Z_DEMO_DYNAMIC_ATT; Version: 001

      Condition met: Row #1

      Action: Update Attribute 1

          Attribute Z_DEMO_DYNAMIC_ATTRIBUTE has been updated from to 110

  Reward rule: Redemption Rule; Version: 001

    No condition met or BRF rule not executed

  Reward rule: Campaign Rule (dont touch); Version: 001

    No condition met or BRF rule not executed

  Reward rule: Complaint Resolution; Version: 001

    No condition met or BRF rule not executed

  Reward rule: Return Points; Version: 001

    No condition met or BRF rule not executed

  Reward rule: Complaint Redeem Points; Version: 001

    No condition met or BRF rule not executed

  Reward rule: Tier Level Change (Automatic); Version: 002

    No condition met or BRF rule not executed

  Combinability: All

  Reward rule group: Complaint; Version: 002

  Applicable: No

  Reward rule group: Accrual Points Manually; Version: 001

  Applicable: No

  Reward rule group: Deduct Points Manually; Version: 002

  Applicable: No

  Reward rule group: Tier Transition; Version: 001

  Applicable: No

Processing completed

Execution time for log point FETCH_RRG_CONTEXT: 189 ms

Execution time for log point FETCH_RRG_CONTEXT_DATA: 21431 ms

Execution time for log point EXECUTE_RRG_BRF_RULES: 154089 ms

Execution time for log point FETCH_RRL_CONTEXT: 466 ms

Execution time for log point FETCH_RRL_CONTEXT_DATA: 4440 ms

Execution time for log point EXECUTE_RRL_BRF_RULES: 240567 ms

Execution time for log point APPLY_COMBINABILITY_RULES: 165 ms

Execution time for log point EXECUTE_ACTIONS: 174117 ms

Execution time for log point SAVE_ACTION_TRANSACTIONS: 351146 ms

Execution server: nbg-bd-cd7_CD7_00; Work process ID (WPID): 2135400

BR/

Oliver

[Former Member · Accepted solution]

Oliver

As we see in the log

  Member Activity (Specific).Z_DEMO_DYNAMIC_ATTRIBUT = ''

DA holds no values in your MA. Try to analyze this issue. Are you sure that this attribute hold any valuse?

Regards, EL

[Former Member · Accepted solution]

Hi Evgeny, thank you again for looking over my problem.

I just found out that the ID for the dynamic attributes which can be defined in customizing under:

Customer Relationship Management->Marketing->Loyalty Management->Loyalty Programs->Define Dynamic Attributes can have the length 40.

But the condition that can be defined in customizing under: CRM Cross-Application Components->Rule Builder->Define Rule Policy Types can have lenght 30 only. So in other words, my attribute ID was to long.

No I have changed the dynamic attribute ID to Z_DEMO_DYNAMIC_ATTRI and changed all rules and conditions and refreshed the cache. But still the value stays initial (see log)

Do you know where I can make a debug to check why value for dynamic attribute is still initial? For the membership with ID 10000319 in table LOYD_MSH_MSDYN a value for attribute exists (see attachment 1).

Latest version of Log is:

Processed at 04/06/2013 11:24:03

  Member Activity (Generic).Category = 'ACCRUAL'

  Member Activity (Generic).Type = 'PRODUCT'

  Member Activity (Generic).Card Guid = ''

  Member Activity (Generic).Activity Guid = '0010001220'

  Member Activity (Generic).Membership Guid = '10000319'

  Member Activity (Generic).Member Guid = '8000001376'

  Member Activity (Generic).Partner = ''

  Member Activity (Generic).Program Guid = 'Z_DEMO_LOY_PROG'

  Member Activity (Specific).Campaign = ''

  Member Activity (Specific).Loyalty Points = '220.00'

  Member Activity (Specific).Z_DEMO_DYNAMIC_ATTRI = ''

Reward rule group: Sales Order Accrual; Version: 001

  Applicable: Yes

  Reward rule: Sales Order Accrual; Version: 001

      Condition met: Row #1

      Action: Earn Points

          Earned points 220,00, Redeemable, Loyalty Points expiring on 05.06.2013

      Condition met: Row #1

      Action: Update Attribute 1

          Attribute Z_DEMO_DYNAMIC_ATTRI has been updated from to 220

  Combinability: All

Reward rule group: Automatic Tier Level Change; Version: 001

  Applicable: Yes

  Reward rule: Automatic Change Tier Level; Version: 001

    No condition met or BRF rule not executed

  Combinability: All

Processing completed

Execution time for log point FETCH_RRG_CONTEXT: 186 ms

Execution time for log point FETCH_RRG_CONTEXT_DATA: 4878 ms

Execution time for log point EXECUTE_RRG_BRF_RULES: 2640581 ms

Execution time for log point FETCH_RRL_CONTEXT: 543 ms

Execution time for log point FETCH_RRL_CONTEXT_DATA: 4174 ms

Execution time for log point EXECUTE_RRL_BRF_RULES: 2991268 ms

Execution time for log point APPLY_COMBINABILITY_RULES: 135 ms

Execution time for log point EXECUTE_ACTIONS: 35219 ms

Execution time for log point SAVE_ACTION_TRANSACTIONS: 59943 ms

Execution server: nbg-bd-cd7_CD7_00; Work process ID (WPID): 7880

[Former Member · Accepted solution]

Solution: The error was, that I have tried to use the condition attribute from the condition group Member Activity (Specific) but the correct attribute had to be included in the condition group MSHDYN (Membership (Dynamic)).

Thank you for your help...

[Former Member · Accepted solution]

I'm glad that you resolve your issue. Feel free to ask more. I will help with all i've got

[Former Member · Accepted solution]

Hello, I have a question, Where do you see the log?

Did you activate logging for the table LOYD_MSH_MSDYN?

Thanks much!

Hanlie