Get Free Trial

Issue: SSAS Pivot table negative numbers do not display in red as defined in OLAP format

Answered
Michael Jiambalvo 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

Attachments:
SSASformatIssue.PNG

2 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 5 days ago

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

Please login or Register to Submit Answer