axpense-api/ExpenseChannelList.txt at master · UintaGroup/axpense-api · 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
  --  SELECT [DISPLAYVALUE]
  --FROM [DAXSTAGE].[dbo].[DIMENSIONATTRIBUTEVALUESETITEM]
  --WHERE [DIMENSIONATTRIBUTEVALUESETITEM].DIMENSIONATTRIBUTEVALUE IN
  --(
	 -- SELECT [DIMENSIONATTRIBUTEVALUE].RECID
	 -- FROM [DAXSTAGE].[dbo].[DIMENSIONATTRIBUTEVALUE]
	 -- INNER JOIN [DIMENSIONATTRIBUTE] DI on DI.RECID = [DIMENSIONATTRIBUTEVALUE].DIMENSIONATTRIBUTE
	 -- WHERE DI.NAME = 'Channel'
  --)
  --GROUP BY [DISPLAYVALUE]
  --ORDER BY [DISPLAYVALUE]

  DISPLAYVALUE
CAN
DEU
DOM
ESP
FRA
GBR
INT
JPN
KOR
MEX

List of current Channel:
Dimension value	        Description
CAN	                    Canada
DEU	                    Germany
DOM	                    Domestic
ESP	                    Spain
FRA	                    France
GBR	                    United Kindgom
INT	                    International
JPN	                    Japan
KOR	                    Korea, Republic of
MEX	                    Mexico