Creating a Strategic Modeling Model

Administrators and Modelers can create Strategic Modeling models using templates—financial model frameworks that contain predefined reporting and modeling standards. Oracle includes several pre-defined templates to get you up and running quickly. You can also create a model that is based on an existing model.

Users check out models to work with them, or they can work with a copy of the model. When users work with a copy of a model, they can't save changes to the data or to the model.

When you create a model, the model is populated with a hierarchical chart of accounts, a time structure, reports, dataviews, account groups, and all the metadata from the template or the model it was created from.

You must have already created an application and enabled Strategic Modeling. If you want to use a custom template (customized using Oracle Smart View for Office) to create the model, it must already be uploaded.

Watch this tutorial video to learn more about creating a Strategic Modeling model.

video cloud png Tutorial Video

To create a Strategic Modeling model:

  1. From the Home page, click Strategic Modeling Strategic Modeling icon, and then click Model View Model View icon.
  2. Click Create.
  3. On the General page, specify the following options and then click Next.
    • Specify a model name and description.
    • Select whether to create the model from a template, from an existing model in the current application, or from a local .alc file, and then select the template, model, or file.

      If you are creating a model from a local .alc file, the file must have already been converted in Smart View for use on the Cloud.

      To integrate Strategic Modeling data with Financials, select the Financial template.

    • Select Place at Root to create a standalone model or a model that will be the parent of another model, or to create a hierarchical structure, clear Place at Root and select a parent model.

      Creating a hierarchical model structure can be useful for consolidations and managing access control, or for visually organizing models.

    • Select a base currency and units.

      Each model can have its own currency and units, independent of the application.

      If you create a model from a local .alc file or from an existing file if you keep source data, these options are not available; the model is created using the units and currency of the original model.

      Note:

      You set up currency conversions in Smart View. See "Translating Currencies" in Working with Strategic Modeling in Smart View.
    • If you created the model from an existing model, select Keep Time Structure if you want the new model to use the same time period structure as the existing model.

      If you selected Keep Time Structure, you can select Keep Source Model Data to include the source model's data values in the accounts.

      If you select Keep Time Structure, skip to step 5.

    • If you created a model using the Financial template for integration with Financials, in Select Entity, select a Financials Entity dimension member. The model will be mapped to the selected Entity dimension member.

      This option is available only when creating a model from the Financial template. For more information, see Integrating Data Between Strategic Modeling and Financials.

  4. On the Calendar, Time Period, and Configure Years pages, specify the options for building the calendar for this model.
  5. Review the model creation options, and then click Create Model.

The model is created with a chart of accounts and a calendar structure based on the options you selected.

You can convert an Oracle Hyperion Strategic Finance model to a Strategic Modeling model in Smart View. See Working with Strategic Modeling in Smart View.