API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 20th, 2019
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.86 KB | None | 0 0
raw download clone embed print report
  1. # If necessary, uncomment the line below to include explore_source.
  2. include: "HotTopicProd.model.lkml"
  3.  
  4. view: ht_derived_table_test {
  5. derived_table: {
  6. explore_source: dv_dm_f_meas_il_b {
  7. column: div_id { field: d_prd_div_lu.div_id }
  8. column: div_desc { field: d_prd_div_lu.div_desc }
  9. column: grp_desc { field: d_prd_itm_lu.grp_desc }
  10. column: dpt_desc { field: d_prd_itm_lu.dpt_desc }
  11. column: ht_cust_cls_desc { field: ht_cust_cls_desc.ht_cust_cls_desc }
  12. column: sbc_desc { field: d_prd_itm_lu.sbc_desc }
  13. column: sls_rtl {}
  14. column: sls_rtl_ly {}
  15. column: reg_sls_rtl {}
  16. column: reg_sls_rtl_ly {}
  17. column: clrnc_sls_rtl {}
  18. column: clrnc_sls_rtl_ly {}
  19. column: gm_amt {}
  20. column: gm_amt_ly {}
  21. column: regPro_gm {}
  22. column: regPro_gm_ly {}
  23. column: clrnc_gm {}
  24. column: clrnc_gm_ly {}
  25. column: sls_qty {}
  26. column: sls_qty_ly {}
  27. column: reg_sls_qty {}
  28. column: reg_sls_qty_ly {}
  29. column: clrnc_sls_qty {}
  30. column: clrnc_sls_qty_ly {}
  31. column: dc_eoh_cst {}
  32. column: dc_eoh_cst_ly {}
  33. column: sls_rtl_wtd {}
  34. column: sls_rtl_wtd_ly {}
  35. column: reg_sls_rtl_wtd {}
  36. column: reg_sls_rtl_wtd_ly {}
  37. column: clrnc_sls_rtl_wtd {}
  38. column: clrnc_sls_rtl_wtd_ly {}
  39. column: gm_amt_wtd {}
  40. column: gm_amt_wtd_ly {}
  41. column: clrnc_gm_wtd {}
  42. column: clrnc_gm_wtd_ly {}
  43. column: sls_qty_wtd {}
  44. column: sls_qty_wtd_ly {}
  45. column: reg_sls_qty_wtd {}
  46. column: reg_sls_qty_wtd_ly {}
  47. column: clrnc_sls_qty_wtd {}
  48. column: clrnc_sls_qty_wtd_ly {}
  49. column: sls_rtl_mtd {}
  50. column: sls_rtl_mtd_ly {}
  51. column: reg_sls_rtl_mtd {}
  52. column: reg_sls_rtl_mtd_ly {}
  53. column: clrnc_sls_rtl_mtd {}
  54. column: clrnc_sls_rtl_mtd_ly {}
  55. column: gm_amt_mtd {}
  56. column: gm_amt_mtd_ly {}
  57. column: clrnc_gm_mtd {}
  58. column: clrnc_gm_mtd_ly {}
  59. column: sls_qty_mtd {}
  60. column: sls_qty_mtd_ly {}
  61. column: reg_sls_qty_mtd {}
  62. column: reg_sls_qty_mtd_ly {}
  63. column: clrnc_sls_qty_mtd {}
  64. column: clrnc_sls_qty_mtd_ly {}
  65. column: sls_rtl_qtd {}
  66. column: sls_rtl_qtd_ly {}
  67. column: reg_sls_rtl_qtd {}
  68. column: reg_sls_rtl_qtd_ly {}
  69. column: clrnc_sls_rtl_qtd {}
  70. column: clrnc_sls_rtl_qtd_ly {}
  71. column: gm_amt_qtd {}
  72. column: gm_amt_qtd_ly {}
  73. column: clrnc_gm_qtd {}
  74. column: clrnc_gm_qtd_ly {}
  75. column: sls_qty_qtd {}
  76. column: sls_qty_qtd_ly {}
  77. column: reg_sls_qty_qtd {}
  78. column: reg_sls_qty_qtd_ly {}
  79. column: clrnc_sls_qty_qtd {}
  80. column: clrnc_sls_qty_qtd_ly {}
  81. column: sls_rtl_ytd {}
  82. column: sls_rtl_ytd_ly {}
  83. column: reg_sls_rtl_ytd {}
  84. column: reg_sls_rtl_ytd_ly {}
  85. column: clrnc_sls_rtl_ytd {}
  86. column: clrnc_sls_rtl_ytd_ly {}
  87. column: gm_amt_ytd {}
  88. column: gm_amt_ytd_ly {}
  89. column: clrnc_gm_ytd {}
  90. column: clrnc_gm_ytd_ly {}
  91. column: sls_qty_ytd {}
  92. column: sls_qty_ytd_ly {}
  93. column: reg_sls_qty_ytd {}
  94. column: reg_sls_qty_ytd_ly {}
  95. column: clrnc_sls_qty_ytd {}
  96. column: clrnc_sls_qty_ytd_ly {}
  97. filters: {
  98. field: dv_dm_f_meas_il_b.report_ccy_filter
  99. value: "USD"
  100. }
  101. filters: {
  102. field: d_curr_tim_lu_lw.last_week_filter
  103. value: "Yes"
  104. }
  105. }
  106. }
  107. dimension: div_id {
  108. primary_key: yes
  109. label: "02. Product Div ID"
  110. description: "Source system identifier for the Division in Product hierarchy"
  111. type: number
  112. }
  113. dimension: div_desc {
  114. label: "02. Product Div Desc"
  115. description: "Description for the Division in the Product hierarchy"
  116. }
  117. dimension: grp_desc {
  118. label: "02. Product Grp Desc"
  119. description: "Description for the Group in the Product hierarchy"
  120. }
  121. dimension: dpt_desc {
  122. label: "02. Product Dpt Desc"
  123. description: "The Description for the Department in the Product hierarchy"
  124. }
  125. dimension: ht_cust_cls_desc {
  126. label: "02. Product HT Cust Cls Desc"
  127. description: "Test"
  128. #drill_fields: [prod_hier_drill_fields*]
  129. }
  130. dimension: sbc_desc {
  131. label: "02. Product SubClass Desc"
  132. description: "The Description for the SubClass in the Product hierarchy"
  133. }
  134. dimension: sls_rtl {
  135. label: "09. Sales Sls"
  136. description: "Sales. The amount paid by the customer for merchandise sold/returned."
  137. value_format: "$#,##0;($#,##0)"
  138. type: number
  139. }
  140. dimension: sls_rtl_ly {
  141. label: "09. Sales Sls LY"
  142. description: "Sales Last Year. The previous years' amount paid by the customer for merchandise sold/returned."
  143. value_format: "$#,##0;($#,##0)"
  144. type: number
  145. }
  146. measure: sls_var {
  147. label: "001 Sls Var"
  148. sql: sls_rtl - sls_rtl_ly ;;
  149. type: number
  150. value_format_name: decimal_0
  151. }
  152. dimension: reg_sls_rtl {
  153. label: "09. Sales Reg Sls"
  154. description: "Regular Sales. The previous years' gross margin as a percent of sales for *regular* merchandise sold/returned."
  155. value_format: "$#,##0;($#,##0)"
  156. type: number
  157. }
  158. dimension: reg_sls_rtl_ly {
  159. label: "09. Sales Reg Sls LY"
  160. description: "Regular Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns."
  161. value_format: "$#,##0;($#,##0)"
  162. type: number
  163. }
  164. measure: reg_sls_var {
  165. label: "001 Reg Sls Var"
  166. sql: reg_sls_rtl - reg_sls_rtl_ly ;;
  167. type: number
  168. value_format_name: decimal_0
  169. }
  170. dimension: clrnc_sls_rtl {
  171. label: "09. Sales Clrnc Sls"
  172. description: "Clearance Sales. The amount paid by the customer for *clearance* merchandise sold/returned."
  173. value_format: "$#,##0;($#,##0)"
  174. type: number
  175. }
  176. dimension: clrnc_sls_rtl_ly {
  177. label: "09. Sales Clrnc Sls LY"
  178. description: "Clearance Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns."
  179. value_format: "$#,##0;($#,##0)"
  180. type: number
  181. }
  182. measure: clrnc_sls_var {
  183. label: "001 Clrnc Sls Var"
  184. sql: clrnc_sls_rtl - clrnc_sls_rtl_ly ;;
  185. type: number
  186. value_format_name: decimal_0
  187. }
  188. dimension: gm_amt {
  189. label: "10. Margin GM"
  190. description: "Gross Margin. The difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls] - [COGS]"
  191. value_format: "$#,##0;($#,##0)"
  192. type: number
  193. }
  194. dimension: gm_amt_ly {
  195. label: "10. Margin GM LY"
  196. description: "Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls LY] - [COGS LY]"
  197. value_format: "$#,##0;($#,##0)"
  198. type: number
  199. }
  200. dimension: regPro_gm {
  201. label: "10. Margin RegPro GM $"
  202. description: "Difference between gross profit and returns profit for regularly priced items."
  203. value_format: "$#,##0;($#,##0)"
  204. type: number
  205. }
  206. dimension: regPro_gm_ly {
  207. label: "10. Margin RegPro GM $ LY"
  208. description: "Sum of previous years' prmotional gorss margin amount and regular gross margin amount. "
  209. value_format: "$#,##0;($#,##0)"
  210. type: number
  211. }
  212. dimension: clrnc_gm {
  213. label: "10. Margin Clrnc GM"
  214. description: "Clearance Gross Margin. The difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls] - [Clrnc COGS]"
  215. value_format: "$#,##0;($#,##0)"
  216. type: number
  217. }
  218. dimension: clrnc_gm_ly {
  219. label: "10. Margin Clrnc GM LY"
  220. description: "Clearance Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls LY] - [Clrnc COGS LY]"
  221. value_format: "$#,##0;($#,##0)"
  222. type: number
  223. }
  224. dimension: sls_qty {
  225. label: "09. Sales Sls U"
  226. description: "Sales Units. The quantity (in units) of merchandise sold/returned."
  227. value_format: "#,##0"
  228. type: number
  229. }
  230. dimension: sls_qty_ly {
  231. label: "09. Sales Sls U LY"
  232. description: "Sales Units Last Year. The previous years' quantity (in units) of merchandise sold/returned."
  233. value_format: "#,##0"
  234. type: number
  235. }
  236. dimension: reg_sls_qty {
  237. label: "09. Sales Reg Sls U"
  238. description: "Regular Sales Units. The quantity (in units) of *regular* merchandise sold/returned."
  239. value_format: "#,##0"
  240. type: number
  241. }
  242. dimension: reg_sls_qty_ly {
  243. label: "09. Sales Reg Sls U LY"
  244. description: "Regular Sales Units Last Year. The previous years' quantity (in units) of *regular* merchandise sold/returned."
  245. value_format: "#,##0"
  246. type: number
  247. }
  248. dimension: clrnc_sls_qty {
  249. label: "09. Sales Clrnc Sls U"
  250. description: "Clearance Sales Units. The quantity (in units) of *clearance* merchandise sold/returned."
  251. value_format: "#,##0"
  252. type: number
  253. }
  254. dimension: clrnc_sls_qty_ly {
  255. label: "09. Sales Clrnc Sls U LY"
  256. description: "Clearance Sales Units Last Year. The previous years' quantity (in units) of *clearance* merchandise sold/returned."
  257. value_format: "#,##0"
  258. type: number
  259. }
  260. dimension: dc_eoh_cst {
  261. label: "11. Inventory DC EOH @Cst"
  262. description: "End-of-Period DC On Hand @Cost. The cost valuation of End-of-Period inventory on hand at DC's. Formula:[EOH @Cst] | DC locations"
  263. value_format: "$#,##0;($#,##0)"
  264. type: number
  265. }
  266. dimension: dc_eoh_cst_ly {
  267. label: "11. Inventory DC EOH @Cst LY"
  268. description: "End-of-Period DC On Hand @Cost Last Year. The previous years' cost valuation of End-of-Period inventory on hand at DC's. Formula:[EOH @Cst LY] | DC locations"
  269. value_format: "$#,##0;($#,##0)"
  270. type: number
  271. }
  272. dimension: sls_rtl_wtd {
  273. label: "09. Sales Sls WTD "
  274. description: "Sales. The amount paid by the customer for merchandise sold/returned. Week To Date"
  275. value_format: "$#,##0;($#,##0)"
  276. type: number
  277. }
  278. dimension: sls_rtl_wtd_ly {
  279. label: "09. Sales Sls WTD LY"
  280. description: "Sales Last Year. The previous years' amount paid by the customer for merchandise sold/returned. Week To Date"
  281. value_format: "$#,##0;($#,##0)"
  282. type: number
  283. }
  284. dimension: reg_sls_rtl_wtd {
  285. label: "09. Sales Reg Sls WTD "
  286. description: "Regular Sales. The previous years' gross margin as a percent of sales for *regular* merchandise sold/returned. Week To Date"
  287. value_format: "$#,##0;($#,##0)"
  288. type: number
  289. }
  290. dimension: reg_sls_rtl_wtd_ly {
  291. label: "09. Sales Reg Sls WTD LY"
  292. description: "Regular Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Week To Date"
  293. value_format: "$#,##0;($#,##0)"
  294. type: number
  295. }
  296. dimension: clrnc_sls_rtl_wtd {
  297. label: "09. Sales Clrnc Sls WTD "
  298. description: "Clearance Sales. The amount paid by the customer for *clearance* merchandise sold/returned. Week To Date"
  299. value_format: "$#,##0;($#,##0)"
  300. type: number
  301. }
  302. dimension: clrnc_sls_rtl_wtd_ly {
  303. label: "09. Sales Clrnc Sls WTD LY"
  304. description: "Clearance Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Week To Date"
  305. value_format: "$#,##0;($#,##0)"
  306. type: number
  307. }
  308. dimension: gm_amt_wtd {
  309. label: "09. Sales GM WTD "
  310. description: "Gross Margin. The difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls] - [COGS] Week To Date"
  311. value_format: "$#,##0;($#,##0)"
  312. type: number
  313. }
  314. dimension: gm_amt_wtd_ly {
  315. label: "09. Sales GM WTD LY"
  316. description: "Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls LY] - [COGS LY] Week To Date"
  317. value_format: "$#,##0;($#,##0)"
  318. type: number
  319. }
  320. dimension: clrnc_gm_wtd {
  321. label: "09. Sales Clrnc GM WTD "
  322. description: "Clearance Gross Margin. The difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls] - [Clrnc COGS] Week To Date"
  323. value_format: "$#,##0;($#,##0)"
  324. type: number
  325. }
  326. dimension: clrnc_gm_wtd_ly {
  327. label: "09. Sales Clrnc GM WTD LY"
  328. description: "Clearance Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls LY] - [Clrnc COGS LY] Week To Date"
  329. value_format: "$#,##0;($#,##0)"
  330. type: number
  331. }
  332. dimension: sls_qty_wtd {
  333. label: "09. Sales Sls U WTD "
  334. description: "Sales Units. The quantity (in units) of merchandise sold/returned. Week To Date"
  335. value_format: "#,##0"
  336. type: number
  337. }
  338. dimension: sls_qty_wtd_ly {
  339. label: "09. Sales Sls U WTD LY"
  340. description: "Sales Units Last Year. The previous years' quantity (in units) of merchandise sold/returned. Week To Date"
  341. value_format: "#,##0"
  342. type: number
  343. }
  344. dimension: reg_sls_qty_wtd {
  345. label: "09. Sales Reg Sls U WTD "
  346. description: "Regular Sales Units. The quantity (in units) of *regular* merchandise sold/returned. Week To Date"
  347. value_format: "#,##0"
  348. type: number
  349. }
  350. dimension: reg_sls_qty_wtd_ly {
  351. label: "09. Sales Reg Sls U WTD LY"
  352. description: "Regular Sales Units Last Year. The previous years' quantity (in units) of *regular* merchandise sold/returned. Week To Date"
  353. value_format: "#,##0"
  354. type: number
  355. }
  356. dimension: clrnc_sls_qty_wtd {
  357. label: "09. Sales Clrnc Sls U WTD "
  358. description: "Clearance Sales Units. The quantity (in units) of *clearance* merchandise sold/returned. Week To Date"
  359. value_format: "#,##0"
  360. type: number
  361. }
  362. dimension: clrnc_sls_qty_wtd_ly {
  363. label: "09. Sales Clrnc Sls U WTD LY"
  364. description: "Clearance Sales Units Last Year. The previous years' quantity (in units) of *clearance* merchandise sold/returned. Week To Date"
  365. value_format: "#,##0"
  366. type: number
  367. }
  368. dimension: sls_rtl_mtd {
  369. label: "09. Sales Sls MTD "
  370. description: "Sales. The amount paid by the customer for merchandise sold/returned. Month To Date"
  371. value_format: "$#,##0;($#,##0)"
  372. type: number
  373. }
  374. dimension: sls_rtl_mtd_ly {
  375. label: "09. Sales Sls MTD LY"
  376. description: "Sales Last Year. The previous years' amount paid by the customer for merchandise sold/returned. Month To Date"
  377. value_format: "$#,##0;($#,##0)"
  378. type: number
  379. }
  380. dimension: reg_sls_rtl_mtd {
  381. label: "09. Sales Reg Sls MTD "
  382. description: "Regular Sales. The previous years' gross margin as a percent of sales for *regular* merchandise sold/returned. Month To Date"
  383. value_format: "$#,##0;($#,##0)"
  384. type: number
  385. }
  386. dimension: reg_sls_rtl_mtd_ly {
  387. label: "09. Sales Reg Sls MTD LY"
  388. description: "Regular Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Month To Date"
  389. value_format: "$#,##0;($#,##0)"
  390. type: number
  391. }
  392. dimension: clrnc_sls_rtl_mtd {
  393. label: "09. Sales Clrnc Sls MTD "
  394. description: "Clearance Sales. The amount paid by the customer for *clearance* merchandise sold/returned. Month To Date"
  395. value_format: "$#,##0;($#,##0)"
  396. type: number
  397. }
  398. dimension: clrnc_sls_rtl_mtd_ly {
  399. label: "09. Sales Clrnc Sls MTD LY"
  400. description: "Clearance Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Month To Date"
  401. value_format: "$#,##0;($#,##0)"
  402. type: number
  403. }
  404. dimension: gm_amt_mtd {
  405. label: "09. Sales GM MTD "
  406. description: "Gross Margin. The difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls] - [COGS] Month To Date"
  407. value_format: "$#,##0;($#,##0)"
  408. type: number
  409. }
  410. dimension: gm_amt_mtd_ly {
  411. label: "09. Sales GM MTD LY"
  412. description: "Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls LY] - [COGS LY] Month To Date"
  413. value_format: "$#,##0;($#,##0)"
  414. type: number
  415. }
  416. dimension: clrnc_gm_mtd {
  417. label: "09. Sales Clrnc GM MTD "
  418. description: "Clearance Gross Margin. The difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls] - [Clrnc COGS] Month To Date"
  419. value_format: "$#,##0;($#,##0)"
  420. type: number
  421. }
  422. dimension: clrnc_gm_mtd_ly {
  423. label: "09. Sales Clrnc GM MTD LY"
  424. description: "Clearance Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls LY] - [Clrnc COGS LY] Month To Date"
  425. value_format: "$#,##0;($#,##0)"
  426. type: number
  427. }
  428. dimension: sls_qty_mtd {
  429. label: "09. Sales Sls U MTD "
  430. description: "Sales Units. The quantity (in units) of merchandise sold/returned. Month To Date"
  431. value_format: "#,##0"
  432. type: number
  433. }
  434. dimension: sls_qty_mtd_ly {
  435. label: "09. Sales Sls U MTD LY"
  436. description: "Sales Units Last Year. The previous years' quantity (in units) of merchandise sold/returned. Month To Date"
  437. value_format: "#,##0"
  438. type: number
  439. }
  440. dimension: reg_sls_qty_mtd {
  441. label: "09. Sales Reg Sls U MTD "
  442. description: "Regular Sales Units. The quantity (in units) of *regular* merchandise sold/returned. Month To Date"
  443. value_format: "#,##0"
  444. type: number
  445. }
  446. dimension: reg_sls_qty_mtd_ly {
  447. label: "09. Sales Reg Sls U MTD LY"
  448. description: "Regular Sales Units Last Year. The previous years' quantity (in units) of *regular* merchandise sold/returned. Month To Date"
  449. value_format: "#,##0"
  450. type: number
  451. }
  452. dimension: clrnc_sls_qty_mtd {
  453. label: "09. Sales Clrnc Sls U MTD "
  454. description: "Clearance Sales Units. The quantity (in units) of *clearance* merchandise sold/returned. Month To Date"
  455. value_format: "#,##0"
  456. type: number
  457. }
  458. dimension: clrnc_sls_qty_mtd_ly {
  459. label: "09. Sales Clrnc Sls U MTD LY"
  460. description: "Clearance Sales Units Last Year. The previous years' quantity (in units) of *clearance* merchandise sold/returned. Month To Date"
  461. value_format: "#,##0"
  462. type: number
  463. }
  464. dimension: sls_rtl_qtd {
  465. label: "09. Sales Sls QTD "
  466. description: "Sales. The amount paid by the customer for merchandise sold/returned. Quarter To Date"
  467. value_format: "$#,##0;($#,##0)"
  468. type: number
  469. }
  470. dimension: sls_rtl_qtd_ly {
  471. label: "09. Sales Sls QTD LY"
  472. description: "Sales Last Year. The previous years' amount paid by the customer for merchandise sold/returned. Quarter To Date"
  473. value_format: "$#,##0;($#,##0)"
  474. type: number
  475. }
  476. dimension: reg_sls_rtl_qtd {
  477. label: "09. Sales Reg Sls QTD "
  478. description: "Regular Sales. The previous years' gross margin as a percent of sales for *regular* merchandise sold/returned. Quarter To Date"
  479. value_format: "$#,##0;($#,##0)"
  480. type: number
  481. }
  482. dimension: reg_sls_rtl_qtd_ly {
  483. label: "09. Sales Reg Sls QTD LY"
  484. description: "Regular Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Quarter To Date"
  485. value_format: "$#,##0;($#,##0)"
  486. type: number
  487. }
  488. dimension: clrnc_sls_rtl_qtd {
  489. label: "09. Sales Clrnc Sls QTD "
  490. description: "Clearance Sales. The amount paid by the customer for *clearance* merchandise sold/returned. Quarter To Date"
  491. value_format: "$#,##0;($#,##0)"
  492. type: number
  493. }
  494. dimension: clrnc_sls_rtl_qtd_ly {
  495. label: "09. Sales Clrnc Sls QTD LY"
  496. description: "Clearance Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Quarter To Date"
  497. value_format: "$#,##0;($#,##0)"
  498. type: number
  499. }
  500. dimension: gm_amt_qtd {
  501. label: "09. Sales GM QTD "
  502. description: "Gross Margin. The difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls] - [COGS] Quarter To Date"
  503. value_format: "$#,##0;($#,##0)"
  504. type: number
  505. }
  506. dimension: gm_amt_qtd_ly {
  507. label: "09. Sales GM QTD LY"
  508. description: "Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls LY] - [COGS LY] Quarter To Date"
  509. value_format: "$#,##0;($#,##0)"
  510. type: number
  511. }
  512. dimension: clrnc_gm_qtd {
  513. label: "09. Sales Clrnc GM QTD "
  514. description: "Clearance Gross Margin. The difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls] - [Clrnc COGS] Quarter To Date"
  515. value_format: "$#,##0;($#,##0)"
  516. type: number
  517. }
  518. dimension: clrnc_gm_qtd_ly {
  519. label: "09. Sales Clrnc GM QTD LY"
  520. description: "Clearance Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls LY] - [Clrnc COGS LY] Quarter To Date"
  521. value_format: "$#,##0;($#,##0)"
  522. type: number
  523. }
  524. dimension: sls_qty_qtd {
  525. label: "09. Sales Sls U QTD "
  526. description: "Sales Units. The quantity (in units) of merchandise sold/returned. Quarter To Date"
  527. value_format: "#,##0"
  528. type: number
  529. }
  530. dimension: sls_qty_qtd_ly {
  531. label: "09. Sales Sls U QTD LY"
  532. description: "Sales Units Last Year. The previous years' quantity (in units) of merchandise sold/returned. Quarter To Date"
  533. value_format: "#,##0"
  534. type: number
  535. }
  536. dimension: reg_sls_qty_qtd {
  537. label: "09. Sales Reg Sls U QTD "
  538. description: "Regular Sales Units. The quantity (in units) of *regular* merchandise sold/returned. Quarter To Date"
  539. value_format: "#,##0"
  540. type: number
  541. }
  542. dimension: reg_sls_qty_qtd_ly {
  543. label: "09. Sales Reg Sls U QTD LY"
  544. description: "Regular Sales Units Last Year. The previous years' quantity (in units) of *regular* merchandise sold/returned. Quarter To Date"
  545. value_format: "#,##0"
  546. type: number
  547. }
  548. dimension: clrnc_sls_qty_qtd {
  549. label: "09. Sales Clrnc Sls U QTD "
  550. description: "Clearance Sales Units. The quantity (in units) of *clearance* merchandise sold/returned. Quarter To Date"
  551. value_format: "#,##0"
  552. type: number
  553. }
  554. dimension: clrnc_sls_qty_qtd_ly {
  555. label: "09. Sales Clrnc Sls U QTD LY"
  556. description: "Clearance Sales Units Last Year. The previous years' quantity (in units) of *clearance* merchandise sold/returned. Quarter To Date"
  557. value_format: "#,##0"
  558. type: number
  559. }
  560. dimension: sls_rtl_ytd {
  561. label: "09. Sales Sls YTD "
  562. description: "Sales. The amount paid by the customer for merchandise sold/returned. Year To Date"
  563. value_format: "$#,##0;($#,##0)"
  564. type: number
  565. }
  566. dimension: sls_rtl_ytd_ly {
  567. label: "09. Sales Sls YTD LY"
  568. description: "Sales Last Year. The previous years' amount paid by the customer for merchandise sold/returned. Year To Date"
  569. value_format: "$#,##0;($#,##0)"
  570. type: number
  571. }
  572. dimension: reg_sls_rtl_ytd {
  573. label: "09. Sales Reg Sls YTD "
  574. description: "Regular Sales. The previous years' gross margin as a percent of sales for *regular* merchandise sold/returned. Year To Date"
  575. value_format: "$#,##0;($#,##0)"
  576. type: number
  577. }
  578. dimension: reg_sls_rtl_ytd_ly {
  579. label: "09. Sales Reg Sls YTD LY"
  580. description: "Regular Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Year To Date"
  581. value_format: "$#,##0;($#,##0)"
  582. type: number
  583. }
  584. dimension: clrnc_sls_rtl_ytd {
  585. label: "09. Sales Clrnc Sls YTD "
  586. description: "Clearance Sales. The amount paid by the customer for *clearance* merchandise sold/returned. Year To Date"
  587. value_format: "$#,##0;($#,##0)"
  588. type: number
  589. }
  590. dimension: clrnc_sls_rtl_ytd_ly {
  591. label: "09. Sales Clrnc Sls YTD LY"
  592. description: "Clearance Sales Last Year. The previous years' price reduction at the point of sale due to promotional (i.e. temporary) markdowns. Year To Date"
  593. value_format: "$#,##0;($#,##0)"
  594. type: number
  595. }
  596. dimension: gm_amt_ytd {
  597. label: "09. Sales GM YTD "
  598. description: "Gross Margin. The difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls] - [COGS] Year To Date"
  599. value_format: "$#,##0;($#,##0)"
  600. type: number
  601. }
  602. dimension: gm_amt_ytd_ly {
  603. label: "09. Sales GM YTD LY"
  604. description: "Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of merchandise sold/returned. Formula:[Sls LY] - [COGS LY] Year To Date"
  605. value_format: "$#,##0;($#,##0)"
  606. type: number
  607. }
  608. dimension: clrnc_gm_ytd {
  609. label: "09. Sales Clrnc GM YTD "
  610. description: "Clearance Gross Margin. The difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls] - [Clrnc COGS] Year To Date"
  611. value_format: "$#,##0;($#,##0)"
  612. type: number
  613. }
  614. dimension: clrnc_gm_ytd_ly {
  615. label: "09. Sales Clrnc GM YTD LY"
  616. description: "Clearance Gross Margin Last Year. The previous years' difference between amount paid and the cost valuation of *clearance* merchandise sold/returned. Formula:[Clrnc Sls LY] - [Clrnc COGS LY] Year To Date"
  617. value_format: "$#,##0;($#,##0)"
  618. type: number
  619. }
  620. dimension: sls_qty_ytd {
  621. label: "09. Sales Sls U YTD "
  622. description: "Sales Units. The quantity (in units) of merchandise sold/returned. Year To Date"
  623. value_format: "#,##0"
  624. type: number
  625. }
  626. dimension: sls_qty_ytd_ly {
  627. label: "09. Sales Sls U YTD LY"
  628. description: "Sales Units Last Year. The previous years' quantity (in units) of merchandise sold/returned. Year To Date"
  629. value_format: "#,##0"
  630. type: number
  631. }
  632. dimension: reg_sls_qty_ytd {
  633. label: "09. Sales Reg Sls U YTD "
  634. description: "Regular Sales Units. The quantity (in units) of *regular* merchandise sold/returned. Year To Date"
  635. value_format: "#,##0"
  636. type: number
  637. }
  638. dimension: reg_sls_qty_ytd_ly {
  639. label: "09. Sales Reg Sls U YTD LY"
  640. description: "Regular Sales Units Last Year. The previous years' quantity (in units) of *regular* merchandise sold/returned. Year To Date"
  641. value_format: "#,##0"
  642. type: number
  643. }
  644. dimension: clrnc_sls_qty_ytd {
  645. label: "09. Sales Clrnc Sls U YTD "
  646. description: "Clearance Sales Units. The quantity (in units) of *clearance* merchandise sold/returned. Year To Date"
  647. value_format: "#,##0"
  648. type: number
  649. }
  650. dimension: clrnc_sls_qty_ytd_ly {
  651. label: "09. Sales Clrnc Sls U YTD LY"
  652. description: "Clearance Sales Units Last Year. The previous years' quantity (in units) of *clearance* merchandise sold/returned. Year To Date"
  653. value_format: "#,##0"
  654. type: number
  655. }
  656. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!