Master Dimension no longer working the same as yesterday in Selection options.

spjuza — Thu, 09 Dec 2021 20:07:13 GMT

Bit of a weird situation. I created a master dimension based on a nested If statement and it was working as intended.

It still shows up in the table and most of the charts, but when I click on it to add it as a filter, it does not show up as a single filter like it did yesterday. Rather, it shows up as all the component parts.

The master dimension code is essentially:

= if((Var1 = X or Var1=Y) AND (Var2 = A) AND (VarN = B), 'Value A', 'Value B')

Previously, when I would select the Filter A option, it would show up in the filter Selections in one value. I don't think I changed anything with the code, but now when I select it, it shows up as multiple selections (Var 1, Var2, VarN, etc.).

Have others seen this happen?

Re: Master Dimension no longer working the same as yesterday in Selection options.

spjuza — Thu, 09 Dec 2021 22:25:25 GMT

Another post suggested creating the dimension in the load script and not as a master dimension. This solved the issue that I was having.

topic Re: Master Dimension no longer working the same as yesterday in Selection options. in App Development

Master Dimension no longer working the same as yesterday in Selection options.

Re: Master Dimension no longer working the same as yesterday in Selection options.