Skip to content

Instantly share code, notes, and snippets.

@nsdevaraj

nsdevaraj/t04.csv

Created April 12, 2023 10:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nsdevaraj/a10938454f1dd3e3b4997885a0a7a4f0 to your computer and use it in GitHub Desktop.
Save nsdevaraj/a10938454f1dd3e3b4997885a0a7a4f0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
t04.csv
Account Level 2 Value Column Name Value
Software revenue PY 265
Software revenue AC 278
Software revenue AC - PY 13
Software revenue (AC - PY)% 0.049056603773584916
Consulting revenue PY 121
Consulting revenue AC 128
Consulting revenue AC - PY 7
Consulting revenue (AC - PY)% 0.05785123966942149
Revenue PY 473
Revenue AC 496
Revenue AC - PY 23
Revenue (AC - PY)% 0.048625792811839326
Cost of sales PY -122
Cost of sales AC -128
Cost of sales AC - PY -6
Cost of sales (AC - PY)% -0.04918032786885246
Selling and general administrative expenses PY -97
Selling and general administrative expenses AC -102
Selling and general administrative expenses AC - PY -5
Selling and general administrative expenses (AC - PY)% -0.05154639175257732
Gross Profit PY 351
Gross Profit AC 368
Gross Profit AC - PY 17
Gross Profit (AC - PY)% 0.04843304843304843
Research and development expenses PY -78
Research and development expenses AC -91
Research and development expenses AC - PY -13
Research and development expenses (AC - PY)% -0.16666666666666663
Support revenue PY 87
Support revenue AC 90
Support revenue AC - PY 3
Support revenue (AC - PY)% 0.034482758620689655
Other financial income,net PY 34
Other financial income,net AC 30
Other financial income,net AC - PY -4
Other financial income,net (AC - PY)% -0.1176470588235294
Income from continuing operations before tax PY 232
Income from continuing operations before tax AC 222
Income from continuing operations before tax AC - PY -10
Income from continuing operations before tax (AC - PY)% -0.04310344827586207
Income tax expenses PY -23
Income tax expenses AC -27
Income tax expenses AC - PY -4
Income tax expenses (AC - PY)% -0.17391304347826086
Other operating income PY 33
Other operating income AC 27
Other operating income AC - PY -6
Other operating income (AC - PY)% -0.18181818181818182
Income from continuing operations PY 209
Income from continuing operations AC 195
Income from continuing operations AC - PY -14
Income from continuing operations (AC - PY)% -0.06698564593301436
Net income PY 215
Net income AC 220
Net income AC - PY 5
Net income (AC - PY)% 0.023255813953488372
Income from discontinued operations PY 6
Income from discontinued operations AC 25
Income from discontinued operations AC - PY 19
Income from discontinued operations (AC - PY)% 3.166666666666666
Other operating expenses PY -11
Other operating expenses AC -10
Other operating expenses AC - PY 1
Other operating expenses (AC - PY)% 0.09090909090909091
Raw
t04.json
{
"version": 2,
"config": {
"sorting": [],
"pagination": {
"enable": false,
"pageRowCount": 10,
"autoRowCount": "hide",
"view": "browser",
"pageNo": 0,
"paginationHeight": 20,
"currentPageNumber": 0
},
"headerOption": {
"showHeaderIndicator": true,
"showHeader": true
},
"enableSign": false,
"isEditMode": true,
"columnTitleConfigs": [],
"overRideScaleFactor": true,
"interactivity": {},
"compareHeader": {
"left": {
"label": "",
"values": []
},
"right": {
"label": "",
"values": []
}
},
"tableState": {
"rowHierarchyLevel": {},
"compareMeasure": null,
"expandCollapseIcon": "plusMinusSquare",
"columnExpandCollapseIcon": "arrows",
"columnHierarchyLevel": {},
"headerHeight": 25
},
"measureBasedHeader": false,
"isReadModeConfigModified": false,
"layout": "HIERARCHICAL",
"rowExpandCollapseOptions": {
"rows": {},
"expandTillDescendant": {},
"gridState": null,
"levelStates": [],
"maxLevelExpanded": null
},
"chartTitleOption": {
"show": true,
"primaryTitleText": "",
"customTitleHeight": 22,
"measurescale": "",
"currencyValue": "",
"titlContainer": {
"display": "flex",
"flexDirection": "column",
"height": "22px"
},
"primaryTitle": {
"color": "#ffffff",
"fontSize": "14px",
"fontWeight": "normal",
"fontStyle": "normal",
"paddingRight": "5px",
"lineHeight": "22px"
},
"secondaryTitle": {
"color": "#ffffff",
"fontSize": "14px",
"fontWeight": "normal",
"fontStyle": "normal",
"paddingRight": "5px",
"lineHeight": "22px",
"order": 2
},
"secondaryTitleFont": {
"fontWeight": "normal"
},
"titleMeasure": {
"color": "#ffffff",
"fontSize": "14px",
"fontWeight": "normal",
"fontStyle": "normal",
"lineHeight": "22px",
"order": 1
},
"unitScale": {
"fontWeight": "bold"
},
"measureHeading": []
},
"chartCustomTitle": {
"secondaryTitle": "",
"measureTitle": "",
"primaryTitle": "",
"customTitle": {
"elements": [
{
"type": "DEFAULT_TITLE",
"id": "left-col",
"position": {
"top": 0,
"left": 0
},
"dimension": {
"width": "613.5",
"height": "30"
},
"layout": {
"x": 0,
"y": 0,
"w": 32,
"h": 3,
"i": "left-col",
"static": false
},
"content": "<p>SoftCons International Inc. </p><p><b>Profit and loss statement</b> in mUSD </p><p><b>2014</b> PY,AC</p>",
"verticalAlign": "MIDDLE",
"align": "left",
"background": null,
"containerBackground": null,
"border": [],
"borderColor": "",
"borderRadius": "0px",
"borderWidth": "1px",
"shadowColor": "",
"shadowPosition": "",
"marginTop": "0px",
"marginRight": "0px",
"marginBottom": "0px",
"marginLeft": "0px"
}
],
"layout": "left-col",
"layoutType": "CUSTOM",
"containerMeta": {
"width": 1241,
"height": 45
}
},
"customTitleHeight": 45
},
"breakConfig": {
"sectionBreak": {
"enabled": false,
"breakBy": ""
},
"pageBreak": {
"rowBreakBy": "",
"columnBreakBy": ""
}
},
"miscellaneous": {
"enableFooter": false,
"showInfoRiverLogo": false,
"footerUrl": "https://inforiver.com/",
"footerText": "inforiver.com",
"showTooltip": true,
"isUserChangedFooter": false
},
"globalStyles": {
"fontFamily": "Segoe-UI, wf_segoe-ui_normal, helvetica, arial, sans-serif",
"fontSize": "10",
"fontWeight": "normal",
"fontStyle": "normal",
"varianceBarFont": 12,
"headerFormat": false,
"headerHeight": 30,
"headerFontSize": "14px",
"headerFontColor": "#212121",
"rotateLabels": {
"enabled": false,
"angle": 0
},
"headerLabelOrient": "initial",
"isHeightUpdatedManually": false,
"isFontFamilyChanged": false,
"textColor": "#212121",
"rowHeight": 18,
"hierarchyfontWeight": "bold",
"hierarchyFontStyle": "normal",
"columnHierarchyFontWeight": "bold",
"columnHierarchyFontStyle": "normal",
"subTotalFontWeight": "semiBold",
"showRowLabelEditor": true
},
"notes": {
"show": true,
"displayAnnotations": "view",
"autoFit": true,
"annotations": [
{
"id": "fVKgcOcRHaeAGZSETLbAKPSBRERJMAQC",
"relativeCoord": [
0,
-2
],
"comment": "Software 2013 : mUSD 265 Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa",
"unFormattedText": "Software 2013 : mUSD 265 Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 0,
"createdAt": 1652776764692,
"dateTime": 1652776814956,
"updatedAt": 1652776814956,
"isAudit": false,
"rowId": "Software__revenue",
"colId": "2014_X_Sum__T03_A__PL__U3VtKFQwM19BLlBMKQ__",
"comments": [],
"auditId": null,
"isColumnComments": false,
"hidden": false,
"formattedText": "Software 2013 : mUSD 265 Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa"
},
{
"id": "BMLUMgXQfGcDFYIFcQcPCWbPTTCHaUeU",
"relativeCoord": [
0,
-2
],
"comment": "Support 2013: mUSD 87: Satoque penatibus dolor sit amet consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturi.",
"unFormattedText": "Support 2013: mUSD 87: Satoque penatibus dolor sit amet consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturi.",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 1,
"createdAt": 1652776882831,
"dateTime": 1652776882831,
"updatedAt": 1652776882831,
"isAudit": false,
"rowId": "Support__revenue",
"colId": "2014_X_Sum__T03_A__PL__U3VtKFQwM19BLlBMKQ__",
"comments": [],
"auditId": null,
"isColumnComments": false
},
{
"id": "GObRSSDRAKTYCXZGYIFLcZKZKUIBTCUR",
"relativeCoord": [
0,
-2
],
"comment": "Consulting 2013: mUSD Sit amet, consectetuer adipiscing elit.",
"unFormattedText": "Consulting 2013: mUSD Sit amet, consectetuer adipiscing elit.",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 2,
"createdAt": 1652776987752,
"dateTime": 1652776987752,
"updatedAt": 1652776987752,
"isAudit": false,
"rowId": "Consulting__revenue",
"colId": "2014_X_Sum__T03_A__PL__U3VtKFQwM19BLlBMKQ__",
"comments": [],
"auditId": null,
"isColumnComments": false
},
{
"id": "FKNSHGNYDXSHKADEYggOLHbSNJDeRONG",
"relativeCoord": [
0,
-2
],
"comment": "Other financial income 2012: mUSD-55 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor",
"unFormattedText": "Other financial income 2012: mUSD-55 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 3,
"createdAt": 1652777037026,
"dateTime": 1652777037026,
"updatedAt": 1652777037026,
"isAudit": false,
"rowId": "Other__financial__income__net",
"colId": "2012_X_Sum__T03_A__AC__U3VtKFQwM19BLkFDKQ__",
"comments": [],
"auditId": null,
"isColumnComments": false
},
{
"id": "QBXXSGZZRCMVZCeIONFHVaVNUZCabDcK",
"relativeCoord": [
9,
0
],
"comment": "Net income 2015: mUSD 529 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum SOC is natoque penatibus et magnis dis penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor Aenean",
"unFormattedText": "Net income 2015: mUSD 529 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum SOC is natoque penatibus et magnis dis penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor Aenean",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 4,
"createdAt": 1652777093636,
"dateTime": 1652777093636,
"updatedAt": 1652777093636,
"isAudit": false,
"rowId": "CAL_ROW11",
"colId": "2015_X_Sum__T03_A__FC__U3VtKFQwM19BLkZDKQ__",
"comments": [],
"auditId": null,
"isColumnComments": false,
"scale": [
0,
0
],
"isCoordChanged": true
},
{
"id": "OLMXMGUXRIPBRXDYNOcNJcVHLIXeNUCQ",
"relativeCoord": [
118,
0
],
"comment": "Software: mUSD +13 Lorem ipsum dolor sit amet, consectetuer adipi scing elit. Aenean commodo ligula eget dolor. Aenean massa",
"unFormattedText": "Software: mUSD +13 Lorem ipsum dolor sit amet, consectetuer adipi scing elit. Aenean commodo ligula eget dolor. Aenean massa",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 0,
"createdAt": 1652784622996,
"dateTime": 1652784622996,
"updatedAt": 1652784622996,
"isAudit": false,
"rowId": "Software__revenue",
"colId": "Grand__Total_X_delPY",
"comments": [],
"auditId": null,
"isColumnComments": false,
"scale": [
0,
0
],
"isCoordChanged": true
},
{
"id": "ZeHOANgQJCAePQWQbWNUWBGARgbAPfDZ",
"relativeCoord": [
118,
0
],
"comment": "Cost of sales: mUSD +6 Satoque penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturi ",
"unFormattedText": "Cost of sales: mUSD +6 Satoque penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturi ",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 1,
"createdAt": 1652784652666,
"dateTime": 1652790579764,
"updatedAt": 1652790579764,
"isAudit": false,
"rowId": "Cost__of__sales",
"colId": "Grand__Total_X_delPY",
"comments": [],
"auditId": null,
"isColumnComments": false,
"scale": [
0,
0
],
"isCoordChanged": true,
"hidden": false,
"formattedText": "Cost of sales: mUSD +6 Satoque penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturi "
},
{
"id": "cASGGYBWDMccDAeKWSVgBgKdYOQfUBCU",
"relativeCoord": [
118,
0
],
"comment": " R&D expenses: mUSD +13 Sit amet, consectetuer adipiscing elit, eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis penatibus dolor sit amet, consectetuer adipiscing elit. Aenean com",
"unFormattedText": " R&D expenses: mUSD +13 Sit amet, consectetuer adipiscing elit, eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis penatibus dolor sit amet, consectetuer adipiscing elit. Aenean com",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 2,
"createdAt": 1652784684537,
"dateTime": 1652784684537,
"updatedAt": 1652784684537,
"isAudit": false,
"rowId": "Research__and__development__expenses",
"colId": "Grand__Total_X_delPY",
"comments": [],
"auditId": null,
"isColumnComments": false,
"scale": [
0,
0
],
"isCoordChanged": true
},
{
"id": "ZEcJMALRVcMQaBbNeALaaIgKaQLAXZEe",
"relativeCoord": [
98,
0
],
"comment": "SG&A: mUSD +5 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. ",
"unFormattedText": "SG&A: mUSD +5 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. ",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 3,
"createdAt": 1652784773556,
"dateTime": 1652784805898,
"updatedAt": 1652784805898,
"isAudit": false,
"rowId": "Selling__and__general__administrative__expenses",
"colId": "Grand__Total_X_delPY",
"comments": [],
"auditId": null,
"isColumnComments": false,
"hidden": false,
"formattedText": "SG&A: mUSD +5 penatibus dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. ",
"scale": [
0,
0
],
"isCoordChanged": true
},
{
"id": "MAGEfPaFZXKJFgfDFdGEQYUOIGPWABaK",
"relativeCoord": [
118,
2.20001220703125
],
"comment": "Net income: mUSD +5 dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. ",
"unFormattedText": "<p>Net income: mUSD +5 dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. </p>",
"size": [
100,
200
],
"iconColor": "rgba(0, 120, 212, 0.7)",
"iconPosition": [
"left",
"center"
],
"iconFontColor": "#fff",
"ratio": 1,
"index": 4,
"createdAt": 1652784873911,
"dateTime": 1681264835997,
"updatedAt": 1681264835997,
"isAudit": false,
"rowId": "CAL_ROW11",
"colId": "Grand__Total_X_delPY",
"comments": [],
"auditId": null,
"isColumnComments": false,
"hidden": false,
"formattedText": "Net income: mUSD +5 dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. ",
"scale": [
0,
0
],
"isCoordChanged": true,
"childRowMembersHash": null
}
],
"columnAnnotations": [],
"indicatorType": "numbered",
"indicatorPosition": "default",
"persistProperty": {
"iconColor": "rgba(0, 120, 212, 0.7)"
},
"showFootnote": true,
"rowLevelComments": false,
"enableReply": true,
"annotationNote": "grid",
"annotationHeight": 15,
"annotationColumnCount": 2,
"indicatorSize": 12,
"footNoteHeight": "25",
"footNoteColumn": 2,
"showTimestamp": true,
"showUsername": true,
"defaultReference": false
},
"themeColors": {
"showTable": false,
"valueColor": "",
"invertVarianceColor": false,
"enableVarianceColor": false,
"positiveColor": "#8EB900",
"negativeColor": "#FF000A",
"chartTheme": "trafficlights",
"chartThemeTable": false,
"themeType": "trafficlights",
"previousThemeType": "trafficlights",
"tableThemeType": false,
"highContrast": null,
"enableRowHover": "off",
"rowHoverColor": "#f5f5f5",
"rowHoverTextColor": "#212121",
"rowOddColor": "#ffffff",
"rowEvenColor": "#f5f5f5",
"axisColor": "",
"lineStyleRecentColor": "#cccccc"
},
"rowReorder": {
"enabled": false,
"rowOrderConfig": {
"Grand__Total": [
"Software__revenue",
"Support__revenue",
"Consulting__revenue",
"CAL_ROW1",
"Cost__of__sales",
"CAL_ROW5",
"Research__and__development__expenses",
"Selling__and__general__administrative__expenses",
"Other__operating__income",
"Other__operating__expenses",
"Other__financial__income__net",
"CAL_ROW7",
"Income__tax__expenses",
"CAL_ROW9",
"Income__from__discontinued__operations",
"CAL_ROW11"
]
},
"rowOrderConfigMeta": {
"Grand__Total": [
"CAL_ROW11"
]
}
},
"columnHierarchySort": {},
"compareMesLabelAlign": false,
"gridStyles": {
"majorGridLines": "single",
"minorGridLines": "solid",
"rowGrandTotalLine": "on",
"rowGrandTotalLineHeight": 1,
"compactSplitLine": false,
"compactSplitLineColor": "#A6A6A6",
"chartSpacing": true,
"topSpace": 0,
"bottomSpace": 0,
"leftSpace": 0,
"rightSpace": 0,
"titleAndChartSpace": 4,
"indentSpacing": 10,
"columnSpacing": "auto",
"columnSpacingValue": 5,
"majorGridColor": "#000000",
"minorGridColor": "#E6E6E6",
"gridBackground": "#FFFFFF",
"lineStyleColor": "#666666",
"lineStyleFormat": "solid",
"enableCategoryLabelColor": false,
"categoryLabelColor": "#DDDDDD",
"showVAHighlight": true,
"isLevelIndent": false,
"showExpandCollapse": false,
"horizontalMinorGridLines": "off",
"verticalMinorGridLines": "solid",
"verticalMinorGridColor": "#E6E6E6",
"horizontalMinorGridColor": "#E6E6E6"
},
"groupInColumn": true,
"numberFormatting": {
"enabled": true,
"formatType": "ibcs",
"enablePrefixAsUnit": true,
"ibcsformat": true,
"thousandSeperator": " ",
"decimalSeperator": ".",
"noOfDecimal": 0,
"noOfDecimalPercent": 2,
"prefix": "",
"suffix": "",
"scalingFactor": "autoFixed",
"showScalingUnit": false,
"customizeScalingLabel": false,
"scalingTextType": "medium",
"thousands": "k",
"billions": "b",
"millions": "m",
"trillion": "t",
"thousandsMediumText": "in k",
"millionsMediumText": "in m",
"billionsMediumText": "in b",
"trillionMediumText": "in t",
"thousandsFullText": "in Thousands",
"billionsFullText": "in Billions",
"millionsFullText": "in Millions",
"trillionFullText": "in Trillions",
"crores": "c",
"lakhs": "l",
"semanticFormatting": false,
"positiveValueColor": "#8DB901",
"positiveValueFormat": "x",
"negativeValueColor": "#FB0209",
"negativeValueFormat": "-x",
"showNegativeSign": false,
"showPercentageSymbol": false,
"showZeroAs": "zero",
"customZeroText": "",
"showNullAs": "blank",
"customNullText": "",
"tooltipDecimal": "1"
},
"calculatedColumns": [],
"calculatedColumnMeta": {
"newColumnIndex": 12
},
"totalUtility": {
"rowGrandTotal": false,
"rowGrandTotalPosition": "clear",
"rowSubTotalPosition": "below",
"columnGrandTotal": false,
"columnGrandTotalPosition": "clear",
"columnSubTotalPosition": "clear",
"summaryTotal": false
},
"dynamicRowConfig": [
{
"label": "Revenue",
"id": 1,
"formula": "R_Support__revenue+R_Software__revenue+R_Consulting__revenue",
"type": 1,
"previousRowId": "Cost__of__sales",
"version": 2,
"parentId": "Grand__Total",
"pcbToRow": null,
"isTemplateFormatting": false,
"disabled": false,
"includeToTotal": true,
"includeInChart": false,
"enableAllocateParent": true,
"allocateOperation": "by_weight",
"spreadByRowId": null,
"templatePosition": "auto",
"isUpdated": true
},
{
"label": "Gross Profit",
"id": 5,
"formula": "R_CAL_ROW1-R_Cost__of__sales",
"type": 1,
"previousRowId": "Research__and__development__expenses",
"version": 2,
"parentId": "Grand__Total",
"pcbToRow": null,
"isTemplateFormatting": false,
"disabled": false,
"includeToTotal": true,
"includeInChart": false,
"enableAllocateParent": true,
"allocateOperation": "by_weight",
"spreadByRowId": null,
"templatePosition": "auto",
"isUpdated": true
},
{
"label": "Income from continuing operations before tax",
"id": 7,
"formula": "R_CAL_ROW5-R_Research__and__development__expenses-R_Selling__and__general__administrative__expenses+R_Other__operating__income-R_Other__operating__expenses+R_Other__financial__income__net",
"type": 1,
"previousRowId": "Income__tax__expenses",
"version": 2,
"parentId": "Grand__Total",
"pcbToRow": null,
"isTemplateFormatting": false,
"disabled": false,
"includeToTotal": true,
"includeInChart": false,
"enableAllocateParent": true,
"allocateOperation": "by_weight",
"spreadByRowId": null,
"templatePosition": "auto",
"isUpdated": true
},
{
"label": "Income from continuing operations",
"id": 9,
"formula": "R_CAL_ROW7-R_Income__tax__expenses",
"type": 1,
"previousRowId": "Income__from__discontinued__operations",
"version": 2,
"parentId": "Grand__Total",
"pcbToRow": null,
"isTemplateFormatting": false,
"disabled": false,
"includeToTotal": true,
"includeInChart": false,
"enableAllocateParent": true,
"allocateOperation": "by_weight",
"spreadByRowId": null,
"templatePosition": "auto",
"isUpdated": true
},
{
"label": "Net income",
"id": 11,
"formula": "R_CAL_ROW9+R_Income__from__discontinued__operations",
"type": 1,
"previousRowId": "Income__from__discontinued__operations",
"version": 2,
"parentId": "Grand__Total",
"pcbToRow": null,
"isTemplateFormatting": false,
"disabled": false,
"includeToTotal": true,
"includeInChart": false,
"enableAllocateParent": true,
"allocateOperation": "by_weight",
"spreadByRowId": null,
"templatePosition": "auto",
"isUpdated": true
}
],
"enableWordWrap": true,
"rowCellFormatting": {},
"cfProps": {
"enabled": true,
"rules": [
{
"enabled": false,
"highlightedMeasure": "delPY_PER",
"name": "delPY_PER-1358614097",
"ruleType": "rule",
"displayName": "ΔPY% <= 0",
"basedOn": "PY",
"excludeRowTotal": false,
"excludeColumnTotal": false,
"ruleFor": "both",
"columnRuleType": "default",
"classificationPosition": "left",
"colorScaleApplyTo": "seq",
"isIconGroupAltered": false,
"autoFontColor": true,
"colorOnly": false,
"invertColor": false,
"colorScaleColorFor": "font",
"colorScheme": {
"selectedColorScheme": "Blues",
"numberOfRanges": 5,
"colors": [
"#d0e1f2",
"#94c4df",
"#4a98c9",
"#1764ab",
"#08306b"
],
"minColor": "red",
"middleColor": "blue",
"maxColor": "green"
},
"classificationType": "icon",
"enableCustom": false,
"isTextGroupAltered": false,
"targetValues": [],
"targetValueType": "percent",
"iconGroupValues": [],
"textGroupValues": [],
"rankingBuckets": [],
"rankingBucketsValueType": "percent",
"iconGroupValueType": "percent",
"textGroupValueType": "percent",
"textColorFor": "font",
"ratingIcons": [
"cross",
"alert",
"tick"
],
"conditionalOperator": "or",
"conditions": [
{
"name": "Condition 0",
"basedOn": "delPY_PER",
"conditionType": "singleMeasure",
"valueType": "static",
"comparisonMeasure": "delPY_PER",
"operator": "<=",
"comparisonValue": 0,
"from": 0,
"to": 100,
"aggregationType": "includes",
"calculationType1": "value",
"calculationValue1": 0,
"calculationMeasure1": "PY",
"calculationOperator": "+",
"calculationType2": "measure",
"calculationValue2": 100,
"calculationMeasure2": "PY",
"dimension": "",
"dimensionMembers": [],
"comparisonText": "",
"count": 10,
"fromMeasure": "PY",
"toMeasure": "PY"
}
],
"bold": false,
"italic": false,
"underline": false,
"underlineColor": "#000000",
"applyTextColor": true,
"color": "#FF4400",
"applyBackgroundColor": false,
"background": "#F5F5F5",
"isIconPresent": false,
"iconPosition": "left",
"iconColor": "#e66c37",
"icon": "chevron-up",
"iconType": "icon",
"isCustomIcon": false,
"customIconBase64Value": "",
"customIconName": "",
"text": "",
"textDetailPosition": "none",
"shapeCount": 5,
"shapeColor": "#e66c37",
"ratingDetailPosition": "none",
"lineColor": "#666666",
"lineStyle": 1,
"iconGroupName": "accept",
"textGroupName": "segmentation"
},
{
"enabled": true,
"highlightedMeasure": "delPL_PER",
"name": "delPL_PER302489235",
"ruleType": "rule",
"displayName": "ΔPL% <= -10",
"basedOn": "PY",
"excludeRowTotal": false,
"excludeColumnTotal": false,
"ruleFor": "both",
"columnRuleType": "default",
"classificationPosition": "left",
"colorScaleApplyTo": "seq",
"isIconGroupAltered": false,
"autoFontColor": true,
"colorOnly": false,
"invertColor": false,
"colorScaleColorFor": "font",
"colorScheme": {
"selectedColorScheme": "Blues",
"numberOfRanges": 5,
"colors": [
"#d0e1f2",
"#94c4df",
"#4a98c9",
"#1764ab",
"#08306b"
],
"minColor": "red",
"middleColor": "blue",
"maxColor": "green"
},
"classificationType": "icon",
"enableCustom": false,
"isTextGroupAltered": false,
"targetValues": [],
"targetValueType": "percent",
"iconGroupValues": [],
"textGroupValues": [],
"rankingBuckets": [],
"rankingBucketsValueType": "percent",
"iconGroupValueType": "percent",
"textGroupValueType": "percent",
"textColorFor": "font",
"ratingIcons": [
"cross",
"alert",
"tick"
],
"conditionalOperator": "or",
"conditions": [
{
"name": "Condition 0",
"basedOn": "delPL_PER",
"conditionType": "singleMeasure",
"valueType": "static",
"comparisonMeasure": "delPL_PER",
"operator": "<=",
"comparisonValue": 0,
"from": 0,
"to": 100,
"aggregationType": "includes",
"calculationType1": "value",
"calculationValue1": 0,
"calculationMeasure1": "PY",
"calculationOperator": "+",
"calculationType2": "measure",
"calculationValue2": 100,
"calculationMeasure2": "PY",
"dimension": "",
"dimensionMembers": [],
"comparisonText": "",
"count": 10,
"fromMeasure": "PY",
"toMeasure": "PY"
}
],
"bold": false,
"italic": false,
"underline": false,
"underlineColor": "#000000",
"applyTextColor": true,
"color": "#FF4400",
"applyBackgroundColor": false,
"background": "#F5F5F5",
"isIconPresent": false,
"iconPosition": "left",
"iconColor": "#e66c37",
"icon": "chevron-up",
"iconType": "icon",
"isCustomIcon": false,
"customIconBase64Value": "",
"customIconName": "",
"text": "",
"textDetailPosition": "none",
"shapeCount": 5,
"shapeColor": "#e66c37",
"ratingDetailPosition": "none",
"lineColor": "#666666",
"lineStyle": 1,
"iconGroupName": "accept",
"textGroupName": "segmentation"
},
{
"enabled": true,
"highlightedMeasure": "delFC_PER",
"name": "delFC_PER1075604900",
"ruleType": "rule",
"displayName": "ΔFC% <= -10",
"basedOn": "PY",
"excludeRowTotal": false,
"excludeColumnTotal": false,
"ruleFor": "both",
"columnRuleType": "default",
"classificationPosition": "left",
"colorScaleApplyTo": "seq",
"isIconGroupAltered": false,
"autoFontColor": true,
"colorOnly": false,
"invertColor": false,
"colorScaleColorFor": "font",
"colorScheme": {
"selectedColorScheme": "Blues",
"numberOfRanges": 5,
"colors": [
"#d0e1f2",
"#94c4df",
"#4a98c9",
"#1764ab",
"#08306b"
],
"minColor": "red",
"middleColor": "blue",
"maxColor": "green"
},
"classificationType": "icon",
"enableCustom": false,
"isTextGroupAltered": false,
"targetValues": [],
"targetValueType": "percent",
"iconGroupValues": [],
"textGroupValues": [],
"rankingBuckets": [],
"rankingBucketsValueType": "percent",
"iconGroupValueType": "percent",
"textGroupValueType": "percent",
"textColorFor": "font",
"ratingIcons": [
"cross",
"alert",
"tick"
],
"conditionalOperator": "or",
"conditions": [
{
"name": "Condition 0",
"basedOn": "delFC_PER",
"conditionType": "singleMeasure",
"valueType": "static",
"comparisonMeasure": "delFC_PER",
"operator": "<=",
"comparisonValue": 0,
"from": 0,
"to": 100,
"aggregationType": "includes",
"calculationType1": "value",
"calculationValue1": 0,
"calculationMeasure1": "PY",
"calculationOperator": "+",
"calculationType2": "measure",
"calculationValue2": 100,
"calculationMeasure2": "PY",
"dimension": "",
"dimensionMembers": [],
"comparisonText": "",
"count": 10,
"fromMeasure": "PY",
"toMeasure": "PY"
}
],
"bold": false,
"italic": false,
"underline": false,
"underlineColor": "#000000",
"applyTextColor": true,
"color": "#FF4400",
"applyBackgroundColor": false,
"background": "#F5F5F5",
"isIconPresent": false,
"iconPosition": "left",
"iconColor": "#e66c37",
"icon": "chevron-up",
"iconType": "icon",
"isCustomIcon": false,
"customIconBase64Value": "",
"customIconName": "",
"text": "",
"textDetailPosition": "none",
"shapeCount": 5,
"shapeColor": "#e66c37",
"ratingDetailPosition": "none",
"lineColor": "#666666",
"lineStyle": 1,
"iconGroupName": "accept",
"textGroupName": "segmentation"
},
{
"enabled": true,
"highlightedMeasure": "delPYPL_PER",
"name": "delPYPL_PER-340318089",
"ruleType": "rule",
"displayName": "PL - PY % <= -10",
"basedOn": "PY",
"excludeRowTotal": false,
"excludeColumnTotal": false,
"ruleFor": "both",
"columnRuleType": "default",
"classificationPosition": "left",
"colorScaleApplyTo": "seq",
"isIconGroupAltered": false,
"autoFontColor": true,
"colorOnly": false,
"invertColor": false,
"colorScaleColorFor": "font",
"colorScheme": {
"selectedColorScheme": "Blues",
"numberOfRanges": 5,
"colors": [
"#d0e1f2",
"#94c4df",
"#4a98c9",
"#1764ab",
"#08306b"
],
"minColor": "red",
"middleColor": "blue",
"maxColor": "green"
},
"classificationType": "icon",
"enableCustom": false,
"isTextGroupAltered": false,
"targetValues": [],
"targetValueType": "percent",
"iconGroupValues": [],
"textGroupValues": [],
"rankingBuckets": [],
"rankingBucketsValueType": "percent",
"iconGroupValueType": "percent",
"textGroupValueType": "percent",
"textColorFor": "font",
"ratingIcons": [
"cross",
"alert",
"tick"
],
"conditionalOperator": "or",
"conditions": [
{
"name": "Condition 0",
"basedOn": "delPYPL_PER",
"conditionType": "singleMeasure",
"valueType": "static",
"comparisonMeasure": "delPYPL_PER",
"operator": "<=",
"comparisonValue": 0,
"from": 0,
"to": 100,
"aggregationType": "includes",
"calculationType1": "value",
"calculationValue1": 0,
"calculationMeasure1": "PY",
"calculationOperator": "+",
"calculationType2": "measure",
"calculationValue2": 100,
"calculationMeasure2": "PY",
"dimension": "",
"dimensionMembers": [],
"comparisonText": "",
"count": 10,
"fromMeasure": "PY",
"toMeasure": "PY"
}
],
"bold": false,
"italic": false,
"underline": false,
"underlineColor": "#000000",
"applyTextColor": true,
"color": "#FF4400",
"applyBackgroundColor": false,
"background": "#F5F5F5",
"isIconPresent": false,
"iconPosition": "left",
"iconColor": "#e66c37",
"icon": "chevron-up",
"iconType": "icon",
"isCustomIcon": false,
"customIconBase64Value": "",
"customIconName": "",
"text": "",
"textDetailPosition": "none",
"shapeCount": 5,
"shapeColor": "#e66c37",
"ratingDetailPosition": "none",
"lineColor": "#666666",
"lineStyle": 1,
"iconGroupName": "accept",
"textGroupName": "segmentation"
},
{
"enabled": true,
"highlightedMeasure": "delFCPY_PER",
"name": "delFCPY_PER1138093097",
"ruleType": "rule",
"displayName": "FC - PY % <= -10",
"basedOn": "PY",
"excludeRowTotal": false,
"excludeColumnTotal": false,
"ruleFor": "both",
"columnRuleType": "default",
"classificationPosition": "left",
"colorScaleApplyTo": "seq",
"isIconGroupAltered": false,
"autoFontColor": true,
"colorOnly": false,
"invertColor": false,
"colorScaleColorFor": "font",
"colorScheme": {
"selectedColorScheme": "Blues",
"numberOfRanges": 5,
"colors": [
"#d0e1f2",
"#94c4df",
"#4a98c9",
"#1764ab",
"#08306b"
],
"minColor": "red",
"middleColor": "blue",
"maxColor": "green"
},
"classificationType": "icon",
"enableCustom": false,
"isTextGroupAltered": false,
"targetValues": [],
"targetValueType": "percent",
"iconGroupValues": [],
"textGroupValues": [],
"rankingBuckets": [],
"rankingBucketsValueType": "percent",
"iconGroupValueType": "percent",
"textGroupValueType": "percent",
"textColorFor": "font",
"ratingIcons": [
"cross",
"alert",
"tick"
],
"conditionalOperator": "or",
"conditions": [
{
"name": "Condition 0",
"basedOn": "delFCPY_PER",
"conditionType": "singleMeasure",
"valueType": "static",
"comparisonMeasure": "delFCPY_PER",
"operator": "<=",
"comparisonValue": 0,
"from": 0,
"to": 100,
"aggregationType": "includes",
"calculationType1": "value",
"calculationValue1": 0,
"calculationMeasure1": "PY",
"calculationOperator": "+",
"calculationType2": "measure",
"calculationValue2": 100,
"calculationMeasure2": "PY",
"dimension": "",
"dimensionMembers": [],
"comparisonText": "",
"count": 10,
"fromMeasure": "PY",
"toMeasure": "PY"
}
],
"bold": false,
"italic": false,
"underline": false,
"underlineColor": "#000000",
"applyTextColor": true,
"color": "#FF4400",
"applyBackgroundColor": false,
"background": "#F5F5F5",
"isIconPresent": false,
"iconPosition": "left",
"iconColor": "#e66c37",
"icon": "chevron-up",
"iconType": "icon",
"isCustomIcon": false,
"customIconBase64Value": "",
"customIconName": "",
"text": "",
"textDetailPosition": "none",
"shapeCount": 5,
"shapeColor": "#e66c37",
"ratingDetailPosition": "none",
"lineColor": "#666666",
"lineStyle": 1,
"iconGroupName": "accept",
"textGroupName": "segmentation"
},
{
"enabled": true,
"highlightedMeasure": "delFCPL_PER",
"name": "delFCPL_PER-1413848124",
"ruleType": "rule",
"displayName": "FC - PL % <= -10",
"basedOn": "PY",
"excludeRowTotal": false,
"excludeColumnTotal": false,
"ruleFor": "both",
"columnRuleType": "default",
"classificationPosition": "left",
"colorScaleApplyTo": "seq",
"isIconGroupAltered": false,
"autoFontColor": true,
"colorOnly": false,
"invertColor": false,
"colorScaleColorFor": "font",
"colorScheme": {
"selectedColorScheme": "Blues",
"numberOfRanges": 5,
"colors": [
"#d0e1f2",
"#94c4df",
"#4a98c9",
"#1764ab",
"#08306b"
],
"minColor": "red",
"middleColor": "blue",
"maxColor": "green"
},
"classificationType": "icon",
"enableCustom": false,
"isTextGroupAltered": false,
"targetValues": [],
"targetValueType": "percent",
"iconGroupValues": [],
"textGroupValues": [],
"rankingBuckets": [],
"rankingBucketsValueType": "percent",
"iconGroupValueType": "percent",
"textGroupValueType": "percent",
"textColorFor": "font",
"ratingIcons": [
"cross",
"alert",
"tick"
],
"conditionalOperator": "or",
"conditions": [
{
"name": "Condition 0",
"basedOn": "delFCPL_PER",
"conditionType": "singleMeasure",
"valueType": "static",
"comparisonMeasure": "delFCPL_PER",
"operator": "<=",
"comparisonValue": 0,
"from": 0,
"to": 100,
"aggregationType": "includes",
"calculationType1": "value",
"calculationValue1": 0,
"calculationMeasure1": "PY",
"calculationOperator": "+",
"calculationType2": "measure",
"calculationValue2": 100,
"calculationMeasure2": "PY",
"dimension": "",
"dimensionMembers": [],
"comparisonText": "",
"count": 10,
"fromMeasure": "PY",
"toMeasure": "PY"
}
],
"bold": false,
"italic": false,
"underline": false,
"underlineColor": "#000000",
"applyTextColor": true,
"color": "#FF4400",
"applyBackgroundColor": false,
"background": "#F5F5F5",
"isIconPresent": false,
"iconPosition": "left",
"iconColor": "#e66c37",
"icon": "chevron-up",
"iconType": "icon",
"isCustomIcon": false,
"customIconBase64Value": "",
"customIconName": "",
"text": "",
"textDetailPosition": "none",
"shapeCount": 5,
"shapeColor": "#e66c37",
"ratingDetailPosition": "none",
"lineColor": "#666666",
"lineStyle": 1,
"iconGroupName": "accept",
"textGroupName": "segmentation"
}
],
"lastUpdatedRule": "delPY_PER-1358614097"
},
"kpiExplorerCf": {
"rules": []
},
"columnSelection": false,
"templateConfig": {
"template": "T03",
"type": "ibcs"
},
"isInFocus": false,
"manageMeasures": [
{
"id": "PY",
"label": "PY",
"name": "Sum(T04.PY)",
"order": 0,
"visible": true,
"measureType": "data"
},
{
"label": "AC",
"id": "AC",
"name": "Sum(T04.AC)",
"order": 1,
"visible": true,
"measureType": "data"
},
{
"id": "delPY",
"label": "ΔPY",
"name": "delPY",
"order": 2,
"visible": true,
"measureType": "data"
},
{
"id": "delPY_PER",
"label": "ΔPY%",
"name": "delPY_PER",
"order": 3,
"visible": true,
"measureType": "data"
}
],
"invertRows": {
"valueRow": {
"Cost__of__sales": true,
"Research__and__development__expenses": true,
"Selling__and__general__administrative__expenses": true,
"Other__operating__expenses": true,
"Income__tax__expenses": true
}
},
"resultRows": {
"CAL_ROW1": true,
"CAL_ROW5": true,
"CAL_ROW7": true,
"CAL_ROW9": true,
"CAL_ROW11": true
},
"shouldAggregate": true,
"columnMeta": {
"row_label": {
"width": 256
},
"2012__PL": {
"width": 66
},
"2012__FC": {
"width": 59
},
"2012__AC": {
"width": 66
},
"2012__delPL": {
"width": 66
},
"2012__delPL_PER": {
"width": 59
},
"2012__delFC": {
"width": 74
},
"2012__delFC_PER": {
"width": 59
},
"2013__PL": {
"width": 66
},
"2013__FC": {
"width": 59
},
"2013__AC": {
"width": 66
},
"2013__delPL": {
"width": 66
},
"2013__delPL_PER": {
"width": 59
},
"2013__delFC": {
"width": 66
},
"2013__delFC_PER": {
"width": 59
},
"2014__PL": {
"width": 66
},
"2014__FC": {
"width": 59
},
"2014__AC": {
"width": 66
},
"2014__delPL": {
"width": 66
},
"2014__delPL_PER": {
"width": 59
},
"2014__delFC": {
"width": 66
},
"2014__delFC_PER": {
"width": 59
},
"2015__PL": {
"width": 66
},
"2015__FC": {
"width": 59
},
"2015__AC": {
"width": 59
},
"2015__delPL": {
"width": 66
},
"2015__delPL_PER": {
"width": 59
},
"2015__delFC": {
"width": 66
},
"2015__delFC_PER": {
"width": 59
},
"2012__AC1": {
"width": 59
},
"2013__AC1": {
"width": 59
},
"2014__AC1": {
"width": 59
},
"2015__AC1": {
"width": 66
},
"Grand__Total__AC": {
"width": 59
},
"Grand__Total__AC1": {
"width": 59
},
"Grand__Total__PY": {
"width": 66
},
"Grand__Total__delPY": {},
"Grand__Total__delPY_PER": {}
},
"chartTypes": {
"delPY_PER": "variancepercentage",
"delPY": "waterfall"
},
"gridLineCount": 1,
"measureAggMap": {},
"outliers": {
"enableOutlier": false,
"min": 0,
"max": 0
},
"headerLabelFormat": {},
"sparklineConfig": {},
"displayAllCols": false,
"bulletConfig": {},
"stackedConfig": {},
"dynamicRowIcon": false,
"calcCellIcon": true,
"filter": {
"rules": [],
"combinator": "and",
"not": false
},
"search": {
"category": null,
"searchString": "",
"tokens": []
},
"ranking": {
"rules": [],
"othersLabel": "Others",
"enableOthersSuffix": false,
"enableOthersCount": true,
"showOthers": true
},
"kpiExplorer": {
"showExplorer": false,
"selectedMeasure": "",
"filterValues": {},
"panelWidthMeta": {},
"showKPI": {
"column": {},
"row": {}
},
"sort": {},
"expanded": true,
"timeInterval": [],
"showTimeSlider": true,
"mode": "detailed"
},
"absoluteSort": false,
"absoluteSearch": true,
"invertSettings": "additionMethod",
"enableDrillThrough": false,
"wizardComplete": true,
"expandRowLevel": null,
"aggregationType": "sum",
"varianceInvertColumn": {},
"landingPage": false,
"columnExpandCollapse": {},
"layoutType": "default",
"calculatedCells": [],
"enablePersistFilter": false,
"columnGroupConfig": {},
"alertFilter": [],
"rowHeightsConfig": {
"row": {},
"level": {}
},
"summarySettings": {
"rowLayout": "multi",
"forceMultiLine": false,
"columnCount": 2,
"autoFit": false,
"detailGridHeight": 300,
"detailGridHeightType": "auto",
"detailXPadding": 10,
"detailYPadding": 10,
"detailBreakBy": {
"row": "",
"column": ""
},
"showAggregation": false,
"detailLayout": "table",
"showGroupBorder": true,
"groupBorderGap": 10,
"groupHeaderColor": "#edebe9",
"groupBorderColor": "#cccccc",
"groupBorderThickness": 1,
"summaryHeader": {
"elements": []
},
"summaryFooter": {
"elements": []
},
"summaryGlobalHeader": {
"elements": []
},
"showSummaryHeader": true,
"showSummaryFooter": true,
"showSummaryGlobalHeader": false,
"summaryHeaderHeight": 30,
"summaryFooterHeight": 30,
"summaryGlobalHeaderHeight": 180,
"masterRowExpandCollapseConfig": {},
"multiColumn": {
"enabled": false,
"cols": []
},
"categoryBreak": "none",
"columnSpacing": 10,
"summaryPage": {
"enabled": false,
"position": "hide"
},
"listView": true,
"drillDownData": [],
"syncScroll": true
},
"readViewToolbar": {
"show": true,
"readViewToolbarMode": "minimal",
"selection": false,
"showTooltip": true,
"showSearch": false,
"showReportFilter": true
},
"showChildCount": false,
"showCategorySign": true,
"showCategorySignPositive": false,
"hideResultSign": false,
"subTotalHeight": 10,
"grandTotalHeight": 10,
"exportSettings": {
"exportType": "matrix",
"scaling": "0",
"scaleRatio": -1,
"pageSize": "a4",
"columnWidth": "normal",
"orientation": "l",
"margin": "md",
"logo": {
"filename": "",
"base64": "",
"width": 60,
"height": 30
},
"title": "",
"subTitle": "",
"displaydate": true,
"pageNumber": true,
"pageLabel": "1",
"footerNote": "dynamic",
"displayHeaderFooter": "everyPage",
"fileName": "",
"pdfFont": "inforiversans",
"printApproach": "rowFirst"
},
"exportExcelSettings": {
"exportType": "matrix",
"logo": {
"filename": "",
"base64": "",
"width": 60,
"height": 30
},
"title": "",
"subTitle": "",
"footerNote": "",
"hierarchyView": "visualView",
"includeComments": true,
"fileName": ""
},
"ruler": {
"enabled": false,
"disabled": {
"state": false,
"prevEnabledState": null
},
"activeSummaryGroup": null
},
"recentColors": [
"#cccccc",
"#000000",
"#d9b300",
"#b0b0b0",
"#1a1a1a",
"#8DB901",
"#FB0209"
],
"frequentColors": [],
"formatConfig": {
"row": {
"CAL_ROW1": [
{
"order": 7,
"format": {
"12": [
4
],
"20": "#000000"
}
}
],
"CAL_ROW5": [
{
"order": 8,
"format": {
"12": [
4
],
"20": "#000000"
}
}
],
"CAL_ROW7": [
{
"order": 9,
"format": {
"12": [
4
],
"20": "#000000"
}
}
],
"CAL_ROW9": [
{
"order": 10,
"format": {
"12": [
4
],
"20": "#000000"
}
}
],
"CAL_ROW11": [
{
"order": 11,
"format": {
"12": [
4
],
"20": "#000000"
}
}
],
"Support__revenue": [
{
"order": 12,
"format": {
"12": [
2
],
"20": "#cccccc"
}
}
],
"Consulting__revenue": [
{
"order": 13,
"format": {
"12": [
2
],
"20": "#cccccc"
}
}
],
"Selling__and__general__administrative__expenses": [
{
"order": 14,
"format": {
"12": [
2
],
"20": "#cccccc"
}
}
],
"Other__operating__income": [
{
"order": 15,
"format": {
"12": [
2
],
"20": "#cccccc"
}
}
],
"Other__operating__expenses": [
{
"order": 16,
"format": {
"12": [
2
],
"20": "#cccccc"
}
}
],
"Other__financial__income__net": [
{
"order": 17,
"format": {
"12": [
2
],
"20": "#cccccc"
}
}
]
},
"column": {
"2015__AC": [
{
"order": 0,
"format": {
"15": true
}
}
],
"2012__FC": [
{
"order": 1,
"format": {
"15": true
}
}
],
"2013__FC": [
{
"order": 2,
"format": {
"15": true
}
}
],
"2014__FC": [
{
"order": 3,
"format": {
"15": true
}
}
]
},
"rowDimension": {},
"cell": {},
"measure": {
"delPY_PER": [
{
"order": 4,
"format": {
"21": 2
}
}
],
"delPY": [
{
"order": 5,
"format": {
"25": 2
}
},
{
"order": 6,
"format": {
"23": 2
}
}
]
},
"formatSize": 18
},
"layoutSizes": {
"tableWidth": 75,
"chartWidth": 150,
"labelWidth": 120,
"bulletWidth": 300,
"maximumChartWidth": 200,
"isMaximumChartWidthAllowed": false
},
"pinnedRowIds": [],
"pinnedColIds": [],
"virtualRoleColumnMap": {},
"rowGroupConfig": {},
"columnHierarchyReorder": {
"colOrderConfig": {},
"colOrderConfigMeta": {}
},
"rowLabelMeta": {},
"hiddenRows": [],
"toolbar": {
"currentTab": "Export",
"isPinned": true,
"showTabContent": true,
"showMinimalView": false,
"toolbarTheme": "light",
"showOnHover": false,
"enableHoverToolbar": false,
"readViewPin": true,
"showMinimalTabEditMode": false
},
"warningModal": {
"show": false,
"message": "",
"autoClose": true,
"showLoader": false,
"showClose": true
},
"showGripper": true,
"showComments": true,
"showHeaderFooter": true,
"urlMetaConfig": {
"hasURL": false,
"hasImg": false,
"urlColId": "",
"urlColIndex": null
},
"pbiThemeColor": {
"rowLevelTheme": {
"0": "#118DFF",
"1": "#12239E"
},
"measureLevelTheme": {
"0": "#118DFF",
"1": "#12239E",
"2": "#E66C37",
"3": "#6B007B",
"4": "#E044A7",
"5": "#744EC2",
"6": "#D9B300",
"7": "#D64550",
"8": "#197278",
"9": "#1AAB40",
"10": "#15C6F4"
}
},
"labelColIndex": null,
"hierarchy": {
"raggedHierarchy": true,
"hideBlanks": "vc",
"hideZeros": false,
"unbalancedHierarchy": "off"
},
"totalsDisplay": {
"showSubTotalsAsTable": false,
"showVarSubTotalsAsTable": false,
"showTotalAsTable": true,
"showVarTotalAsTable": false,
"showColumnGTAsTable": true,
"advancedSteppedLayout": false,
"removeSingleChildren": true
},
"rowAutoGroupConfig": {
"ruleName": "none"
},
"chartStyles": {
"variancePin": "square",
"showDataLabel": true,
"isBarOverlap": false
},
"autoFitOptions": {
"autoFit": false,
"lockColumnWidth": false,
"wrapCols": false,
"uniformColumnWidth": {
"enabled": false,
"width": null
}
},
"readViewConfig": {
"home": {
"navigation": true,
"alignment": true,
"style": true,
"number": true,
"chart": true,
"analyze": true,
"notes": true,
"setup": true
},
"advanced": {
"pagelayout": true,
"compare": true,
"cells": true,
"measure": true,
"monitor": true,
"rows": true,
"column": true,
"simulate": true,
"dataInput": true,
"scenario": true
},
"export": {
"pdf": true,
"excel": true,
"visual": true,
"copyToClipboard": true,
"schedule": true,
"writeBack": false
},
"dataEntry": {
"scenario": false,
"audit": false,
"comment": false,
"action": false,
"column": false,
"display": false
},
"advancedTabMenu": {
"rowColumnConfig": true
},
"enterprise": {
"writeBack": true,
"schedule": true,
"layout": true,
"breaks": true,
"table": true,
"reportPlus": true
},
"scenario": {
"scenario": false,
"export": false,
"writeBack": false,
"analyze": false,
"annotate": false,
"monitor": false,
"reset": false,
"modifiedByUser": false
}
},
"totalCustomTitle": {
"grandTotalTitle": "All",
"columnGrandTotalTitle": "Grand Total",
"totalColumnSuffix": "Total",
"steppedSubTotalTitle": "none",
"steppedSubTotalText": "Total",
"splitTotalRowSuffix": "Total"
},
"scaleDelta": {
"height": 0,
"width": 0,
"scale": 1
},
"hideRowChildren": [],
"hideExpandLevel": {},
"commentSettings": {
"rowLevelComments": false,
"expandRowLevelComments": false,
"rollUpComments": true
},
"rulerMeta": {
"width": 20,
"showNumbers": false,
"loading": false
},
"commonRunTimeProps": {
"showBrokenImage": false
},
"hideHeader": {
"hierarchyHeader": false,
"separator": " - "
},
"measureAttributes": {},
"powerBiTheme": {
"isHighContrast": false,
"foreground": null,
"background": null,
"foregroundSelected": null,
"hyperlink": null,
"themeType": null
},
"quickFilter": {
"rules": [],
"combinator": "and",
"not": false
},
"selectionDataNote": {
"enable": true,
"aggregateOption": {
"sum": true,
"avg": true,
"min": false,
"max": false,
"count": true
}
},
"currentThemeType": {
"themeType": "trafficlights"
},
"enableMeasureInRows": false,
"enableMeasureInCols": false,
"quickAccessIcons": {
"exportExcel": true,
"undo": true,
"bestFit": true,
"redo": true,
"writeback": true,
"smartAnalysis": false,
"exportPdf": false,
"rails": true,
"reset": true,
"aggregation": false
},
"columnHierarchyHeader": {},
"customColumnCategory": {
"enable": false,
"categoryItemCount": 12,
"prefix": "Category Item ",
"suffix": ""
},
"showSubtotalLevels": {},
"customInputColumn": {},
"storedColumnTooltip": false,
"diagnose": false,
"viewConfig": {
"views": [],
"selectedView": null,
"showViewSwitcher": true
},
"repeatLevelLabels": {},
"hideEmptyCols": true,
"columnAsTable": {
"dimensionId": null
},
"contextMenu": true,
"emptyRows": {},
"toastSettings": {
"disableToasts": false
},
"storedColumn": {},
"dataReductionRowCount": 7500,
"dataReductionColCount": 4,
"dataReductionSettings": {
"userOverride": true
},
"scenarioSettings": {
"showAllScenarios": false,
"showScenarioTabs": false
},
"simulationSettings": {
"varianceSettings": [],
"showVariance": true,
"showSimulation": true
},
"version": {
"columnAsMeasure": false,
"level": 0
},
"writebackColumnMapping": {
"formValues": {
"datasetId": "",
"workspaceId": "",
"datasetTableName": "",
"datasetKeyColumnName": "",
"renamedWBIdColumn": "",
"mappingColumns": [
{
"datasetColumnName": "",
"writebackColumnName": ""
}
]
},
"formErrors": {
"datasetId": "",
"datasetTableName": "",
"datasetKeyColumnName": "",
"renamedWBIdColumn": "",
"mappingColumns": [
null
]
},
"columnMappingError": null,
"openAdditionColumnModal": false,
"modalTitle": "Additional Column Configuration",
"datasetLoading": false,
"showDatasetDropdown": false,
"isSubmitting": false,
"warning": {
"title": "Additional Column Configuration",
"message": "",
"show": false
},
"keyColumnsForAllAdditionalColumns": [],
"additionalColumnMappings": [],
"dateAdditionalColumnMapping": null,
"openDateAdditionalColumnModal": false,
"dateFormValues": {
"dateKeyColumnName": "",
"defaultYear": "2023",
"isCurrentYear": true
}
},
"rollupNotes": false,
"scenarios": [],
"annotateMarker": {
"toggle": false,
"markerData": null
},
"fiscalMonth": 0
},
"csvOptions": {
"rows": [
"T04.Account Level 2"
],
"columns": [],
"rolesMap": {},
"typesMap": {},
"labelMap": {
"T04.Account Level 2": "Account Level 2",
"Sum(T04.PY)": "PY",
"Sum(T04.AC)": "AC"
},
"ac_roles": [
"Sum(T04.AC)"
],
"pl_roles": [],
"py_roles": [
"Sum(T04.PY)"
],
"fc_roles": [],
"om_roles": []
},
"metadata": {
"measures": {
"PY": [
{
"label": "PY",
"name": "Sum(T04.PY)",
"role": "PY"
}
],
"AC": [
{
"label": "AC",
"name": "Sum(T04.AC)",
"role": "AC"
}
]
},
"columns": [],
"rows": [
{
"id": "T04.Account Level 2",
"label": "Account Level 2"
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment