#idempiere IRC log for Tuesday, 2019-12-03

*** norbertbede <norbertbede!~Adium@94.228.91.62> has joined #idempiere05:51
*** norbertbede <norbertbede!~Adium@94.228.91.62> has quit IRC06:39
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has joined #idempiere06:49
*** nmicoud <nmicoud!~Nicolas@2a01:e34:eeb6:cb10:494c:5473:a211:2d5b> has joined #idempiere07:42
*** norbertbede2 <norbertbede2!~Adium@94.228.89.101> has joined #idempiere08:10
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has joined #idempiere08:23
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has quit IRC08:30
*** Patric32 <Patric32!~Patric_32@090-006-045-005.ip-addr.inexio.net> has joined #idempiere08:31
*** norbertbede2 <norbertbede2!~Adium@94.228.89.101> has quit IRC08:40
Patric32Hi Carlos09:07
CarlosRuizHi Patric3209:09
Patric32to the thread Migrating to git , i wrote you a pm over fb . hope this is okay ?09:09
CarlosRuizah - let me check - I use facebook seldomly09:15
CarlosRuizgot it09:16
*** norbertbede <norbertbede!~Adium@94.228.89.101> has joined #idempiere09:22
norbertbedehi @CarlosRuiz09:22
norbertbedei had yesterday a skype chat with Deepak, regarding to Data aggregation, vs performance vs single source of truth.09:23
Patric32thank you very much Carlos09:24
norbertbedeour problem (i'm sure others has similar): storage levels we have m_storage which is calculated, but can't be run to date. to this we have storage valuation T_report. this lead to data inconsistency.09:24
CarlosRuizyw Patric3209:25
CarlosRuizHi norbertbede09:25
norbertbedemy vision: implement trigger driven db server side storage data aggregation. so this way we will have a single source of true. we can use it in info window, reports anywhere in one click09:25
CarlosRuizdon't get the idea completely09:26
CarlosRuizyou can recreate the storage to a certain date using M_Transaction09:26
norbertbedeyes. but this is expensive operation. and can be done by java ATM. so we cant use it in windows quickly09:27
norbertbedefor example: tab on product info: last 12 months sales..09:28
CarlosRuizyes - is the same as the fact_acct_balance (the cube) against the fact_acct (the facts)09:29
norbertbedethis is really standard here in cheap sw - sure - we can implement it ourself. however interested in your opinion. maybe others implemented already09:29
CarlosRuizyou have similar issue for example to find a business partner balance at some date (aging can do that recalculating)09:30
CarlosRuizand with storage09:30
norbertbedeyes i know. however storage and sales data is really critical if we calculate various way in various reports and cases09:30
CarlosRuizso, in principle you can do the same as was done for fact_acct - create an aggregate table09:31
CarlosRuizand then you have the same problems as that cube has09:31
norbertbedethat is the reason i'm dealing with the idea implement this automated way by pg functions, and simulate a simple datawarehouse09:31
norbertbedeso are you prefer java way ?09:33
CarlosRuizit depends on your needs09:33
norbertbedemy criteria:09:34
norbertbede1. do this on postgres side - do not like network roundrtip09:34
CarlosRuizfor core is better to use java way - because of multi-db support09:34
CarlosRuizbut for your custom needs - it can be better to do it in triggers - or using mviews09:34
norbertbede2. run it if possible with triggers (if required simulate queues) avoid shared and dead locks09:35
norbertbedei found very good advice from citusdata…09:36
norbertbedemaybe anybody implement something similar ?09:37
norbertbedeshare experience, code, effort. etc.09:37
CarlosRuizI haven't heard - would need to ask in forums09:38
norbertbedeok. thanks, again experimenting :) ah09:39
*** Patric32 <Patric32!~Patric_32@090-006-045-005.ip-addr.inexio.net> has quit IRC10:41
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has joined #idempiere12:15
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has quit IRC12:24
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has joined #idempiere12:26
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has quit IRC13:27
Not[IDEMPIERE] Nicolas Micoud created IDEMPIERE-4123 Env.parseVariable cannot use expression from current PO object17:02
Not[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-412317:02
Not[IDEMPIERE] Nicolas Micoud updated IDEMPIERE-4123 Attachment set to "IDEMPIERE-4123.patch"17:03
Not[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-412317:03
Not[IDEMPIERE] Nicolas Micoud updated IDEMPIERE-4123 assignee set to "Carlos Ruiz" -labels set to "+Patch"17:04
Not[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-412317:04
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has joined #idempiere17:26
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has joined #idempiere17:56
*** nmicoud <nmicoud!~Nicolas@2a01:e34:eeb6:cb10:494c:5473:a211:2d5b> has quit IRC18:19
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has quit IRC18:47
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has quit IRC21:08
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has joined #idempiere21:20
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has joined #idempiere21:33
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has quit IRC21:48
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has quit IRC22:06
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has quit IRC23:54

Generated by irclog2html.py 2.17.1 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!