I would like to allow managers to create their own reports but I should know which properties Pega display in data explorer. Only the properties that optimized by developer ? Because there might be some properties I use for development purposes and I don't want them to be visible by business users.
All the properties created by developer will be available in data explorer irrespective of optimized or not. When we will run the report, that time we will get the error if properties are not optimized.
Yeah that article helps in customizing the properties that user wants to be in report editor. But if you want to customize the properties for reports having joins and association then the content in the section "Add properties from associations and joined classes" is not clear. If you have a requirement of customizing the reports that have joins and associations let me know I will provide the steps on how to configure.