Create reporting statements for interim tables in an entity definition to generate Detail reports when the same is requested during an Data Archive Definition specified from the Data Archive user interface.
To create a reporting statement, perform the following steps:
Select the parent application version.
Click
Insert > Statement
. The
New Statement
dialog box appears.
Specify a label for the statement.
Specify whether values in a report must be generated using an SQL query or obtained from the interim table.
Specify SQL query if SQL is selected.
Click
Finish
to save the statement. The statement appears under the