Understanding Unused Fields

One of the primary uses for QSDA Pro is identifying unused fields in an app data model. You can then drop these fields from the model, saving server resources and typically improving performance.

QSDA only reviews field usage in the front end of the app. It does not consider usage in the load script.

While the QSDA field usage analysis attempts to be comprehensive, it may occasionally report a required field as unused. Always review the Drop Fields list before pasting it into your script.

The following conditions can cause QSDA Pro to miss field usage:

• Section Access reduction fields.
• Fieldnames or Expressions stored as field values in another "Dim" field, where the Dim field dynamically populates Dimensions or Expressions at runtime. QSDA does not examine field values.
• If a Measure and Field share the same name, ambiguity may exist as to whether a reference points to the Measure or the Field.