I have a three-series chart built on the FIN General Ledger cube with T Year-Month dimension on X-axis. The first series on the chart is column format, remaining two on top are line format.
In the JSON settings (shown as Appendix A below), I have specified the two line series be red and black respectively. I have NOT specified a color setting in the JSON for the first column series though, as I was hoping that would refer to the color attribute of the T Year-Month dimension.
I want to write a rule behind the }ElementAttributes_T Year-Month cube so that historic months are one color, then future months are a different colour in the column chart. As the admin changes the control month, the rule would change the colours in the attribute cube and the chart would dynamically update to reflect the currently agreed transition point between historic and future months.
Before writing the rule, I have tested the chart by populating the Color attribute in the }ElementAttributes_T Year-Month cube. However, the chart does not react to any changes.
I then tested the chart by populating the same colour code against the version in the }ElementAttribute_FIN Version cube (attribute for that version was previously blank) and the chart does respond to this.
I note that all the dimensions in the FIN General Ledger cube have the color attribute on them, but I don’t see any color values populated on any other dimension elements that would be firing in preference to the T-Year Month settings that I have populated.
Is there something I need to do to get the chart to look at the color attributes on T-Year Month dimension which I am not doing?
Thanks in advance!
Appendix A: JSON Settings behind 3-series chart object:
{
“cardConfig”: {
“showTopBorder”: true,
“shouldShowTitlesSeparator”: true,
“showSpinner”: false,
“subTitle”: false,
“showFooter”: false,
“footer”: {
“showFilterInFooter”: false,
“iconClass”: “”,
“text”: “”,
“callBackFn”: “”,
“href”: “”
}
},
“chartOptions”: {
“yAxis”: [
{
“min”: 0,
“max”: 20000000,
“labels”: {
“style”: {
“color”: “#434348”
}
},
“title”: {
“text”: “Monthly Values”,
“style”: {
“color”: “#434348”
}
},
“index”: 0
},
{
“min”: 0,
“max”: 250000000,
“title”: {
“text”: “LTM”,
“style”: {
“color”: “red”
}
},
“labels”: {
“style”: {
“color”: “##f9d67a”
}
},
“opposite”: true,
“index”: 1
}
],
“series”: [
{
“yAxis”: 0,
“type”: “column”
},
{
“dataLabels”: {
“enabled”: false,
“format”: “{point.y:,.0f}”
},
“yAxis”: 1,
“type”: “line”,
“color”: “red”
},
{
“dataLabels”: {
“enabled”: false,
“format”: “{point.y:,.0f}”
},
“yAxis”: 1,
“type”: “line”,
“color”: “black”
}
]
}
}
Appendix B: Row MDX of my chart:
{
{ {[FIN Version].[ACTBUD]} * {[Time Analysis].[BASE]} },
{ {[FIN Version].[ACTBUD]} * {[Time Analysis].[LTM]} },
{ {[FIN Version].[FBUD]} * {[Time Analysis].[CY]} }
}
Appendix C: Column MDX of my chart:
{TM1SubsetToSet( [T Year-Month].[T Year-Month], “UX CurrentYear LastYear Months”)}