Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. Salesforce Accelerator
  10. SAP Application Retirement Entities
  11. Import Formats for Constraints
  12. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Creating or Deleting Reporting Statements

Creating or Deleting Reporting Statements

Reporting Statements are created for Interim Tables in an Entity Definition, in order to generate Detail reports when the same is requested during an Data Archive Definition (specified from Data Archive user interface).
To define a reporting statement:
  1. Select the parent Application Version.
  2. Click
    Insert > Statement
    . The New Statement dialog box appears.
  3. Specify a Label for the Statement.
  4. Specify whether values in a report must be generated using an SQL query or taken from the Interim table.
  5. Specify SQL query in case SQL is selected.
  6. Click
    Finish
    to save the Statement. The Statement will appear under the “Statements” tab in the Explorer Pane.
  7. Click
    Save
    to commit changes to Home Schema.
To delete a statement, navigate to the
Statements
tab in the Explorer Pane. Select
Delete Statement
) from the context menu.

0 COMMENTS

We’d like to hear from you!