Create a Calculation task to extract specified dimensional information and export it to a staging table for futher processing and analysis.

To use the extract hierarchy task:

  1. Create a workflow process that includes a Calculation task.
  2. Type a name for the workflow task.
  3. Select Stored Procedure for Type and appdb for Datasource. 
  4. Type fl.ExtractHierarchy for the Stored Procedure Name.
  5. Select New Parameter and type StagingTable for the Name. 
  6. Specify the name of the staging table where the extracted information will be stored for the Value. 
  7. Select New Parameter and type Dimension for the Name.
  8. Type the name of the dimension being extracted, such as Account. 
  9. Select OK. 

Once the workflow successfully executes, the system will automatically generate a staging table, formatted as client.<StagingTableName>, containing the requested dimensional information ready for use. 

Example of staging table: