SAP Commissions – Usage Metrics(Payee Compliance Check)

Dear All,

In this article, I will walk through the steps you need to know when Payee Compliance exceeds your Contracted Value. Warning message in Commission UI will be displayed if license is exceeded…

Usage Metrics Documentation Link

Payee Compliance Terms:

Active Payee :

An active payee is defined as a position, with a participant that is associated to a plan at either the Title or Position level that is currently active as of today

Licensed Payee Count :

The number of Licensed payees related to your tenant

How to check Usage Metrics (Active Payee License) :

Usage Metrics page can be accessed in the Administration section.

Go to SAP Commissions > Security > Usage Metrics

The dialog shows the current Active Payee Count and the Licensed Payee Count.

Through SAP Commissions UI

Through SAP Commissions RestAPI

Licensed Payee Count :

https://<tenantid>.callidusondemand.com/CallidusPortal/services/MetricsService/getLicensedPayeeCount/TCMP
Content-Type: application/json
Accept: application/json
Authorization: Basic @{{authtoken1}}

Active Payee :

GET https://<tenantid>.callidusondemand.com/CallidusPortal/services/MetricsService/getActivePayeeCount
Content-Type: application/json
Accept: application/json
Authorization: Basic @{{authtoken1}}

Through Database Explorer (Oracle)

Licensed Payee Count :

select * from CS_INSTALLEDPRODUCT where tenantid='<tenantid>' 
AND PRODUCTID='TCMP';

Active Payee :

SELECT DISTINCT Count(*)
  FROM (SELECT DISTINCT t.ruleelementownerseq
          FROM CS_PLANASSIGNABLE pa, cs_position t
         WHERE     pa.tenantid = 'TENANT-ID'   ---- Tenant Id
               AND pa.removedate > SYSDATE
               AND pa.effectiveenddate > SYSDATE
               AND pa.RULEELEMENTOWNERSEQ IN
                        (SELECT RULEELEMENTOWNERSEQ
                           FROM cs_title po
                          WHERE     po.tenantid = 'TENANT-ID'   ---- Tenant Id
                                AND po.removedate > SYSDATE
                                AND po.effectiveenddate > SYSDATE)
               AND PA.PLANSEQ IS NOT NULL
               AND t.tenantid = 'TENANT-ID'   ---- Tenant Id
               AND t.removedate > SYSDATE
               AND t.effectiveenddate > SYSDATE
               AND PA.RULEELEMENTOWNERSEQ = T.TITLESEQ
               AND t.payeeseq is not null               
        UNION ALL       
   SELECT DISTINCT ruleelementownerseq
          FROM CS_PLANASSIGNABLE pa
         WHERE     pa.tenantid = 'TENANT-ID'   ---- Tenant Id
               AND pa.removedate > SYSDATE
               AND pa.effectiveenddate > SYSDATE
               AND RULEELEMENTOWNERSEQ IN
                        (SELECT RULEELEMENTOWNERSEQ
                           FROM cs_position po
                          WHERE     po.tenantid = 'TENANT-ID'    ---- Tenant Id
                                AND po.removedate > SYSDATE
                                AND po.effectiveenddate > SYSDATE 
                                AND po.payeeseq is not null)
               AND PA.PLANSEQ IS NOT NULL)

Through Database Explorer (HANA)

SELECT DISTINCT Count(*)
  FROM (SELECT DISTINCT t.ruleelementownerseq
          FROM tcmp.CS_PLANASSIGNABLE pa, tcmp.cs_position t
         WHERE     pa.tenantid = 'TENANT-ID'   ---- Tenant Id
               AND pa.removedate > NOW()
               AND pa.effectiveenddate > NOW()
               AND pa.RULEELEMENTOWNERSEQ IN
                        (SELECT RULEELEMENTOWNERSEQ
                           FROM tcmp.cs_title po
                          WHERE     po.tenantid = 'TENANT-ID'   ---- Tenant Id
                                AND po.removedate > NOW()
                                AND po.effectiveenddate > NOW())
               AND PA.PLANSEQ IS NOT NULL
               AND t.tenantid = 'TENANT-ID'   ---- Tenant Id
               AND t.removedate > NOW()
               AND t.effectiveenddate > NOW()
               AND PA.RULEELEMENTOWNERSEQ = T.TITLESEQ
               AND t.payeeseq is not null               
        UNION ALL       
   SELECT DISTINCT ruleelementownerseq
          FROM tcmp.CS_PLANASSIGNABLE pa
         WHERE     pa.tenantid = 'TENANT-ID'   ---- Tenant Id
               AND pa.removedate > NOW()
               AND pa.effectiveenddate > NOW()
               AND RULEELEMENTOWNERSEQ IN
                        (SELECT RULEELEMENTOWNERSEQ
                           FROM tcmp.cs_position po
                          WHERE     po.tenantid = 'TENANT-ID'    ---- Tenant Id
                                AND po.removedate > NOW()
                                AND po.effectiveenddate > NOW()
                                AND po.payeeseq is not null)
               AND PA.PLANSEQ IS NOT NULL)

License violation message:

An error message is displayed in Commissions UI if the license is violated. (i.e. when Active Payee count is greater than or equal to the Licensed Payee count).

Payee License % Action Notification Message   0 – 80%

• Perform a clean up
• End-Date Payees

          No   >80 – 90%

• Engage Account Executive (AE)
• Clean up should be initiated

          Yes   >90 – 100%

• Contact SAP Technical Support team
• Clean up should be completed
• AE should be engaged

         Yes   >100%

• Contact SAP Technical Support team
• AE’s engagement is required

Sample Warning Message (Shown in Pipeline workspace) :

“You have 1497 active payees. This is within 90% of you contracted value of 1500. You will not be able to add new positions or run a calculation if you exceed your contracted value. Please contact CallidusCloud Support on how to resolve this issue.”