asked on June 12, 2023
Hello,
We are using FlexMonster for a planning software where users can connect their database to allow for showing their data in a FlexMonster table.
One use-case we have is that sometimes, customers have dimensions with null data. To show these dimensions, we enable the FlexMonster option "Show Empty Values" for them.
However, this has the unintended consequence of "crossing" all members. So in the cases of asymmetric dimensions, they replicate. E.g.
Becomes
We understand this is the intended behavior for FlexMonster and we have found a workaround for it to only show null dimensions if they exist in the database. However, right now we are just hiding the dimensions that we don't want to show (by setting width/height to 0), and this can cause some unintended behavior sometimes. For example, users can sometimes accidentally reveal these dimensions sometimes when trying to hide them.
So, my question is, is it possible to fully remove a given dimension from FlexMonster in a reliable manner? E.g., using the above example, using pseudo code
flexmonster.removeColumn(["country.[GB]", "account.[US Construction]"]) ?
Alternatively: If FlexMonster natively supports what we want to do (show empty values but only ones that exist in the data source), please let us know 🙂 I am working with a workaround designed a long time ago and better solutions may have been found meanwhile!
This question is now closed
