*** norbertbede <norbertbede!~Adium@94.228.91.62> has joined #idempiere | 05:51 | |
*** norbertbede <norbertbede!~Adium@94.228.91.62> has quit IRC | 06:39 | |
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has joined #idempiere | 06:49 | |
*** nmicoud <nmicoud!~Nicolas@2a01:e34:eeb6:cb10:494c:5473:a211:2d5b> has joined #idempiere | 07:42 | |
*** norbertbede2 <norbertbede2!~Adium@94.228.89.101> has joined #idempiere | 08:10 | |
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has joined #idempiere | 08:23 | |
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has quit IRC | 08:30 | |
*** Patric32 <Patric32!~Patric_32@090-006-045-005.ip-addr.inexio.net> has joined #idempiere | 08:31 | |
*** norbertbede2 <norbertbede2!~Adium@94.228.89.101> has quit IRC | 08:40 | |
Patric32 | Hi Carlos | 09:07 |
---|---|---|
CarlosRuiz | Hi Patric32 | 09:09 |
Patric32 | to the thread Migrating to git , i wrote you a pm over fb . hope this is okay ? | 09:09 |
CarlosRuiz | ah - let me check - I use facebook seldomly | 09:15 |
CarlosRuiz | got it | 09:16 |
*** norbertbede <norbertbede!~Adium@94.228.89.101> has joined #idempiere | 09:22 | |
norbertbede | hi @CarlosRuiz | 09:22 |
norbertbede | i had yesterday a skype chat with Deepak, regarding to Data aggregation, vs performance vs single source of truth. | 09:23 |
Patric32 | thank you very much Carlos | 09:24 |
norbertbede | our 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 |
CarlosRuiz | yw Patric32 | 09:25 |
CarlosRuiz | Hi norbertbede | 09:25 |
norbertbede | my 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 click | 09:25 |
CarlosRuiz | don't get the idea completely | 09:26 |
CarlosRuiz | you can recreate the storage to a certain date using M_Transaction | 09:26 |
norbertbede | yes. but this is expensive operation. and can be done by java ATM. so we cant use it in windows quickly | 09:27 |
norbertbede | for example: tab on product info: last 12 months sales.. | 09:28 |
CarlosRuiz | yes - is the same as the fact_acct_balance (the cube) against the fact_acct (the facts) | 09:29 |
norbertbede | this is really standard here in cheap sw - sure - we can implement it ourself. however interested in your opinion. maybe others implemented already | 09:29 |
CarlosRuiz | you have similar issue for example to find a business partner balance at some date (aging can do that recalculating) | 09:30 |
CarlosRuiz | and with storage | 09:30 |
norbertbede | yes i know. however storage and sales data is really critical if we calculate various way in various reports and cases | 09:30 |
CarlosRuiz | so, in principle you can do the same as was done for fact_acct - create an aggregate table | 09:31 |
CarlosRuiz | and then you have the same problems as that cube has | 09:31 |
norbertbede | that is the reason i'm dealing with the idea implement this automated way by pg functions, and simulate a simple datawarehouse | 09:31 |
norbertbede | so are you prefer java way ? | 09:33 |
CarlosRuiz | it depends on your needs | 09:33 |
norbertbede | my criteria: | 09:34 |
norbertbede | 1. do this on postgres side - do not like network roundrtip | 09:34 |
CarlosRuiz | for core is better to use java way - because of multi-db support | 09:34 |
CarlosRuiz | but for your custom needs - it can be better to do it in triggers - or using mviews | 09:34 |
norbertbede | 2. run it if possible with triggers (if required simulate queues) avoid shared and dead locks | 09:35 |
norbertbede | i found very good advice from citusdata… | 09:36 |
norbertbede | maybe anybody implement something similar ? | 09:37 |
norbertbede | share experience, code, effort. etc. | 09:37 |
CarlosRuiz | I haven't heard - would need to ask in forums | 09:38 |
norbertbede | ok. thanks, again experimenting :) ah | 09:39 |
*** Patric32 <Patric32!~Patric_32@090-006-045-005.ip-addr.inexio.net> has quit IRC | 10:41 | |
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has joined #idempiere | 12:15 | |
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has quit IRC | 12:24 | |
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has joined #idempiere | 12:26 | |
*** norbertbede1 <norbertbede1!~Adium@ag2.wkobjekt.to.cust.gts.sk> has quit IRC | 13:27 | |
Not | [IDEMPIERE] Nicolas Micoud created IDEMPIERE-4123 Env.parseVariable cannot use expression from current PO object | 17:02 |
Not | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-4123 | 17:02 |
Not | [IDEMPIERE] Nicolas Micoud updated IDEMPIERE-4123 Attachment set to "IDEMPIERE-4123.patch" | 17:03 |
Not | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-4123 | 17: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-4123 | 17:04 |
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has joined #idempiere | 17:26 | |
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has joined #idempiere | 17:56 | |
*** nmicoud <nmicoud!~Nicolas@2a01:e34:eeb6:cb10:494c:5473:a211:2d5b> has quit IRC | 18:19 | |
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has quit IRC | 18:47 | |
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has quit IRC | 21:08 | |
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has joined #idempiere | 21:20 | |
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has joined #idempiere | 21:33 | |
*** norbertbede1 <norbertbede1!~Adium@94.228.91.62> has quit IRC | 21:48 | |
*** CarlosRuiz <CarlosRuiz!~CarlosRui@ip-95-223-107-26.hsi16.unitymediagroup.de> has quit IRC | 22:06 | |
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has quit IRC | 23:54 |
Generated by irclog2html.py 2.17.1 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!