ofbiz uses the datawarehouse model for bi.
1)create enitiy for SalesDimension
like ProductDimension
https://localhost:8443/webtools/control/ViewRelations?entityName=ProductDimension
2)create mini code, ECAS, Services that work the enitities like in
applications\order\script\org\ofbiz\order\olap
applications\order\servicedef\secas_olap.xml
applications\order\servicedef\services_olap.xml
This gives you your Demensions and Facts that you can then Aggregate.
you can create enitityviews or use Dynamic ones. I suggest you start
with static entityviews so you can use the webtools to see the resultant
data.
you can build you queries using EntityCondition.makeCondition then use
findlist to get results.
=========================
BJ Freeman
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
smithav sent the following on 11/14/2010 8:14 AM:
No, i haven't seen that. Can you tell where to observe the changes.
But my question is different. Given the SALES as fact table, DATE as
dimension table, the user enters the period over which the sales
performance(measured as aggregate sales) is to be analysed. How do i perform
this analysis?
