Data Version Download

Download a data version table for available analytic objects, properties, and dimensions in your current data version.

Who can use this feature?

Users with the following:

  • Profile capabilities: Data: Read (access level), Detailed (view level)
  • Additional capabilities: Internal Debugging
  • Full data access: Access to all data such as the Super Admin permission

Not sure if you have this feature or capability? Reach out to your administrator.

Overview

The data version download allows you to download a data version table for available analytic objects, properties, and dimensions in your current data version as a TSV file. The file contains data produced by Visier's data processing job and represents the final state of your data for users to interact with. You can use this tool to validate your data records or to troubleshoot data issues by investigating the data tables that are read.

When reviewing the data version table, there are common things to look for, including:

  • If you're missing data check if the relevant records appear in the table or if there are values with spelling errors.

  • If data is calculated incorrectly check if the source values are different than what is appearing in the data version table. If they are different, when and how did it change over time? For example, let's say you're analyzing employee location data and an employee is missing from a location. To troubleshoot this in the data version table, check the location column for the specific employee to identify when the miscalculation may have occurred.

Download a data version table

  1. Do one of the following:

    To Do this
    In a project

    1. On the navigation, click Validation > Data Version Download.

    2. Select the analytic object, property, or dimension that you want to download the data version table for.
    In a project or the global workspace

    1. On the global navigation bar, click Data > Data Flow.

    2. Select a target and then click the More actions button .

    3. Click Download data version table. You can also quickly view the data version table in Visier. For more information, see View or download a data version table.

  2. Optional: Set the columns to download. If blank, the table contains all columns.
  3. Optional: Set the subject member IDs to download. If blank, the table contains all subject members.
  4. Optional: Define a range of rows to download. If blank, rows will start from the beginning of available data.
  5. Optional: Set the maximum number of rows to download. If blank, the default is set to 1000 rows.
  6. Optional: Filters the records for a custom date range.
  7. Optional: Include the actual values for dimension members. If not selected, dimension member values are represented as index numbers to minimize processing time (such as "1" or "2" for Hair Color). If selected, the actual values are displayed (such as "black" or "gray" for Hair Color).
  8. Optional: If the subject is included in multiple data categories, select the data category you want to download the data version table for.
  9. When finished, click Download.