Hello experts, we are having trouble with Currency Key (0CURRENCY) values. On a certain query, we are using cells (we have one structure in rows and another one in columns). For all key figures in which Currency Key is used, the value of the currency in question appears on every cell. We need to eliminate this value, if possible show the value alongside the key figure (if the key figure is in columns, the value would be shown at the top).
I know that one solution is to use NODIM function over the key figure, and I also know that changing scaling factor can show both the selected factor as well as the currency alonside the key figures. However, both solutions are feasible when not working with cells. The main problem we have is that this query has around 400 cell values (due to this, the query runs much more slowly than other queries, even in the Query Designer), so changing everything (every single cell) to the formula that uses NODIM will take too long. And for some reason, changing the scaling factor over the key figure is not working. I also tried changing the scaling factor over the non-key figure structure, but it did not work. Finally, I tried selecting all values of the individual cells and changing the scaling factor, but it did not work either.
Is there an easier way, or should we create the key figure with the NODIM function and have all cells use it?