asked on June 6, 2025
Flexmonster has a mdx configuration which supports defining a with member clause to add additional custom measures to the report. It doesn't support font and colour formatting native to mdx. Can you consider adding support for font and colour formatting directly in mdx?
Here's an example we use to style the format based on a value scale:
with member [Measures].[SP Benefit Ratio1] as
IIF([Measures].[SP Total] = 0, null, [Measures].[SP Total Benefits] / [Measures].[SP Total]),
BACK_COLOR=IIF([Measures].[SP Benefit Ratio]>0.40,RGB(255,0,0), RGB(0,255,0)),
FONT_NAME="High Benefits", FONT_SIZE=24,
FORMAT_STRING="#,0.00%;-#,0.00%"
select ({[Measures].[SP Benefit Ratio1]}) on columns,
(TOPCOUNT([Staffing Pattern - Fact].[Division Display Name].ALLMEMBERS,5,[Measures].[SP Benefit Ratio1])) on rows from [Model]
where ({[Year - Filter].[Year].&[2025]})
CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR, FONT_SIZE
⋅ June 6, 2025
Hello, Yosef!
Thank you for reaching out to us.
Kindly note that in Flexmonster, it is not possible to add text styling via MDX.
Alternatively, there are possible approaches to change font color and size:
Hope you will find our answer helpful.
Kind regards,
Solomiia
⋅ 3 days ago
Hi Solomiia,
Thanks for your response and sorry for my delay.
What we're looking for is to add a custom measure column defined by an mdx query, not just custom formatting, I didn't make this clear before. For example, Excel has a way to do this via: OLAP Tools > MDX Calculated Measure. Is this something you can support in Flexmonster?
⋅ 3 days ago
Hello, Yosef!
Thank you for getting back to us.
Kindly note that Flexmonster supports calculating some measures on top of the values returned from the cube. You can check the list of supported aggregations for SSAS in our Technical Specification: https://www.flexmonster.com/technical-specifications/#aggregations.
Here is also the guide that explains each aggregation in more detail and with examples: https://www.flexmonster.com/doc/aggregation-functions/#available-aggregations.
You are welcome to explore the mentioned aggregations live in our SSAS demo: https://www.flexmonster.com/demos/js/connect-ssas/. To do so, open the Fields Toolbar tab, and then check the aggregations available by clicking on the sigma icon in the "Values" box.
Hope you will find our answer helpful.
Kind regards,
Solomiia
⋅ 2 days ago
Hi Solomiia,
Thanks for letting me know.
Ok so you support aggregate function and not mdx query based custom measures. Can you consider supporting this in the future?
⋅ 1 day ago
Hello, Yosef!
Thank you for your swift response.
We have added the request to have the Calculated Values functionality for Microsoft SSAS data source to our Customers' Wishlist.
Our team will notify you about any updates on the matter.
Feel free to contact us if any other questions arise.
Kind regards,
Solomiia
