| *** 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/!