ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hans Bakker <mailingl...@antwebsystems.com>
Subject Re: Aggregate Function
Date Mon, 15 Nov 2010 12:24:32 GMT
How about looking at what is already there?

have a look in: applications/order/entitydef/entitymodel_olap.xml

there the sales are already defined, perhaps you can improve on that?

why people always want to build new and not improve what is already
there?

Regards,
Hans

On Mon, 2010-11-15 at 04:04 -0800, smithav wrote:
> I am using the datawarehouse model BI. I am using the already existing Date
> and Currency dimensions. I have defined Product, Customer, Location,Slaes
> dimensions in addition to them. Here Sales is a fact table. It contains
> foreign keys of all the dimension tables along with a field called sales. I
> have to now write a query that either takes yrs or location as input from
> user and gives the aggregate sales as output for that period or particular
> location respectively. 

-- 
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.


Mime
View raw message