Re: What is OLAP database?

2013-01-29 Thread Atul Vani
https://issues.apache.org/jira/browse/OFBIZ-5128 Thanks Jacques. On Tue, 29 Jan 2013 14:40:03 +0530, Atul Vani wrote: Got this error when I hit the "Quick Init DataWarehouse" button. Just reporting. ERROR: Could not complete the [file:/home/ofbiz/trunk/applications/order/script/org/of

Re: What is OLAP database?

2013-01-29 Thread Jacques Le Roux
Hi Atul, Please open a Jira Thanks Jacques From: "Atul Vani" > Got this error when I hit the "Quick Init DataWarehouse" button. Just > reporting. > > ERROR: Could not complete the > [file:/home/ofbiz/trunk/applications/order/script/org/ofbiz/order/olap/FactServices.xml#loadSalesOrderItemF

Re: Ofbiz process gets killed abruptly without any clue

2013-01-29 Thread Varun Bhansaly
What is the h/w configuration of the box on which OFBiz and DB are hosted ? What is the size of the database ? Have you tried analyzing the JVM crash log files generated after the crash ? Have you tried any of the memory profiling tools ? On Wed, Jan 30, 2013 at 1:22 AM, Deepak Agarwal wrote: > I

Re: Purchase Order is not created

2013-01-29 Thread Deepak Agarwal
After approving the requirements you need to go to the supplier-requirement view where you can see all the requirements applied to a supplier and from there you can initiate the purchase order. There is no purchase order for every approved requirement but all the approved requirements are clubbed

Re: What is OLAP database?

2013-01-29 Thread Atul Vani
Got this error when I hit the "Quick Init DataWarehouse" button. Just reporting. ERROR: Could not complete the [file:/home/ofbiz/trunk/applications/order/script/org/ofbiz/order/olap/FactServices.xml#loadSalesOrderItemFact] process [problem invoking the [convertUomCurrency] service with the

Re: What is OLAP database?

2013-01-29 Thread Winster Jose
Thanks Jacques and Deepak. It was informative. Btw, when I checked the OLAP database of my tenant, I could not find any tables there. I execute "run-create-tenant ant task" to create a tenant. Do I need to manually create these tables for OLAP database for each tenant or is there an automated metho

Re: What is OLAP database?

2013-01-29 Thread Deepak Agarwal
There are tools (like Spago BI) available which takes the data from the relational db and make the facts and dimensions. Since in ofbiz it is only at POC level as of now, so would it be better if chooise spago bi over ofbiz's olap db ? On Tue, Jan 29, 2013 at 1:49 PM, Jacques Le Roux < jacques.le.

Re: What is OLAP database?

2013-01-29 Thread Jacques Le Roux
Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main Jacques From: "Winster Jose" > Hi, > > Can someone please throw some light on OLAP database? I understand that it > is basically a star schema mainly used for reports. But how are the values > in Dimension and Fact tables popula