net sales

1. Overview

Purpose of measure

To view report about Net Sales in some dimension and time range.

Measure Code

  • Strapi: Net Sales

  • OLAP:

  • LUIS: Net Sales

2. Data design

Data source

OLAP Design

3. Strapi Question Design

3.1.Available dimensions for ""

  • Store

  • Category

  • Channel

  • Subcategory

  • Sku

3.2.Available filters for ""

  • FilterCategory

  • FilterStore

  • FilterSubcategory

  • FilterChannel

  • FilterSku

  • FilterDay

  • FilterWeek

  • FilterMonth

  • FilterQuarter

  • FilterYear

3.3.Question Parameter

Measure

Dimension

Chart type

3.4.Expected Result

  • Net sales

  • Net sales by sku

  • Daily Net sales

3. LUIS Training

3.1 Question to ask

  • Net sales

  • Net sales by store

  • Net sales by sku

  • Net sales by category

  • Net sales by subcategory

  • Net sales by channel

  • Daily Net sales

  • weeekly Net sales

  • monthly Net sales

  • yearly Net sales

  • Net sales of store 123

  • Net sales of category apple

  • Net sales of subcategory phone

  • Net ales of sku 45343

  • Net sales of channel website

3.2 MeasureList:

3.3 Luis Training