asked on August 23, 2021
Support,
Issue: SSAS Pivot table negative numbers do not display in red as defined in OLAP format
Using:
CHROME Version 92.0.4515.159 (Official Build) (64-bit)
Flexmonster July 2020 (v. 2.8.11) build 07/13/2020
Angular 6
Using CHROME browser our Angular 6 App is using Flexmonster and accelerator to render SSAS cubes in a pivot table
This was working previously but has now stopped:
report.options.useOlapFormatting = true;
const conditions = [
{
'formula': '#value < 0',
'format': {
'color': '#FF0000',
'fontFamily': 'Arial',
'fontSize': '12px'
}
}
];
report.conditions = conditions;
pivot.flexmonster.setReport(report);
The formatting is correct when using Microsoft OWC pivot component in a Silverlight application running in a browser (see attached).
Any ideas?
Thank you,
Michael Jiambalvo
⋅ August 25, 2021
Hello,
Thank you for reporting this issue.
It seems that specifying useOlapFormatting property as true clears client-side conditional formatting ("formula": "#value < 0", "format": ...). We will fix this issue in the minor release ETA Sept 21. As a temporary workaround, we suggest downgrading Flexmonster version to 2.8.10.
Also, please note that OLAP conditional formatting demonstrated on your screenshot will not be applied. The useOlapFormatting property only serves to apply number formatting (delimiters, currency symbols, etc.). Conditional formatting should be applied on the client-side as demonstrated in code snippets from your question. More about conditional formatting can be found in our documentation: Conditional formatting.
Feel free to reach out if other questions arise.
Kind regards,
Illia
⋅ September 21, 2021
Hello, Michael,
We are glad to inform you that the issue with conditional formatting not working with options.useOlapFormatting was fixed.
This is included in the 2.9.8 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if everything works.
Best regards,
Illia
⋅ September 29, 2021
Hello,
We are wondering if you had some time to test the fix.
Looking forward to hearing your feedback.
Regards,
Illia
