Loading Data Using Rules File

Today we are going to discuss how to create some dimensions using rule files. The approach to create these files is as follows:

• From administration service console, select File>Editors>Data prep editor.
• Select file> Open data file.
• Select the file system tab.
• Select required flat file to load and click OK.
• The contents of flat file are displayed in Data prep editor.

Setting Data Source Properties:

• Select Options > Data source properties.
• Select the Header tab.
• In the number of lines to skip text box, enter 1. Then OK.
•  Then on the View menu clear the check mark next to raw data. The source data view is hidden as shown below.

• Select view> Dimension build fields.
• Select Options> Associate outline.
• If necessary, expand the Hyperion server node and the desired application node to display the Sales database node.
• Select Sales. Then save.

Adding the Product Dimension.

• Select Options> Dimension build settings.
• Select the Dimension Definition tab.
• Select Rules file.
• Next to Dimensions, click “Click here to Edit”.
• Enter Product.
• Press Enter. Check the result with below figure.

• Right click Product, and select Edit properties.
• In the data storage section, select Label only.
• In the configuration section, select Sparse.
• Compare results with the following figure:

Selecting the dimension build method:

• Select options> dimension build settings.
• Select the dimension build settings tab.
• In the dimension list, double-click Product.
• In the “Build method” section, select use generation references.
• Click OK.

Defining field Properties:

• Select Field1.
• Select field> Properties.
• Select the Dimension Build Properties tab.
• To set the properties for field 1, perform the following action:
• In the dimension list, double-click PRODUCT.
• Under field type, double click Generation.
• In the field number text box, enter 2.
• Click Next. In the dialog box, “field Number: 2” is displayed under the tab names.
• To set the properties for Field2, perform the following actions:
• In the dimension list, double-click Product.
• Under field type, double-click Property.
• In the Field number text box, enter 2.
• Click Next.
• Using the information in the following table, set the properties for the remaining fields:

• Click OK to return to Data Prep Editor.
• Compare the results with the following figure:
  

Validating and Saving the Rules file:

• Select Options> validate.  The message The rules file is correct for dimension building id displayed.
• Click OK and save.
• Select the Essbase server tab.
• In the “Look in” drop-down box, select Sales.
• In the “File name” text box, enter Famgen.
• Click OK.

Update Sales Outline:

• Open the Sales outline.
• Select outline> Update outline.
• Click Find Data File.
• Perform the following tasks:
•  Select the File System tab.
• Select the desired text file
•  Click OK. Our flat file is displayed in the list of data files.
• Click Find Rules File.
• Perform the following tasks.
• On the Essbase server tab, select the desired file.
• Click OK then it is displayed as selected rules
• Click OK Essbase process the dimension build. When the build is completed, the Dimension Build Completed dialog box is displayed.
• Save the Sales outline.