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.
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Aggregate-Function-tp3041512p3042946.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
