Creating a Row Source

  To create a row source:

1. On the Object Browser View menu, select Row Sources.

2. Select Actions, and then Add.

3. In the Row Source Wizard, enter row source Properties.

   • Name

   • Description

   • Type—Application, Custom, or Join

   • Parent Row Source (application row sources only)—Select a parent row source, or select None if there is no parent.

   • Time Varying—For application row sources, select True or False to specify whether the data will change with time. If True, an effectiveTime column is created in the row source.

     The effectiveTime column is not visible in the Row Source Wizard; however, it must be mapped in the stagemap where the row source is involved.

     To map effectiveTime in the stagemap:

     • In the Graph tab in the Model, click the line between the row source and the data source and select Edit Mapping.

     • In Column Maps, select Advanced beside the effectiveTime column, and enter $begin(Fiscal), where Fiscal is the name of a time dimension in the model.

   • Generate Change Entries (custom row sources only)—If the row source is mapped to a cube, select True. If the row source is not mapped to a cube, select False.

   • Check Table Exists (custom row sources only)—When a row source is imported, Integrated Operational Planning checks for the existence of an external table. If the external table does not initially exist, an error is returned and the import fails. To avoid this error, set the value to False. For strict error checking and for situations where the external table exists from the beginning, set the value to True.

4. Create row source Columns.

   • To create application row source columns, click Create and perform an action:

     • Add Columns from the Data Source—Select Add from Data Source to display the Add Row Source Columns dialog box. When you select a data source, the columns in the data source are displayed. Select the columns and click OK.

     • Create New Columns—Click Create New to create a column. Enter the following information:

       • Name

       • Type—String, Double, Integer, Date, Timestamp, or Boolean

       • Nullable—Whether a value can be empty. Select True or False.

       • Data Constraint—Whether the data is restricted. Select None, Range, or Specific Values. If you select Range, enter the starting and ending values. If you select Specific Values, enter a list of values. To add a value, click Add.

       • Style

       • Size—(String) Column size

       • Precision—(Double) Accuracy in terms of number of decimal places. For example, with a precision of 3, the number 45.3768 is rounded to 45.377.

       • Date Format

       • Default—Default column value

   • To create custom row source columns, enter a database table name, click Refresh Fields and edit the following information:

     • Name

     • Nullable—Whether a value can be empty. Select True or False.

     • Default—Default column value

     • Style

   • To create join row source columns, enter the following row source configuration information and click Refresh Fields:

     • Primary Row Source

     • Secondary Row Source

     • Join Type—Inner or Left Outer

       After you click Refresh Fields, row source columns based on the row source configuration information are generated.To define columns, select corresponding Select Column check boxes or select include all primary row source columns in select columns or include all secondary row source columns in select columns.

       After you define select columns, you can define join columns from the secondary row source.

5. Enter Key and Indices information.

   • Row Source Key—Each row has a unique key. Click Edit and define the row source key by moving the desired column(s) from Available Columns to Selected Columns. (For time varying row sources, the effective date is automatically part of the key.)

   • Row Source Mapping Order—Column order in the row source. Click Edit move the desired columns from Available Columns to Selected Columns.

   • Row Source Indices—For application and custom row sources, click Create or Edit amove the desired columns from Available Columns to Selected Columns to define row source indices. Select True or False to define whether the row source index is unique. You can define as many row source indices as desired. Defining row source indices improves query performance.

   • Row Source Index Details—For application and custom row sources, click a row source index to view its details.

6. Click Save to create the row source.

   The row source is displayed in the Object Browser.

   Note:

   See Data Flow and Mapping for details on how data is staged and loaded into the Integrated Operational Planning database.