cief/dbt_cloud
1
0
Fork 0
mirror of https://gitlab.com/cief-data/dbt_cloud.git synced 2026-08-19 04:14:00 +00:00
Code Issues Packages Projects Releases Wiki Activity
211 Commits 23 Branches 0 Tags
main
Commit Graph

211 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
CIEF ACC1 df36b5dc5b Merge branch 'add-column-order-refund-datetime' into 'main' 
Added order refund datetime column to rep order table

See merge request cief-data/dbt_cloud!44
 2024-10-09 03:54:23 +00:00
CIEF ACC1 3b2a2555ae Added order refund datetime column to rep order table 2024-10-09 03:53:28 +00:00
CIEF ACC1 f074644647 Merge branch 'fix-shipping-invoice-value-sum-error' into 'main' 
Fix logic for summing invoice value

See merge request cief-data/dbt_cloud!43
 2024-08-07 09:55:09 +00:00
CIEF ACC1 a00089a40c Fix logic for summing invoice value 2024-08-07 09:53:15 +00:00
CIEF ACC1 82158d80dd Merge branch 'fix-shipping-stg-packages-node' into 'main' 
replaced model name in yml file

See merge request cief-data/dbt_cloud!42
 2024-07-01 06:57:08 +00:00
CIEF ACC1 d4ef402cb9 replaced model name in yml file 2024-07-01 06:56:18 +00:00
CIEF ACC1 6bea95c49f Merge branch 'fix-exchange-service-type-rename' into 'main' 
renamed to new service type

See merge request cief-data/dbt_cloud!41
 2024-05-13 05:21:47 +00:00
CIEF ACC1 ff552ebd0d renamed to new service type 2024-05-13 02:21:08 +00:00
CIEF ACC1 0db6785bc2 Merge branch 'build-wallet-cash-flow-analysis' into 'main' 
Build wallet cash flow analysis

See merge request cief-data/dbt_cloud!36
 2024-05-08 08:27:33 +00:00
CIEF ACC1 49fcb7f6e5 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis 2024-05-08 08:24:48 +00:00
CIEF ACC1 ca09264c80 Merge branch 'fix-exchange-delivery-on-time-logic' into 'main' 
Accommodate new service type and update on-time logic

See merge request cief-data/dbt_cloud!40
 2024-04-05 03:15:37 +00:00
Yam ZhengLim 6cbc293e25 Accommodate new service type and update on-time logic 2024-04-05 03:14:14 +00:00
CIEF ACC1 4ffb64a78b Merge branch 'build-exchange-rate-analysis' into 'main' 
Added metrics

See merge request cief-data/dbt_cloud!39
 2024-04-03 06:10:55 +00:00
CIEF ACC1 75910a77fe Added metrics 2024-04-03 06:10:11 +00:00
CIEF ACC1 cca60ea20f Merge branch 'build-exchange-rate-analysis' into 'main' 
Changed comparison competitor

See merge request cief-data/dbt_cloud!38
 2024-04-01 10:00:15 +00:00
CIEF ACC1 5fabf779d9 Changed comparison competitor 2024-04-01 09:58:59 +00:00
CIEF ACC1 9de1c91e50 Fixed corrupted stage model 2024-04-01 02:20:04 +00:00
CIEF ACC1 1b107599f6 updated logic to calculate wallet balance 2024-03-22 06:27:27 +00:00
CIEF ACC1 0550be2ed3 build wallet cash flow analysis 2024-03-15 07:15:38 +00:00
CIEF ACC1 05339a85ad Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis 2024-03-14 02:24:37 +00:00
Yam ZhengLim e52857c521 Merge branch 'lee_build_exchange_rate_fact' into 'main' 
Redefine order/cost value formual + Redefine on-time boolean logic

See merge request cief-data/dbt_cloud!35
 2024-03-12 16:23:59 +00:00
CIEF ACC1 d1e09ff1a6 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into build-wallet-cash-flow-analysis 2024-03-12 07:17:12 +00:00
CIEF ACC1 809763ab80 Merge branch 'main' of gitlab.com:cief-data/dbt_cloud into lee_build_exchange_rate_fact 2024-03-12 01:08:49 +00:00
CIEF ACC1 3c0ced171a Build cash flow analysis 2024-03-12 01:08:06 +00:00
CIEF ACC1 96b2b4861f Merge branch 'build-exchange-rate-analysis' into 'main' 
build exchange rate analysis

See merge request cief-data/dbt_cloud!34
 2024-03-07 09:05:51 +00:00
Yam ZhengLim 1b90eb6eda Changed file name for consistency 2024-03-07 09:04:01 +00:00
Yam ZhengLim 3341e41e9b change join reference 2024-03-07 07:57:01 +00:00
CIEF ACC1 7acfcad86a Merge branch 'main' into 'lee_build_exchange_rate_fact' 
# Conflicts:
#   models/marts/warehouse/fct_exchange__transaction_orders.sql
 2024-03-07 02:11:48 +00:00
CIEF ACC1 715f51ee35 Total order/cost value formula redefined 2024-03-07 02:05:22 +00:00
CIEF ACC1 2bee6b91ef Redefined on-time logic 2024-03-07 02:04:48 +00:00
Yam ZhengLim dd42248cdd build base wallets 2024-03-06 03:42:37 +00:00
Yam ZhengLim 3853e54dcf build exchange rate analysis 2024-03-06 02:25:59 +00:00
CIEF ACC1 85b6720569 Merge branch 'fix-new-order-refund-status' into 'main' 
added new status to order

See merge request cief-data/dbt_cloud!33
 2024-03-05 09:51:47 +00:00
Yam ZhengLim 57a700cc5d added new status to order 2024-03-05 09:50:11 +00:00
CIEF ACC1 fde8d9b5c1 Merge branch 'lee_build_rep_frozen_account_incidents' into 'main' 
Lee build rep frozen account incidents

See merge request cief-data/dbt_cloud!32
 2024-03-05 09:31:32 +00:00
Yam ZhengLim 9042df4c20 Merge branch 'lee_build_exchange_rate_fact' into 'main' 
Lee build exchange rate fact

See merge request cief-data/dbt_cloud!31
 2024-02-20 02:01:37 +00:00
CIEF ACC1 b174496caa Fix total_value_rm formula 2024-01-29 09:53:27 +00:00
CIEF ACC1 5c000c02fc Fix total_value_rm formula 2024-01-29 09:53:16 +00:00
CIEF ACC1 b6b7663bc2 build 2024-01-12 01:25:25 +00:00
CIEF ACC1 c959a292d6 build 2024-01-12 01:25:21 +00:00
CIEF ACC1 5297dd0756 build 2024-01-12 01:25:15 +00:00
Yam ZhengLim 50b7679080 Merge branch 'lee_build_rep_frozen_account_incidents' into 'main' 
Lee build rep frozen account incidents

See merge request cief-data/dbt_cloud!30
 2023-12-30 06:05:42 +00:00
CIEF ACC1 021cd467dc Added logic to identify migrated_companies 2023-12-29 10:32:28 +00:00
CIEF ACC1 20db620d27 added is_migrated_company, company_created_datetime, and next_order_datetime variable 2023-12-29 10:31:33 +00:00
CIEF ACC1 2912022f84 added next order datetime variable 2023-12-29 10:29:37 +00:00
CIEF ACC1 5f1a9b361d added is_credit_term_company variable 2023-12-29 09:48:22 +00:00
CIEF ACC1 c453c6189d added is_credit_term and is_migrated_company variable 2023-12-29 09:44:17 +00:00
CIEF ACC1 1b60be4522 Shipping data model - survival analysis 2023-12-29 09:43:22 +00:00
CIEF ACC1 a4c4fc83cb Shipping data model - rfm 2023-12-29 09:42:53 +00:00
CIEF ACC1 cfc1e36d9a Shipping data model - company lists 2023-12-29 09:42:08 +00:00