Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Step 1. Define Search Options

Step 1. Define Search Options

Define search options to search for records within an entity in Data Vault.
You define search options for each entity archived to Data Vault. When you define search options, the system displays a list of all columns from the entity driving table. You can use the columns from the driving table or add columns from another table such as a child or reference table.
Use search options to specify the columns that you can use to search Data Vault. You can also restrict columns from appearing in the search results.
You can specify the following options for each column:
Display
Displays the column data in the search results. Only columns marked as display are included when you export search results from the Data Vault search.
Data Format
The display format for numeric and datetime values in the search results. For example, you might set the data format for the ITEM_PRICE column to
$####.##
. If you do not enter a data format for datetime values, Data Archive uses the default discovery result date format from the system profile. If you do not enter a data format for numeric values, Data Archive displays the number as it is stored in the database.
This field is available for numeric and datetime datatypes.
Data Conversion For Display
The display format for dates in Data Vault search. If dates are in the Julian format, you can select the Julian to Gregorian Date option. This enables you to search and view data in the Gregorian format in Data Vault search.
Julian to Gregorian conversion is only supported for columns with Julian dates that contain five or six digits.
The following types of Julian dates are supported:
  1. Julian dates with the century included. If the Julian date includes the century, enter "
    C
    " in the Data Format field to indicate that the date includes the century. In this case, "15001" would convert to 1-Jan-1915, and "115001" would convert to 1-Jan-2015.
  2. Julian dates without the century included. If the Julian date does not contain the century, specify the limiting year in the
    conf.properties
    file with the following property:
    informia.julianLimiterYear=
    For example:
    informia.julianLimiterYear=
    1975
    The 5-digit Julian date "15001" could be either 1915 or 2015. If you set the limiting year to 1975, then the dates "05001," "15001," and "65001" are converted as 2005, 2015, and 2065. The Julian dates "75001," "85001," and "95001" are converted as 1975, 1985, and 1995.
Search
Uses the column as a search parameter. You will not be able to select exotic or customized datatype columns because these types of columns cannot be used to search the Data Vault.
Sort
Allows you to use the column to sort data in the search results. If you select this option, you must also select the
Display
option for the column.
Description
The column heading in the search results. For example, you might set the description for the ORDID column to "Order ID."
If you do not select any columns for display, search, or sort, then all columns are available to display, search, and sort on.

0 COMMENTS

We’d like to hear from you!