InfinitePOS

InfiniteERP + UnicentaPOS = ERP for retail solution. Full integrated, robust, flexible, and scalable.

How to tune postgresql performance for OLTP application

postgresql come with average confirguration for average hardware, make it available for all people across the globe. if your hardware above the average, you need to fine tune, to optimize postgresql performance. fortunately, before postgresql reach it's limit, your hardware reach the limit. for your information, I use postgresql 9.6 and linux mint (ubuntu based) … Continue reading How to tune postgresql performance for OLTP application

How to use Dynamic Dimension YTD, QTD, MTD, WTD in Pentaho

you can make accumulated measurement using Dynamic Dimension. instead of periodical measurement, you can make an "as per date" measurement. current stock is an perfect example of accumulated measurement of inventory transaction, that accumulated from the begining to current date. as you may know, pentaho mondrian OLAP cube build from a flat table, consist of several … Continue reading How to use Dynamic Dimension YTD, QTD, MTD, WTD in Pentaho