What is OLAP database?

2013-01-28 Thread 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 populated? Are there any jobs running? Thanks Winster T Jose Director - Technology and Architecture Chathurangam C

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

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 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 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 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: 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