market_views.yaml.example 2.23 KB
Newer Older
1
-
2
    alias: "view:Product"
3
    data: "test/postgres/fixtures/product.json"
4
    origin: true
5
    aliasAsName: true
6 7 8 9 10 11 12 13 14 15 16 17
    dimensions:
        - "dim:product:name"
        - "dim:product:validity"
        - "dim:product:id"
    metrics:
        - "met:product:avg:pricein"
        - "met:product:max:pricein"
        - "met:product:min:pricein"
        - "met:product:avg:priceout"
        - "met:product:max:priceout"
        - "met:product:min:priceout"
-
18
    alias: "view:Client"
19
    data: "test/postgres/fixtures/client.json"
20
    origin: true
21
    aliasAsName: true
22 23 24 25 26
    dimensions:
        - "dim:client:name"
        - "dim:client:cpf"
        - "dim:client:id"    
-
27
    alias: "view:Sell"
28
    data: "test/postgres/fixtures/sell.json"
29
    origin: true
30
    aliasAsName: true
31 32
    dimensions:
        - "dim:sell:registered"
33 34 35
        - "dim:product:id"
        - "dim:seller:id"
        - "dim:client:id"
36 37 38 39 40 41
        - "dim:sell:datein"
    metrics:
        - "met:sell:sum:quantity"
        - "met:sell:avg:quantity"
        - "met:sell:count:quantity"
-
42
    alias: "view:Buyout"
43
    data: "test/postgres/fixtures/buyout.json"
44
    origin: true
45
    aliasAsName: true
46 47
    dimensions:
        - "dim:buyout:datein"
48 49
        - "dim:provider:id"
        - "dim:product:id"
50 51 52 53 54
    metrics:
        - "met:buyout:avg:quantity"
        - "met:buyout:max:quantity"
        - "met:buyout:min:quantity"
-
55
    alias: "view:Provider"
56
    data: "test/postgres/fixtures/provider.json"
57
    origin: true
58
    aliasAsName: true
59 60 61 62
    dimensions:
        - "dim:provider:name"
        - "dim:provider:id"   
-
63
    alias: "view:Distribute"
64
    data: "test/postgres/fixtures/distribute.json"
65
    origin: true
66
    aliasAsName: true
67
    dimensions:
68 69 70
        - "dim:provider:id"
        - "dim:product:id"
-
71
    alias: "view:ActiveSeller"
72 73
    data: "test/postgres/fixtures/activeseller.json"
    origin: true
74
    aliasAsName: true
75 76 77 78 79 80 81
    dimensions:
        - "dim:seller:name"
        - "dim:seller:status"
    metrics:
        - "met:seller:max:age"
    clauses:
        - "dim:seller:status==active"
82 83 84 85 86 87 88 89 90
-
    alias: "view:SellerStatus"
    data: "test/postgres/fixtures/sellerstatus.json"
    origin: false
    aliasAsName: true
    metrics:
        - "met:seller:count:age"
    dimensions:
        - "dim:seller:status"