cgcloud__KPI_Set_KPI_Definition__c Junction object between KPI Definition and KPI Definition Set. This object is available in API version 54.0 and later.
Supported Calls
create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()
Fields
Name
Type : stringProperties : Autonumber, Defaulted on create, Filter, idLookup, SortDescription : ID of the record owner.
cgcloud__KPI_Definition__c
Type : reference
Properties : Create, Filter, Group, Sort
Description : Parent object (KPI Definition).
This is a relationship field.
Relationship Name : cgcloud__KPI_Definition__r
Relationship Type : Master-detail
Refers To : cgcloud__KPI_Definition__c (Detail object)
cgcloud__KPI_Description__c
Type : string
Properties : Filter, Nillable, Sort
Description : Description of the KPI definition that’s shown when selecting the Adjustment KPI from lookup.
This is a calculated field.
Formula :
1 cgcloud__KPI_Definition__r.cgcloud__Description__c
cgcloud__KPI_Set__c
Type : reference
Properties : Create, Filter, Group, Sort
Description : Parent object (Calculation Configuration).
This is a relationship field.
Relationship Name : cgcloud__KPI_Set__r
Relationship Type : Master-detail
Refers To : cgcloud__KPI_Set__c (Master object)
cgcloud__KPI_Subsets__c
Type : multipicklist
Properties : Create, Defaulted on create, Filter, Nillable, Restricted picklist, Update
Description : ID of the KPI subset.
Default value : Planning
Possible values :
AdjustmentBaselineManagement—Baseline ManagementBrokerFinanceMidLevelPlanning—Mid Level PlanningMonitoringPlanningPromoUIPromotionScenarios—Promotion ScenariosRetailerSPCSPCLumpSumSPCPRVPC
cgcloud__KPI_Tactic_Dependent__c
Type : boolean
Properties : Defaulted on create, Filter, Group, Sort
Description : Field value that’s updated based on KPI_Definition.Aggregation_Skipped_Dimesnions.
This is a calculated field.
Formula :
1 OR(ISPICKVAL(cgcloud__KPI_Definition__r.cgcloud__Scope__c , 2 "promotiontactic"),ISPICKVAL(cgcloud__KPI_Definition__r.cgcloud__Scope__c , "paymenttactic"))
cgcloud__Manual_Input_Copy_Mode__c
Type : picklist
Properties : Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description : Defines whether manual input is copied over to the target promotion.
Possible values :
cgcloud__Record_Link__c
Type : string
Properties : Filter, Nillable, Sort
Description : Link to the KpiSetKpiDefinition Record for related custom lists.
This is a calculated field.
Formula :
1 HYPERLINK("/" &Id, $Label.cgcloud__record_link, "_top")
cgcloud__Sort_Subset_PSP__c
Type : doubleProperties : Create, Filter, Nillable, Sort, UpdateDescription : Sorts KPI subsets with the Promotion scenario.
cgcloud__Sort__c
Type : doubleProperties : Create, Filter, Sort, UpdateDescription : Sorts the KPI definition in the KPI set.
cgcloud__Storage_Options_Subset__c
Type : picklist
Properties : Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description : Define subsets of KPIs that can be calculated in various writeback steps.
Possible values :
basic—Basicbusinessplan—Business Plan
cgcloud__Unique_Editable_Measure_Id__c
Type : stringProperties : Create, Filter, Group, Nillable, Sort, UpdateDescription : Ensures that the editable measure codes per KPI set are unique. This means that no two editable KPIs create manual entries for the same measure code.
cgcloud__Unique_KPI_Id__c
Type : stringProperties : Create, Filter, Group, Nillable, Sort, UpdateDescription : Ensures that a KPI is assigned only once to a KPI set.
cgcloud__Unique_KPI_Id_for_Sort__c
Type : stringProperties : Create, Filter, Group, Nillable, Sort, UpdateDescription : Ensures that the KPI sort order is total (for two KPIs k1 within the set, either k1 < k2 or k2 < k1 is true; otherwise k1 = k2).
cgcloud__Unique_Storage_Options_Id__c
Type : stringProperties : Create, Filter, Group, Nillable, Sort, UpdateDescription : Ensures that the storage measure codes per KPI set are unique. This means that no two writeback KPIs create writebacks for the same measure code.
Associated Objects
Associated Objects
This object has these associated objects. If the API version isn’t specified, they are available in the same API versions as this object. Otherwise, they are available in the specified API version and later.
j