Navigation: Analyze >

Understanding Unused Fields

 

 

 

 

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

 

QSDA only reviews field usage in the front end of the app. Usage in the load script is not considered.

 

While the QSDA field usage analysis attempts to be comprehensive, there may be occasions where a required field is reported by QSDA as unused. It is your responsibility to review the Drop Fields list before blindly pasting it in your script. 

 

Here are the known conditions where is field is used in the app, but the usage cannot be detected by QSDA Pro.

 

Section Access reduction fields.

Fieldnames or Expressions that are stored as field values in another "Dim" field, where the Dim field is used to dynamically populate Dimensions or Expressions at runtime. QSDA does not examine field values.

If a Measure and Field share the same name, there can be ambiguity as to whether a reference is to the Measure or the Field.

 

 

 

 

QSDA Pro version 3.1.2