I created an Index class for reporting purpose - Index-ABCD. The table mapped to this table is pr_index by default. In order to use the properties (say, Dummy) in Index-ABCD class in a report definition (using declarative join)- I must expose these properties.
However, this would mean additional columns would be created in the database table pr_index corresponding to the property Dummy. This wont be a good approach as other applications might not need this additional column under pr_index.
I assume a better way would be to create a table pr_index_ABCD and have my columns there. How can I create this in Pega 7?
Following your approach is not creating a index table but exposing the column in the work table and adding a external mapping in the class. Could you please reverify the approach and suggest if there is any setting which needs to be configured for this.