AnsweredAssumed Answered

Need to see a fact column in drill-through but not in UI fields list

Question asked by Peter Kierstead on Nov 15, 2018

We are running Pentaho 6.1 Enterprise on Windows with all service packs installed.
We have a column in every fact table (PolicyNumber) that we need to see in every drill-down result. However, the users do not want to see it, in any form, in the Folders/Fields list in the analyzer UI. The older Pentaho 4.8.2 system would do this by creating a invisible degenerate dimension on this column (even though it was invisible it still showed up in the drill-down results, in 6.1 it no longer shows up if invisible). How can we make this work as requested in our current Pentaho 6.1 system?

Outcomes