Orchestra Business Intelligence User Console Basics : Business Intelligence Calculations : General sections
  

General sections

The following sections are available in several of the different cubes.
Branch
Name
Description
Branch
The name of the Branch, e.g “Mölndal”.
Country
The country where the Branch is located.
City
The city where the Branch is located.
 
 
Date
Name
Description
Week Number ISO
Week number for the Visit (ISO 8601 standard).
Week number
Week number for the Visit (US standard)
Day of week
The name of the week day for the Visit, e.g. ”Monday”
Year
The year for the Visit, e.g. 2013
Quarter
The quarter for the Visit, in the range 1-4.
Month
The month for the Visit, e.g. ”January”
Day of Month
The day of the Visit, in the range 1-31
Staff
Name
Description
Staff Name
The username of the staff handling the Visit transaction
Last Name
The last name of the staff handling the Visit transaction
First Name
The first name of the staff handling the Visit transaction
Time
Name
Description
Hour
The hour (0-23) the event was created
Minute
The minute the event was created
Interval 5 min
The interval_5_min_24 from dim time
Interval 10 min
The interval_10_min_24 from dim_time
Interval 15 min
The interval_15_min_24 from dim_time
Interval 30 min
The interval_30_min_24 from dim_time
All hours, minutes and intervals are included, also those without any stat data. Start hour is the first hour with stat data and end hour is the last hour with stat data. For example, if the first stat event is 08:12 in the morning and the last is 17:21 the analysis report should include all hours, minutes and intervals from 08:00 and until 17:59.