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.
