Problem: Table viewer dialog shows total for null value and possible to select dimension value cross

[#1]

Sorry for bad heading which might be misleading. I have a problem what I don't understand.

First of all. I have app where someone else has made development. He/she has load data from Oracle and put null as '*' in precending load. In the old app table viewer dialog shows as picture "Capture".

I have another picture which illustrates situation where I have two multibox and if you have selected one value you will get possible values for all rounds.

Old app has been developed by loading data from DB and then concatenating all queries to one table.

[#2 · Accepted solution]

This case is closed. There was Star is *; command which makes that value as wildcard.