Cubes Model Example: VVO

vvo_model.json

{
    "name" : "vvo",
    "locale":"en",
    "cubes": {
        "contracts" : {
            "name": "contracts",
            "measures": {
                "zmluva_hodnota": {"label": "Contract amount"}
            },
            "details": [
                {
                    "name": "zakazka_nazov", 
                    "label": "Contract name"
                },
                {
                    "name": "vestnik_cislo", 
                    "label": "Bulletin number"
                },
                {
                    "name": "source_url", 
                    "label": "Source URL"
                }
            ],
            "dimensions": [
                            "date",
                            "cpv",
                            "procurer",
                            "supplier",
                            "druh_postupu",
                            "kriteria_vyhodnotenia",
                            "geography"
                            ],
            "joins": [
                {
                    "master": "bulletin_date_id",
                    "detail": "dm_date.id"
                },
                {
                    "master": "cpv_id",
                    "detail": "dm_cpv.id"
                },
                {
                    "master": "obstaravatel_id",
                    "detail": "dm_procurer.id"
                },
                {
                    "master": "dodavatel_id",
                    "detail": "dm_supplier.id"
                },
                {
                    "master": "druh_postupu_id",
                    "detail": "dm_druh_postupu.id"
                },
                {
                    "master": "kriteria_vyhodnotenia_id",
                    "detail": "dm_kriteria_vyhodnotenia.id"
                },
                {
                    "master": "geography_id",
                    "detail": "dm_geography.id"
                }
            ],
            "mappings":
            {
                "zmluva_hodnota":"ft_vvo_contracts.zmluva_hodnota",
                "fact.date_id":"ft_vvo_contracts.bulletin_date_id",
                "fact.cpv_id":"ft_vvo_contracts.cpv_kod_id",
                "fact.obstaravatel_id":"ft_vvo_contracts.obstaravatel_org_id",
                "fact.dodavatel_id":"ft_vvo_contracts.dodavatel_id",
                "fact.druh_postupu_id":"ft_vvo_contracts.druh_postupu_id",
                "fact.kriteria_vyhodnotenia_id":"ft_vvo_contracts.kriteria_vyhodnotenia_id",
                "fact.region_id":"ft_vvo_contracts.geography_id"
            },
            "fact": "ft_vvo_contracts"
        }
    },
    
    "dimensions": {
        "cpv" : {
            "name": "cpv",
            "label": "Common Procurement Vocabulary",
            "key": "cpv_id",
            "levels": {
                "division" : {
                    "label": "division",
                    "label_attribute": "division_label",
                    "attributes": [
                        {"name":"division"},
                        {"name": "division_label", "locales": ["en", "sk"]},
                        {"name":"division_compet", "label": "competitiveness in division"}
                    ]
                },
                "group": {
                    "label": "group",
                    "label_attribute": "group_label",
                    "attributes": [
                        {"name":"group", "label": "Group code"},
                        {"name":"group_label", "label": "Group", "locales": ["en", "sk"]},
                        {"name":"group_compet", "label": "competitiveness in grouop"}
                    ]
                },
                "class": {
                    "label": "class",
                    "label_attribute": "class_label",
                    "attributes": [
                        {"name":"class"}, 
                        {"name":"class_label", "locales": ["en", "sk"]},
                        {"name":"class_compet", "label": "competitiveness in class"}
                        ]
                },
                "category": {
                    "label": "category",
                    "label_attribute": "category_label",
                    "attributes": [
                        {"name":"category", "label":"category code"}, 
                        {"name":"category_label", "label": "category", "locales": ["en", "sk"]},
                        {"name":"category_compet", "label": "competitiveness in category"}
                        ]
                },
                "detail": {
                    "label": "detail",
                    "label_attribute": "detail_label",
                    "attributes": [
                        {"name":"id"},
                        {"name":"detail", "label": "detail code"},
                        {"name":"detail_label", "label": "detail", "locales": ["en", "sk"]},
                        {"name":"code", "label": "CPV Code"},
                        {"name":"detail_compet", "label": "competitiveness"}
                        ]
                }
            },
            "hierarchies": {
                "default": { "levels": ["division", "group", "class", "category", "detail"] }
            }
        },
        "date" : {
            "label" : "datum",
            "levels" : {
                "year" : { 
                        "name": "year",
                        "label": "Year",
                        "attributes": [ 
                            {"name":"year"} 
                        ] 
                    },
                "month" : { 
                        "name": "month", 
                        "label" : "Month", 
                        "attributes": [
                            {"name":"month"},
                            {"name":"month_name", "locales": ["en", "sk"]}, 
                            {"name":"month_sname", "locales": ["en", "sk"]}
                        ] 
                    },
                "day" : {
                        "name": "day",
                        "label" : "Day",
                        "attributes": [
                            {"name":"id"},
                            {"name":"day"}] 
                    }
            },
            "hierarchies" : {
               "default": { "levels": ["year", "month", "day"] }
            }
        },
        "procurer" : {
            "label": "Procurer",
            "levels" : {
                "sector": {
                    "attributes":[
                        {"name":"account_sector_code", "label": "account sector code"},
                        {"name":"account_sector", "label": "account sector"}
                    ]
                },
                "procurer" : {
                    "label_attribute": "name",
                    "attributes": [
                        {"name":"id", "label": "id"}, 
                        {"name":"ico", "label": "organisation ID"}, 
                        {"name":"name", "label": "name"}, 
                        {"name":"region", "label": "region"}, 
                        {"name":"address", "label": "address"}, 
                        {"name":"legal_form", "label": "legal form"},
                        {"name":"offer_count_avg", "label": "average number of offers"},
                        {"name":"competitiveness", "label": "competitiveness"}
                    ]
                }
            },
            "hierarchy": ["sector", "procurer"]
        },
        "supplier" : {
            "label": "Supplier",
            "levels" : {
                "supplier" : {
                    "key": "id",
                    "label_attribute": "name",
                    "attributes": [
                        {"name":"id"}, 
                        {"name":"ico", "label": "company ID"}, 
                        {"name":"name", "label": "name"},
                        {"name":"address", "label": "address"},
                        {"name":"country", "label": "country"},
                        {"name":"date_start", "label": "operating since"},
                        {"name":"date_end", "label": "company closed date"},
                        {"name":"legal_form", "label": "legal form"},
                        {"name":"ownership", "label": "ownership"},
                        {"name":"offer_count_avg", "label": "average number of offers"},
                        {"name":"competitiveness", "label": "competitiveness"}
                        ]
                }
            }
        },
        "druh_postupu" : {
            "label": "Procurement type",
            "levels": {
                "druh_postupu": {
                    "label_attribute": "description",
                    "attributes" : [
                        {"name":"id"}, 
                        {"name":"code"}, 
                        {"name":"description", "locales": ["en", "sk"]}, 
                        {"name":"sdesc", "locales": ["en", "sk"]}]
                }
            }
        },
        "kriteria_vyhodnotenia" : {
            "label": "Evalutaion criteria",
            "levels": {
                "kriteria_vyhodnotenia": {
                    "label_attribute": "description",
                    "attributes" : [
                        {"name":"code"},
                        {"name":"description", "locales": ["en", "sk"]},
                        {"name":"sdesc", "locales": ["en", "sk"]},
                        {"name":"id"}]
                }
            }
        },
        "geography": {
            "label": "Region",
            "levels": {
                "okres": {
                    "attributes": [
                        {"name":"okres_code", "label": "county code"},
                        {"name":"okres", "label": "county"}
                        ]
                },
                "kraj": {
                    "attributes": [
                        {"name":"kraj_code", "label": "region code"},
                        {"name":"kraj", "label": "region"}
                        ]
                }
            },
            "hierarchies": {
                "default" : { "levels": ["kraj", "okres"] }
            }
            
        }
    }    
}