Support Article
Report definition displays warning for exposed columns
SA-80659
Summary
Two new fields are added in a report definition and the properties are exposed through the Optimization Wizard. When the application is packaged and moved to other environments, a Moderate level Guardrail warning occurs in the report definition. Though the physical columns exist in the database, the system does not recognize the exposed columns.
Error Messages
Performance:
Moderate
These properties are not optimized: <property_name>. Displaying them may result in poor performance. Consult your system administrator about optimizing properties for reporting.
Steps to Reproduce
- Create new embedded properties.
- Add the new properties to an existing report definition.
- Expose the new properties.
- Package the rule changes and move to another environment.
Root Cause
When packaging is performed for rule changes, the class rule is not included. This is where external mappings are mentioned for the exposed embedded properties.
Resolution
Perform the following local-change:
Package the class rule in the Product rule since external mappings are in the class rules for the exposed embedded properties.
Published August 19, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.