Loading Information into Capital Asset Planning

If your Capital Asset Planning application is new, you may want to load information, such as the existing account structure and properties, from enterprise systems:

You can also:

  To load information—data and metadata—using DIM Adapter for Planning:

  1. Load metadata (for example, entities and accounts) into Capital Asset Planning.

    Load Account and user-defined dimensions from any flat file or ODBC-compliant database. Load members, shared members, and attribute values into dimensions. Oracle recommends that you first load a small sample of accounts. Verify the results, make any needed changes, and then load the entire dimension.

    See Capital Asset Planning Structure for a list of Capital Asset Planning accounts and their properties.

  2. Refresh the application to update the Oracle Essbase outline.

  3. Set up the data load dimension and dimension driver members.

    The data load dimension is the dimension to which you are loading data, and corresponds to the target table in the DIM Adapter for Planning. The driver dimension is the dimension to which you are loading data in an Essbase database. See “Loading Data” in the Oracle Hyperion Planning Administrator’s Guide.

  4. Load data and member properties into the Essbase database for the Capital Asset Planning application.

    The outlines must match; you can specify only the members and parent member names.

  5. Refresh the application to update the data.

    Each time you modify the application structure, reload the data.

    Note:

    Load fixed accounts only into the BegBalance member and load varying accounts into all time periods. You set the effective POV for each record using the POV port.