Data Cube - Data Input

This applies to: Managed Dashboards, Managed Reports

When you create a data cube, you can reference a warehouse data storage area that contains user input data. Use the Data Input transform to add and modify data from inside Symphony. Input data directly, or set up a data interaction input to allow users with the Data Input privilege to add data.

You need to be a user with a Developer seat  to create or edit a data cube.

Create a new data cube with a data input transform

  1. Open the data cube work area. You can do this in one of several ways:

    • Select Create New Data Cube from the home page, then Data Input from the Add/Edit menu
    • Select New > Data Cube from the Managed Dashboards and Reports main menu, then select Data Input
    • Right-click Data Cubes in the Explore window, then select New Cube from the menu, then Data Input from the Add/Edit menu

    The data cube work area opens, with a Data Input transform and connected Process Result.

  2. Select your transform, then Configure from the toolbar. The Data Input configuration work area opens.

  3. Select Add Column to open the Data Input Column work area and add your columns to contain input data. Provide a Name, Data Type, Max Length, and optional Default Value. When you have saved all of your new columns, close the work area to continue creating your data cube.

    By default, several columns are created and populated, but not selected to be included in the output: RecordID, RecordSequence, CreatedBy, CreatedTime, LastModifiedBy, LastModifiedTime. Optionally, select a column to check it and add it to the data output.

  4. View your included columns, and enter data or add more columns in the Data Preview tab at the bottom of the data cube canvas.

    • Enter your data, and use the Tab key to create or move to the next cell, or the Enter/Return key to create or move to the next column.
    • Right-click a cell or row to add, delete, or insert columns and rows.
    • If you delete a column, you can't re-add a column with the same name until you have checked the data cube in and then out again.
    • Changes to rows of data are not affected by check in or check out states, as viewers or end users can be allowed to make changes.
    • Undo Check Out does not change or remove data.

Add a data input to an existing data cube

  1. With your data cube open for editing, select Data Input from the toolbar.

  2. Select a data connector. (For OLAP databases, instead select the cube under the data connector you will be querying.)

    Data structures in your Symphony environment also include data sources discovered by Symphony in Managed Dashboard and Managed Reports data connectors, as well as shared from Data Discovery data connectors.

  3. Select your transform, then Configure from the toolbar. The Data Input configuration work area opens.

  4. Select Add Column to open the Data Input Column work area and add your columns to contain input data. Provide a Name, Data Type, Max Length, and optional Default Value. When you have saved all of your new columns, close the work area to continue creating your data cube.

    By default, several columns are created and populated, but not selected to be included in the output: RecordID, RecordSequence, CreatedBy, CreatedTime, LastModifiedBy, LastModifiedTime. Optionally, select a column to check it and add it to the data output.

  5. Connect the Data Input to your ETL process to view the data in the Data Preview tab.

  6. View your included columns, and enter data or add more columns in the Data Preview tab at the bottom of the data cube canvas.

    • Enter your data, and use the Tab key to create or move to the next cell, or the Enter/Return key to create or move to the next column.
    • Right-click a cell or row to add, delete, or insert columns and rows.
    • If you delete a column, you can't re-add a column with the same name until you have checked the data cube in and then out again.
    • Changes to rows of data are not affected by check in or check out states, as viewers or end users can be allowed to make changes.
    • Undo Check Out does not change or remove data.