Login  Register

Re: Dev - OLAP in OFBiz

Posted by BJ Freeman on May 27, 2006; 11:32pm
URL: http://ofbiz.116.s1.nabble.com/Dev-OLAP-in-OFBiz-tp168216p168218.html

Just as ofbiz converts it entities to query the database.
you could provide a way to covert cube entities (new entity for ofbiz)
This would be a new work, and if you license ASF, it can be included and
would make ofbiz very powerful.
Just a thought.


BJ Freeman sent the following on 5/27/2006 3:21 PM:

> I have worked with OLAP with MS-SQL server. Wrote an application to
> provide a corporation with OLAP across Data farms, in VB, to interface
> with Excel.
>
> Ofbiz is not a database. that is a underlying function.
> you will have to write a bridge to ofbiz view services in ofbiz to
> provide the equivalent of OLAP functionality.
>
> I suggest you look at the entities in webtools for data layout.
> then make a bridge between openoffice spreadsheet and ofbiz views.
> Maybe make a new entity that store the OLAP configurations so it is dynamic.
>
>
>
> Ivan Alfredo Mendoza sent the following on 5/27/2006 12:32 PM:
>> Hello
>> I am new to OfBiz and I am still learning the framework.  So far now
>> I've only completed the eCommerce module traslation to Latin American
>> Spanish and have few plans for implementing it as soon as I have more
>> free time from classes and other projects.
>>
>> So, as I am taking a database course (graduate level) a friend and I
>> decided to wite an OLAP module using Mondrian (somewhat following Mr
>> Oleg Kozyrev's idea in http://jira.ofbiz.org/browse/OFBIZ-719), but we
>> have two important questions to ask the community.
>>
>> 1) Can we obtain a dataset (a whole pile of data to seed OFBiz) to
>> make feasible OLAP analysis and tests?
>>
>> 2) what topics (database tables or columns) would you consider
>> relevant when thinking of a desing of OLAP on OFBiz?...Maybe 2 or
>> 3...Our project, for now would only be a prototype and, for now will
>> be hosted in http://ofbiz.estudiobasico.com
>>
>>
>> Thank you very much
>>  
>> _______________________________________________
>> Dev mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/dev
>>
>  
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev