The ElastiCube Manager makes it easy to view and modify table and field details.

This section describes the options available for tables and fields.

Table Options

To review table metadata:

  • Hover over the information icon next to the table name.
    the following information is displayed:

    • Table name
    • Database Name
    • Server Address
    • Source Type (Excel, MySQL, Google AdWords, etc.)
    • Number of rows

rows

To rename a table:

  1. Double-click the header of the table that you want to rename.
  2. Type in a new name or use the cursor keys to edit specific components of the existing table name.
  3. Click away from the table to save any changes.

To duplicate a table:

  1. Hover over the table name until the preference icons appear.
  2. Click the duplicate table icon (#3 in the diagram below).

To delete a table:

Delete a table when a data source is no longer available or required. You will need to rebuild the ElastiCube for the changes to apply.

    1. Hover over the table name until the preference icons appear.
    2. Click the remove table icon (#4 in the diagram below).

To add a custom field to your table:

    1. Place the mouse cursor above the table name until the preference icons appear.
    2. Click the add new custom field icon (#2 in the diagram below). Click here to learn more.

To preview data:

    1. Hover over the table name until the preference icons appear.
    2. Click the preview icon (#1 in the diagram below). Click here to learn more.

To make your table invisible:

You can make your table invisible, for example, if you’re using data from the table in another table, and do not need the table fields visible to the dashboard designer.

    1. Hover over the table name until the preference icons appear.
    2. Click the Additional Preferences icon (#5 in the diagram below).
    3. Clear the Visible option.

preview rename delete and duplicate tables

 Image Item  Description
 1.  Preview
 2.  Add New Custom Field
 3.  Duplicate Table
 4.  Delete Table
 5.  Additional Preferences

Note: Tables with accumulative build settings are highlighted with a dark blue color.

mini colors

Field Options

To view options available for fields, click on the field name or icon.

field options

The following options are available:

  • To edit the field name, click on the pencil pencil icon icon.
  • Type: Select the field type, for example, integer, date-time, or text.
  • Import: Clear this option if you do not want the data associated with this field imported as part of the ElastiCube build.
  • Invisible: Select this option if you want to import the data associated with this field, but do not want this field available to dashboard designers and viewers.
  • Indexed: Indexes the field data for quicker processing in subsequent builds.
  • Duplicate: Duplicates the field in the table. This is useful if you need the same field with some modifications.