Olap Database Profiles (IA11.3)

Use Olap Database Profiles (IA11.3) to define profiles that specify how the how the data mart is built and loaded. You can set up multiple profiles, each for a different purpose.

Process at a Glance

  1. Load the preassigned data mart types.
  2. Create an OLAP destination.
  3. Define the data mart.
  4. Define the dimensions for the data mart.
  5. (YOU ARE HERE) Define the information transfer profile.
  6. Load the data mart.
Profile Name
Specify a profile name and description that represents the type of information transfer you are defining.
Fact Table Options
Options are:
  • N (No load)
  • I (Incremental Load) - Only data values that have changed since the last data mart update are loaded.
  • C (Complete Load) - If this is the first time you are creating your data mart, select this option. If you choose this option for a data mart that already contains data, all data values will be overwritten.
Dimensions
If you select Yes to create all dimensions, leave this field blank. If you select No, select Data Mart Dimensions from the drop down list and select the dimensions you want to create.