Sample dataset guide

This topic provides information about the sample dataset for Arria for MicroStrategy. This dataset is included in the sample dossier that you download in the Getting started tutorial.

Note

Click HERE to download the sample dataset in XLSX format.

Key terms

Term

Definition

Measure

A numeric, quantitative field in your data (e.g. Sales, Profit, or Units Sold).

Dimension

A categorical, qualitative field in your data (e.g. Segment or Product).

Dimension instance

A specific instance of a dimension (e.g. Glower for Product).

Time dimension

A special type of dimension that contains date values (e.g. Date).

 

Top

Measures in the dataset

The dataset includes the following measures:

  • COGS

  • Units Sold

  • Sales

  • Target Sales

  • Profit

Note

All of these measures are summable. Arria Answers does not support non-summable measures.

 

Top

Dimensions in the dataset

The dataset includes the following dimensions:

  • Product

  • Segment

  • Country

 

Top

Dimension instances

The dataset includes the following instances for each dimension:

Dimension

Dimension Instances

Product

  • Camoide

  • Glower

  • Nutrali

  • Ointmo

  • Karateon

  • Retine

Segment

  • Brand Store

  • Channel Partners

  • Chemists

  • Departmental

  • Online

Country

  • Germany

  • France

  • United States of America

  • Mexico

  • Canada

 

Top

Time dimensions in the dataset

A time dimension is a dimension field that contains date information. In the sample dataset, all date values are stored across multiple columns. MicroStrategy creates a field for each of these columns. The created fields are:

  • Year

  • Quarter

  • Month

  • Day

You can use these fields as time dimensions to analyze your data:

Note

You must set the Entity Type for each time dimension to DateTime in Step 1 of the Arria Answers wizard.

The following is a breakdown of each measure over each year present in the data:

AA_PBI data graph.png

 

Top