BI-Scripts/planner_vndfsc.dsc 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
version "1";
// Computer generated object language file
object 'DESC' "Main" {
	dictionary="vndfsc.dic",
	input="../data/vndfscdd.csv",
	output="../models/vndfsc.mdl",
	dimensions={
	"Vendor",
	"Vendor Rept Code",
	"Year-Month",
	"Warehouse",
	},
	summary={
	"Goal Cases",
	},
	info={
	"Vendor Rept Group:Vendor Rept Code",
	},
	string={
	},
	dump_key="True",
	ws=250000000,
	bf=100000,
	calcs={
	{
	name="Vendor",
	value="concat(Vendor Name,\" -- \",Vendor Number)"
},
	{
	name="Vendor Rept Code",
	value="concat(Vendor Report Code Desc,\" -- \",Vendor Report Code Number)"
},
	{
	name="Vendor Rept Group",
	value="concat(Vendor Report Group Desc,\" -- \",Vendor Report Group Number)"
},
	{
	name="Vendor Report Code Name",
	value="Vendor Report Code Desc"
},
	{
	name="Warehouse",
	value="concat(Warehouse City,\" -- \",Warehouse Number)"
},
	},
	require_permit_version=1
};