Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Add Custom Data to a Jet Analytics Project


The Jet Data Manager allows you to insert your own data into tables, whether they come from a data source or are created in the Jet Data Manager as custom tables. An example of where this would be useful is when you have data that you wish to use in the data warehouse or cubes, but the data does not presently exist in a source database. Records can be inserted into these tables in either the Staging or Data Warehouse areas of a project.

There are two methods of creating custom data:

  1. Manually enter the records
  2. Import the records via the Import feature (note that this feature requires that the drivers for Excel are installed)

The two examples below illustrate how to perform each method by inserting a list of holidays into a custom Holidays table.

  1. How to manually insert records

      1. Right-click the Tables node, and select Add Custom Table

        mceclip0.png

      2. Give the table a descriptive name and press OK
        mceclip2.png
      3. Add two custom fields named Date and Description

        mceclip4.png

        mceclip5.png

        mceclip6.png

      4. Right-click the Holidays table, and navigate to Advanced >> Custom Data

        mceclip7.png
      5. Manually enter the dates and descriptions of holidays. When finished, click OK .

        mceclip8.png
  2. How to insert records via file import

    1. Prepare an Excel file that contains the data that you wish to import. In the spreadsheet, give descriptive names to your column headers , and save the file to a path that can be accessed from within the Jet Data Manager

      mceclip9.png
    2. On the same screen as Step #5 above, click the Import Data button
    3. On the next screen, you can perform the following steps;

      mceclip10.png

      1.  Click Select File , and navigate to the path of where your Excel document is saved
      2.  In the Work Sheets drop-down, pick which sheet from your workbook contains your data
      3.  Check the box Remove Existing Data to have the Jet Data Manager delete any records that may already exist in the table you are importing data into
      4.  In the drop-down fields, map the columns in the spreadsheet to the columns in your table

    4. Click OK .

      mceclip8.png
Was this article helpful?
0 out of 0 found this helpful

Comments