Within a cube view, is it possible to have a descriptive popup appear when you hover over an individual cell (similar to a tooltip in a chart)?
For context, the use case here would be to see further decimal places for numbers stored in the cube. (i.e. cell value appears as 100, but if you hover over it the additional popup would show 100.123)
I’m aware of the comments/annotation feature, but I’m not sure it would be able to cover this particular case.
Please let me know if I can provide any additional details that might be helpful.
There’s already a default tooltip for cells which is to display the last comment in the case that the cell is annotated. To display something else would break the default functionality which I would argue is more useful as displaying the cell value to more precision. Would displaying this actually give the user any more meaningful context? It’s up to whomever designed the report what number format to assign, and if the report designer hasn’t set any specific formatting then it will fall back to the format attribute or the column and row dimensions set by the TM1 database administrator.
There is also the issue of floating point arithmetic which TM1 uses to store numeric values. Not all decimal values can be represented exactly, for example 100.123 may actually be 100.1229999999999999 but displaying all the available 16 decimal points of precision is actually going to confuse things a great deal more. So you would need to make an arbitrary decision about how much precision to display.
I disagree. Many times when looking at variances, %s, or bps the standardized format might not provide enough context. When values show something like 0.0% users want a quick way to see what the real value is. It could be a tool tip or double clicking into the cell, but seeing the raw value is important.