Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We're on QS Enterprise Nov 2025 patch 2. We have an app that has a field named "Site" and a master dimension also named "Site". We experienced some odd behavior: When I selected a value from Site, the filter bar showed "SITE" (all caps). There is absolutely no field or dimension with that name or title. Why did it do this?
The app also caused trouble with an NPrinting report -- it would fail with a filter error: "False to current document data" that was supposed to filter based on Site. It failed for 3 of 5 values and succeeded for the other 2.
I got everything working normally (in Sense and NPrinting) by reloading the data with the field renamed (Load Site as "Site Name") and then reverting back to "Site" so it seems that the table in the database was somehow corrupt.
I've never seen anything like this. Wondering if it's a new problem. Maybe I'll never see it again.
Is the master item's Title (not name) ='SITE'? This is what shows up in the selection bar.
The master dimension Name is "Site" and the Label expression is empty.
was the data loaded via a SQL select statement?
No not with a SQL statement. The data all came from CSVs and Excel files.
Renaming a single field within the load - forward and backward - doesn't change mandatory the field because the field-index could keep the same and just the label for the field needs to be adjusted.
Therefore you may try to repeat the measurement by adding anything like: 'Dummy' as MyDummy before Site is loaded and/or dropping this field + saving the app and then reloading to enforce a change to the field-index.
FWIW I had a similar problem recently on May 2025 patch 6. There was a field selection ( with a legitimate name) showing in the selection bar. But there was no actual selection in that field. I couldn't clear this phantom selection chip. I also "fixed" the problem by reloading the field with a different name and then swapped back.
Anyone else seen this?
-Rob