Issue: SSAS Pivot table negative numbers do not display in red as defined in OLAP format
CHROME Version 92.0.4515.159 (Official Build) (64-bit)
Flexmonster July 2020 (v. 2.8.11) build 07/13/2020
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’,
report.conditions = conditions;
The formatting is correct when using Microsoft OWC pivot component in a Silverlight application running in a browser (see attached).
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.
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.
We are wondering if you had some time to test the fix.
Looking forward to hearing your feedback.