BI-Scripts/qv_models.int at master · OMR5221/BI-Scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
version "1";

object 'PARM' "Parms" {parms={
	{name="OUTDIR"},
	{name="YEAREND",type="boolean",default="false"},
	{name="TYPE"}, // only required for yearend
}};

object 'TSKL' "Main" {
   {
	"goal summary",
	"goal type",
	"sales measure",
   }
};

object 'TASK' "goal summary" {
   inputs     = {
	"goal summary list",
   },
   output     = "goal summary build"
};


object 'INPT'   "goal summary list" {
   input_type   = "list",
   columns      = {"Goal Metric"},
   values       = {{"Cases"},{"9L"},{"CE"}},
};

object 'OUTP'   "goal summary build" {
   output_type  = "builder",
   input        = "goal summary list",
#if YEAREND
   output       = `/di/yearend/models/$(TYPE)/$(OUTDIR)/goal_summary.mdl`,
#else
   output       = `../newmodels/$(OUTDIR)/goal_summary.mdl`,
#endif
   dimensions   = {"Goal Metric"},
};


object 'TASK' "goal type" {
   inputs     = {
	"goal type list",
   },
   output     = "goal type build"
};


object 'INPT'   "goal type list" {
   input_type   = "list",
   columns      = {"Goal Type"},
   values       = {{"Current"},{"Original"}},
};

object 'OUTP'   "goal type build" {
   output_type  = "builder",
   input        = "goal type list",
#if YEAREND
   output       = `/di/yearend/models/$(TYPE)/$(OUTDIR)/goal_type.mdl`,
#else
   output       = `../newmodels/$(OUTDIR)/goal_type.mdl`,
#endif
   dimensions   = {"Goal Type"},
};


object 'TASK' "sales measure" {
   inputs     = {
	"sales measure list",
   },
   output     = "sales measure build"
};


object 'INPT'   "sales measure list" {
   input_type   = "list",
   columns      = {"Measure"},
   values       = {{"Cases"},{"Flat Cases"},{"Dollars"},{"9L"},{"CE"},{"VS Cases"},{"VS 9L"},{"VS CE"}},
};

object 'OUTP'   "sales measure build" {
   output_type  = "builder",
   input        = "sales measure list",
#if YEAREND
   output       = `/di/yearend/models/$(TYPE)/$(OUTDIR)/Measure.mdl`,
#else
   output       = `../newmodels/$(OUTDIR)/Measure.mdl`,
#endif
   dimensions   = {"Measure"},
};