Creating a FreeForm App Using the Application Creation Wizard

To continue creating a FreeForm app using the application creation wizard:

1. For No. Of Cubes, select the number of cubes you'd like to use to create your FreeForm app. You can add up to 12 cubes now, or you can start with one cube and then add more cubes later on the Application Overview page.

   Note:

   If you create a single cube FreeForm app, data maps and other multi-cube features are unavailable until you add cubes to the FreeForm app. Also for a data map to work there needs to be at least one block storage (BSO) cube, and the source for the data map needs to be a BSO cube.

2. In Cube Name, enter a name for each cube, maximum eight characters.
3. Select Is ASO, if the cube is an aggregate storage cube. If the Is ASO checkbox is cleared, then the cube is a Hybrid block storage cube.

   Note:

   Reporting applications that use ASO cubes, generally, store data in aggregate views and can handle a higher number of dimensions than BSO without adversely affecting performance.

4. Click Next.
   The Create Dimensions page is displayed. From this screen, you can create up to three dimensions and assign one each to Account, Entity, and Period default dimension types. Additional dimensions can be added later in the web interface.

   Note:

   FreeForm apps do not require standard dimensions. You can create an application with only custom dimensions containing members of your choice. The dimensions you create and its structure are not governed by the constraints imposed on standard application dimensions.

5. In Create Dimensions, create and map default application dimensions. Complete a step:

   • To create dimensions and map them to default dimension types, select the Enabled check box and then type in dimension names.

     Note:

     Enabling dimensions is not automatic. Just like custom applications, you must manually enable dimensions for FreeForm apps. You can do this now, or you can enable them later.

   • To create a dimension and assign a dimension type, select the check box in a row and then type in a dimension name.

   • To create a shell application, do not change anything in this screen.

     You can add and map dimensions to shell applications after the application creation process is complete.

6. Click Next.
7. In Review, verify the settings that you selected and then click Create.
   The application creation process may take a few minutes.
8. In the Application Creation Status screen, click OK.
   The Home page is displayed.
9. Optional: Create custom dimensions, if needed.
   1. Click Application, then Overview, and then select the Dimensions tab.
   2. For Cube, select a cube that you created for your FreeForm app or select All.
   3. Click Create.
   4. Complete the dimension details for each dimension you want to add. For descriptions of the dimension properties, see Editing Dimension Properties.

      For FreeForm applications, you can select the dimension type. Dimension types can include:

      • Account
      • Entity
      • Period
      • Custom

      Notes about dimension type:

      • A dimension type is not listed if you've already created it (for Account, Entity, Period) or if you've exceeded the maximum number of dimensions (for Custom).
      • You can't edit the dimension type after you've created the dimension.

      Select Enabled to indicate whether the dimension is to be used in this cube.

      Note:

      Enabling dimensions is not automatic. Just like custom applications, you must manually enable dimensions for FreeForm apps.

   5. Click Done.
   6. Click Action and then Refresh Database to refresh the cube.
10. Optional: Import application data. See Importing Data.
11. Optional: If you created a shell application with a view to import a snapshot, access Migration, then delete the application, and then complete the import process.
    1. Upload a snapshot from a FreeForm app to your environment. See Uploading Archives to the Service in Administering Migration for Oracle Enterprise Performance Management Cloud for detailed instructions.
    2. Import the snapshot. See "Importing a Backup to Create a Clone of Another Environment" in Importing Artifacts and Application from a Snapshot in Administering Migration for Oracle Enterprise Performance Management Cloud for detailed instructions.
12. Create application users in identity domain and assign predefined roles as needed. See Manage Users and Roles in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
13. Set up access permissions as needed. See Setting Up Access Permissions.