What is OLAP database?

[Winster]

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 Creative Solutions Private Ltd.
Cell: [phone]
Mail: [hidden email]

[Jacques Le Roux]

Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main

Jacques

From: "Winster Jose" <[hidden email]>

> 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 Creative Solutions Private Ltd.
> Cell: [phone]
> Mail: [hidden email]
>

[Deepak Agarwal-2]

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 <
[hidden email]> wrote:

> Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main
>
> Jacques
>
> From: "Winster Jose" <[hidden email]>
> > 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 Creative Solutions Private Ltd.
> > Cell: [phone]
> > Mail: [hidden email]
> >
>

--
Thanks,
Deepak Agarwal,

Mobile: [phone]

[Winster]

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 method?

Thanks in advance
Winster

On Tue, Jan 29, 2013 at 2:19 PM, Deepak Agarwal <[hidden email]>wrote:

> 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 <
> [hidden email]> wrote:
>
> > Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main
> >
> > Jacques
> >
> > From: "Winster Jose" <[hidden email]>
> > > 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 Creative Solutions Private Ltd.
> > > Cell: [phone]
> > > Mail: [hidden email]
> > >
> >
>
>
>
> --
> Thanks,
> Deepak Agarwal,
>
> Mobile: [phone]
>

--
Winster T Jose
Director - Technology and Architecture
Chathurangam Creative Solutions Private Ltd.
Cell: [phone]
Mail: [hidden email]

[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 map  
named [convertUomCurrencyMap] containing [{uomId=USD, uomIdTo=USD,  
userLogin=[GenericEntity:UserLogin][createdStamp,2013-01-29  
08:12:42.373(java.sql.Timestamp)][createdTxStamp,2013-01-29  
08:12:42.358(java.sql.Timestamp)][currentPassword,{SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en(java.lang.String)][lastTimeZone,null()][lastUpdatedStamp,2013-01-29  
08:30:34.189(java.sql.Timestamp)][lastUpdatedTxStamp,2013-01-29  
08:30:34.188(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)],  
locale=en}]: The following required parameter is missing: [IN]  
[convertUomCurrency.nowDate]]

--
Thanks & Regards
Atul Vani

On Tue, 29 Jan 2013 13:49:15 +0530, Jacques Le Roux  
<[hidden email]> wrote:

> Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main
>
> Jacques
>
> From: "Winster Jose" <[hidden email]>
>> 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 Creative Solutions Private Ltd.
>> Cell: [phone]
>> Mail: [hidden email]
>>

--
Using Opera's revolutionary email client: http://www.opera.com/mail/

[Jacques Le Roux]

Hi Atul,

Please open a Jira

Thanks

Jacques

From: "Atul Vani" <[hidden email]>

> 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 map  
> named [convertUomCurrencyMap] containing [{uomId=USD, uomIdTo=USD,  
> userLogin=[GenericEntity:UserLogin][createdStamp,2013-01-29  
> 08:12:42.373(java.sql.Timestamp)][createdTxStamp,2013-01-29  
> 08:12:42.358(java.sql.Timestamp)][currentPassword,{SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en(java.lang.String)][lastTimeZone,null()][lastUpdatedStamp,2013-01-29  
> 08:30:34.189(java.sql.Timestamp)][lastUpdatedTxStamp,2013-01-29  
> 08:30:34.188(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)],  
> locale=en}]: The following required parameter is missing: [IN]  
> [convertUomCurrency.nowDate]]
>
> --
> Thanks & Regards
> Atul Vani
>
> On Tue, 29 Jan 2013 13:49:15 +0530, Jacques Le Roux  
> <[hidden email]> wrote:
>
>> Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main
>>
>> Jacques
>>
>> From: "Winster Jose" <[hidden email]>
>>> 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 Creative Solutions Private Ltd.
>>> Cell: [phone]
>>> Mail: [hidden email]
>>>
>
>
> --
> Using Opera's revolutionary email client: http://www.opera.com/mail/

[Atul Vani]

https://issues.apache.org/jira/browse/OFBIZ-5128

Thanks Jacques.

On Tue, 29 Jan 2013 14:40:03 +0530, Atul Vani <[hidden email]>  
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/ofbiz/order/olap/FactServices.xml#loadSalesOrderItemFact]  
> process [problem invoking the [convertUomCurrency] service with the map  
> named [convertUomCurrencyMap] containing [{uomId=USD, uomIdTo=USD,  
> userLogin=[GenericEntity:UserLogin][createdStamp,2013-01-29  
> 08:12:42.373(java.sql.Timestamp)][createdTxStamp,2013-01-29  
> 08:12:42.358(java.sql.Timestamp)][currentPassword,{SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en(java.lang.String)][lastTimeZone,null()][lastUpdatedStamp,2013-01-29  
> 08:30:34.189(java.sql.Timestamp)][lastUpdatedTxStamp,2013-01-29  
> 08:30:34.188(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)],  
> locale=en}]: The following required parameter is missing: [IN]  
> [convertUomCurrency.nowDate]]
>
> --
> Thanks & Regards
> Atul Vani
>
> On Tue, 29 Jan 2013 13:49:15 +0530, Jacques Le Roux  
> <[hidden email]> wrote:
>
>> Have a look at https://demo-trunk.ofbiz.apache.org/bi/control/main
>>
>> Jacques
>>
>> From: "Winster Jose" <[hidden email]>
>>> 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 Creative Solutions Private Ltd.
>>> Cell: [phone]
>>> Mail: [hidden email]
>>>
>
>

--
Using Opera's revolutionary email client: http://www.opera.com/mail/