|
5ec3f1d9c1
|
put target rebuild in a proc
|
2025-09-08 08:50:28 -04:00 |
|
|
581224dad8
|
wrap in transaction
|
2025-09-06 15:59:51 -04:00 |
|
|
abac006970
|
work on filter before row number
|
2025-09-04 15:04:30 -04:00 |
|
|
9a410b82d1
|
break out base target table with proper index, and create separate refresh script
|
2025-08-27 15:07:57 -04:00 |
|
|
993a476bea
|
expand core targets and populate
|
2025-08-26 16:31:57 -04:00 |
|
|
f19bd138e3
|
gate the row_number function so that only target rows are processes Actuals for sales and Quotes for quotes
|
2025-08-25 17:31:37 -04:00 |
|
|
e9bd81f352
|
new table to store target price components
|
2025-08-21 15:30:08 -04:00 |
|
|
f2fe91f078
|
isolate version
|
2025-08-12 22:32:47 -04:00 |
|
|
eb7563f96c
|
include last part code and add item for total target price
|
2025-08-11 20:24:12 -04:00 |
|
|
310f1dc8f9
|
change last sale price flagging
|
2025-08-11 09:50:37 -04:00 |
|
|
5940300dee
|
refresh
|
2025-08-11 09:20:40 -04:00 |
|
|
2bf970eb06
|
convert to materialized view
|
2025-08-11 09:09:40 -04:00 |
|
|
da1b97f712
|
move files
|
2025-08-07 23:54:07 -04:00 |
|