Account Monthly Report
You can use this JSON structure for configuring an Account Monthly report. This JSON contains the details to include a chart in the report.
Required Editions
Available in: Lightning Experience Available in: Enterprise and Unlimited Editions where Consumer Goods Cloud is enabled |
Example
{
"datasources": [
{
"name": "AccountMonthlyMeasures"
}
],
"attributes": {
"productdimension": [
{
"name": "category",
"label": "Category"
},
{
"name": "subcategory",
"label": "Sub Category"
},
{
"name": "brand",
"label": "Brand"
},
{
"name": "product",
"label": "Product"
}
],
"timedimension": [
{
"name": "Total"
},
{
"name": "Year"
},
{
"name": "HalfYear"
},
{
"name": "Quarter"
},
{
"name": "Month"
}
],
"kpidimension": [
{
"name": "Volume Analysis",
"type": "filter",
"measures": [
{
"name": "APEffectiveBase",
"label": "Planned Base"
},
{
"name": "RTRPlanIncrVolume",
"label": "Planned Incr. Volume"
},
{
"name": "RTRAPPlanTotalVolume",
"label": "Planned Total Volume"
},
{
"name": "APLETotalVolumeResult",
"label": "LE Total Volume"
},
{
"name": "APActualizedTotalVolume",
"label": "Actual Total Volume"
}
]
},
{
"name": "Spend Analysis",
"type": "filter",
"measures": [
{
"name": "RTRAPPlanNonPromoSpend",
"label": "Planned Non Promo Spend"
},
{
"name": "RTRAPPlanFixProSpend",
"label": "Planned Fixed Spend"
},
{
"name": "ProPlanVarPromoSpend",
"label": "Planned Variable Spend"
},
{
"name": "RTRAPPlanTotalProSpend",
"label": "Planned Total Promo Spend"
},
{
"name": "APLENPSResult",
"label": "LE Non Promo Spend"
},
{
"name": "APLETotalPromoSpendResult",
"label": "LE Total Promo Spend"
},
{
"name": "APActualNonPromoSpend",
"label": "Actual Non Promo Spend"
},
{
"name": "APActualTotalPromoSpend",
"label": "Actual Total Promo Spend"
}
]
},
{
"name": "Latest Estimate",
"type": "filter",
"measures": [
{
"name": "APLETotalVolumeResult",
"label": "LE Volume"
},
{
"name": "APLEGrossRevResult",
"label": "LE Gross Revenue"
},
{
"name": "APLENPSResult",
"label": "LE Non Promo Spend"
},
{
"name": "APLETotalPromoSpendResult",
"label": "LE Promo Spend"
},
{
"name": "APLENetRevResult",
"label": "LE Net Revenue"
},
{
"name": "APLETotalProfitResult",
"label": "LE Gross Profit"
},
{
"name": "RTRAPLEProfitMargin",
"label": "LE Profit Margin"
},
{
"name": "RTRAPLEROI",
"label": "LE ROI"
},
{
"name": "RTRAPPlanVsLYVolume",
"label": "Plan vs PY Vol"
}
]
},
{
"name": "Target Analysis",
"type": "filter",
"measures": [
{
"name": "APTargetVolume",
"label": "Target Volume"
},
{
"name": "APTargetRevenue",
"label": "Target Revenue"
}
]
},
{
"name": "ScoreCard1",
"type": "scorecard",
"measures": [
{
"name": "RTRAPPlanTotalVolume",
"label": "Planned Volume"
},
{
"name": "RTRAPPlanGrossRev",
"label": "Planned Gross Revenue"
},
{
"name": "RTRAPPlanNonPromoSpend",
"label": "Planned Non Promo Spend"
},
{
"name": "RTRAPPlanTotalProSpend",
"label": "Planned Spend"
},
{
"name": "RTRAPPlanNetRevenue",
"label": "Planned Net Revenue"
},
{
"name": "RTRAPPlanGrossProfit",
"label": "Planned Gross Profit"
},
{
"name": "RTRAPPlanProfitMargin",
"label": "Planned Profit Margin"
},
{
"name": "RTRAPPlanROI",
"label": "Planned ROI"
},
{
"name": "APLETotalVolumeResult",
"label": "LE Volume"
},
{
"name": "APLEGrossRevResult",
"label": "LE Gross Revenue"
},
{
"name": "APLENPSResult",
"label": "LE Non Promo Spend"
},
{
"name": "APLETotalPromoSpendResult",
"label": "LE Promo Spend"
},
{
"name": "APLENetRevResult",
"label": "LE Net Revenue"
},
{
"name": "APLETotalProfitResult",
"label": "LE Gross Profit"
},
{
"name": "RTRAPLEProfitMargin",
"label": "LE Profit Margin"
},
{
"name": "RTRAPLEROI",
"label": "LE ROI"
},
{
"name": "APActualizedTotalVolume",
"label": "Actual Total Volume"
},
{
"name": "APActualGrossRevResult",
"label": "Actual Gross Revenue"
},
{
"name": "APActualNonPromoSpend",
"label": "Actual Non Promo Spend"
},
{
"name": "APActualTotalPromoSpend",
"label": "Actual Total Promo Spend"
},
{
"name": "APActualNetRevenue",
"label": "Actual Net Revenue"
},
{
"name": "APActualGrossProfit",
"label": "Actual Gross Profit"
},
{
"name": "RTRAPActualProfitMargin",
"label": "Actual Profit Margin"
},
{
"name": "RTRAPActualROI",
"label": "Actual ROI"
},
{
"name": "APPlanvsTargetVolume",
"label": "Plan vs Target Volume"
},
{
"name": "APLEVolumevsTargetResult",
"label": "LE Volume vs Target Result"
},
{
"name": "APTargetVolume",
"label": "APTargetVolume"
},
{
"name": "RTRAPPlanVsLYVolume",
"label": "RTRAPPlanVsLYVolume"
}
]
}
]
},
"filters": [
{
"label": "Period",
"type": "periodmonth",
"name": "periodmonth"
},
{
"type": "multiselect",
"name": "accountsfids",
"label": "Accounts",
"source": "PlanAccounts",
"required": true
},
{
"type": "multiselect",
"label": "Categories",
"level": "category",
"name": "productsfids",
"source": "Products",
"required": true
},
{
"type": "multiselect",
"label": "Promotion Template",
"name": "promo_templatesfid",
"source": "PromotionTemplate",
"required": true
},
{
"type": "multiselect",
"name": "promo_phase",
"label": "Promotion Phase",
"source": "PromotionPhase",
"defaultValue": [
"Planning"
]
},
{
"type": "singleselect",
"name": "productlevel",
"label": "Lowest Product Level",
"source": "ProductDimension"
},
{
"type": "singleselect",
"name": "kpigroup",
"label": "KPI Set",
"source": "KPIGroup"
}
],
"uimapping": {
"Gauge1": {
"KPIGroup": "ScoreCard1",
"value": "RTRAPPlanTotalVolume",
"minValue": 0,
"maxValue": "APTargetVolume",
"distributiontype": "equal",
"distributionvalue": 4
},
"Gauge2": {
"KPIGroup": "ScoreCard1",
"value": "APLETotalVolumeResult",
"minValue": 0,
"maxValue": "APTargetVolume",
"distributiontype": "equal",
"distributionvalue": 10
},
"Gauge3": {
"KPIGroup": "ScoreCard1",
"value": "RTRAPPlanVsLYVolume",
"minValue": -5,
"maxValue": 5,
"distributiontype": "equal",
"distributionvalue": 5
},
"Gauge4": {
"KPIGroup": "ScoreCard1",
"value": "RTRAPPlanProfitMargin",
"minValue": 0,
"maxValue": 75,
"distributiontype": "equal",
"distributionvalue": 10
},
"Gauge5": {
"KPIGroup": "ScoreCard1",
"value": "RTRAPLEProfitMargin",
"minValue": 0,
"maxValue": 75,
"distributiontype": "equal",
"distributionvalue": 5
},
"Gauge6": {
"KPIGroup": "ScoreCard1",
"value": "RTRAPLEROI",
"minValue": 0,
"maxValue": 500,
"distributiontype": "equal",
"distributionvalue": 5
},
"FlatList": {
"rowdims": [
"productdimension",
"kpidimension"
],
"coldims": [
"timedimension"
],
"grouping": {
"rows": [
[
"category",
"subcategory",
"brand"
]
],
"cols": [
[
"Total"
],
[
"Month"
]
]
},
"layout": {
"configuration": [
{
"rowtypefilter": [
0,
1,
2,
3,
4,
5
],
"columns": [
{
"label": [
"Product"
],
"values": [
"productdimension.category",
"productdimension.subcategory",
"productdimension.brand",
"productdimension.id"
],
"format": [
"string",
"string",
"string",
"string"
],
"style": {
"width": "200px"
},
"mode": "hierarchy",
"fixed": true,
"coltype": "attribute"
},
{
"label": [
"Measure"
],
"values": [
"kpidimension"
],
"format": [
"string"
],
"style": {
"width": "200px"
},
"mode": "value",
"fixed": true,
"coltype": "attribute"
},
{
"format": [
"number"
],
"style": {
"width": "120px"
},
"mode": "value",
"fixed": false,
"coltype": "value"
}
]
}
],
"rowstyles": {
"group1": {
"bgColor": "lightgrey",
"fontStyle": "400"
},
"group2": {
"bgColor": "darkgrey",
"fontStyle": "600"
},
"group3": {
"bgColor": "grey",
"fontColor": "white",
"fontStyle": "600"
}
}
}
}
}
}Did this article solve your issue?
Let us know so we can improve!
