def test_destinationcountry_country_country(self):
level_fullname = "[Destination Country].[Country].[Country]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "FOB US"
measure_sum = sum(item["FOB US"] for item in result)
self.assertEqual(measure_sum, 414316305677.0713)
def test_geography_region(self):
level_fullname = "[Geography].[Region]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 3171731.0)
def test_year_year(self):
level_fullname = "[Year].[Year]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 3209428.0)
def test_isiccaenes_isiccaenes(self):
level_fullname = "[ISIC CAENES].[ISIC CAENES]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 2645603.0)
def test_sex_sex(self):
level_fullname = "[Sex].[Sex]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 10030835.0)
def test_geography_region(self):
level_fullname = "[Geography].[Region]"
result = query(CUBE, MEASURES_AVG, level_fullname)
# Check values for measure "Primary Healthcare AVG"
average_sum = 15839270.433333334
average_count = 15
retrieved_values = [item["Primary Healthcare AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
# Check values for measure "Specialized Healthcare AVG"
average_sum = 7168714.966666666
average_count = 15
retrieved_values = [item["Specialized Healthcare AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
# Check values for measure "Urgency Healthcare AVG"
average_sum = 19107283.183333334
average_count = 15
retrieved_values = [item["Urgency Healthcare AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
# Check values for measure "Dental Discharges Per 100 inhabitants AVG"
average_sum = 120.67514924208322
average_count = 15
retrieved_values = [item["Dental Discharges Per 100 inhabitants AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
def test_generaleconomiccondition_generaleconomiccondition(self):
level_fullname = "[General Economic Condition].[General Economic Condition]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 10030835.0)
def test_sex_sex(self):
level_fullname = "[Sex].[Sex]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "Population"
measure_sum = sum(item["Population"] for item in result)
self.assertEqual(measure_sum, 279246382.0)
def test_date_month(self):
level_fullname = "[Date].[Month]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 527089.0)
def test_agerange_agerange(self):
level_fullname = "[Age Range].[Age Range]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 188224.0)
def test_geography_region(self):
level_fullname = "[Geography].[Region]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "Population"
measure_sum = sum(item["Population"] for item in result)
self.assertEqual(measure_sum, 279246382.0)
def test_geography_region(self):
level_fullname = "[Geography].[Region]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "FOB US"
measure_sum = sum(item["FOB US"] for item in result)
self.assertEqual(measure_sum, 414313367696.0)
def test_geography_comuna(self):
level_fullname = "[Geography].[Comuna]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "FOB US"
measure_sum = sum(item["FOB US"] for item in result)
self.assertEqual(measure_sum, 414314489632.53516)
def test_exporths_hs_hs4(self):
level_fullname = "[Export HS].[HS].[HS4]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "FOB US"
measure_sum = sum(item["FOB US"] for item in result)
self.assertEqual(measure_sum, 414317607608.5573)
def test_visatype_visatype(self):
level_fullname = "[Visa Type].[Visa Type]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1494873.0)
def test_storecreditcard_binarysurveyresponse_binarysurveyresponse(self):
level_fullname = "[Store Credit Card].[Binary Survey Response].[Binary Survey Response]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 527089.0)
def test_date_year(self):
level_fullname = "[Date].[Year]"
result = query(CUBE, MEASURES_AVG, level_fullname)
# Check values for measure "Primary Healthcare AVG"
average_sum = 5129687.411111111
average_count = 5
retrieved_values = [item["Primary Healthcare AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
# Check values for measure "Specialized Healthcare AVG"
average_sum = 2327705.588888889
average_count = 5
retrieved_values = [item["Specialized Healthcare AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
# Check values for measure "Urgency Healthcare AVG"
average_sum = 6200857.08888889
average_count = 5
retrieved_values = [item["Urgency Healthcare AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
# Check values for measure "Dental Discharges Per 100 inhabitants AVG"
average_sum = 39.81082196765476
average_count = 5
retrieved_values = [item["Dental Discharges Per 100 inhabitants AVG"] or 0 for item in result]
self.assertEqual(average_sum, sum(retrieved_values))
self.assertEqual(average_count, len(retrieved_values))
def test_activity_activity(self):
level_fullname = "[Activity].[Activity]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1556618.0)
def test_date_movingquarter(self):
level_fullname = "[Date].[Moving Quarter]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 10030835.0)
def test_calculatedagerange_agerange(self):
level_fullname = "[Calculated Age Range].[Age Range]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1494873.0)
def test_isco_isco(self):
level_fullname = "[ISCO].[ISCO]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 4353563.0)
def test_date_year(self):
level_fullname = "[Date].[Year]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1494873.0)
def test_occupationalsituation_occupationalsituation(self):
level_fullname = "[Occupational Situation].[Occupational Situation]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 10030835.0)
def test_education_education(self):
level_fullname = "[Education].[Education]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1494873.0)
def test_administration_administration(self):
level_fullname = "[Administration].[Administration]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 3209428.0)
def test_geography_comuna(self):
level_fullname = "[Geography].[Comuna]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1494873.0)
def test_institution_institution(self):
level_fullname = "[Institution].[Institution]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of records"
measure_sum = sum(item["Number of records"] for item in result)
self.assertEqual(measure_sum, 3152985.0)
def test_origincountry_country_country(self):
level_fullname = "[Origin Country].[Country].[Country]"
result = query(CUBE, MEASURES_COUNT, level_fullname)
# Check sum for measure "Number of visas"
measure_sum = sum(item["Number of visas"] for item in result)
self.assertEqual(measure_sum, 1494873.0)
def test_higherinstitutions_higherinstitutionsubgroup(self):
level_fullname = "[Higher Institutions].[Higher Institution Subgroup]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "Sum anual payment 2016"
measure_sum = sum(item["Sum anual payment 2016"] for item in result)
self.assertEqual(measure_sum, 3784407743.0)
def test_date_year(self):
level_fullname = "[Date].[Year]"
result = query(CUBE, MEASURES_SUM, level_fullname)
# Check sum for measure "FOB US"
measure_sum = sum(item["FOB US"] for item in result)
self.assertEqual(measure_sum, 414308814848.0)
