Transform

Transform Cubes

Name: OpenEMIS Integrator
Article Name: Transform Cubes
Category/Module: Transform
Tags: Cubes
Version: 2.3.0
Date Updated: 30 May 2018

 

Purpose: This feature enables you to transform the relevant data into standard indicator based data. Whereby, you can publish it to the output to get a visualisation of the indicator you have created.

Steps: 

  1.         Go to Transform > Transformations on the left panel.
  2.         Select on the Add button
Rules:
Aggregation: Refers to the numerator in the fraction. E.g. Count No. of Female Students
       ~ Expression Agg: The function E.g. Sum, Average.
       ~ Expression Val: The field you are using the function on.
       ~ Alias: Temporary name that stores the values.
       ~ Conditions: To fulfill a specific criteria. E.g. WHERE Gender = ‘F’
Denominator: Refers to the numerator/divisor in the fraction. Retrieves all the Transformed Cubes.
       ~ Field: The field that you are retrieving for the denominator.
Formula: The formula to get the expected indicator/results to derive the statistics.
      ~ Expression: The field that you are retrieving for the denominator.
      ~ Alias: A temporary name to store the value in.
      ~ Data Type: Decimal/Integer?

 

3.          Select the Cube you have created earlier and insert the required input such as Name.

Note:
By default, Trace Source will be set to yes.
If ‘No’ is selected, parents of the cube or transformation will not be traced in the visualisation (ie. it will be the first node/source in its path).

4.          Select Add, if you wish to add a rule.

5.          Select the Rule Type, and the other fields will automatically appear.

6.          Fill in the required field, you may add Conditions fields if necessary.

7.          Select Save.

8.          Go to Transform > Rules. Select the correct Transformation under the dropdown list.

9.          Process Status will be reflected as “Not Processed”.

10.        Select Actions bar > Process.

11.        Process Status will now be displayed as Completed.

12.        You may verify the data by selecting the same rule and click on the Data tab.

Related Articles