Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Subject: Re: Aggregate Function
From: Hans Bakker <mailinglist@antwebsystems.com>
To: user@ofbiz.apache.org
In-Reply-To: <1289822678513-3042946.post@n4.nabble.com>
References: <1289714100670-3041512.post@n4.nabble.com>
	 <4CDFC303.5040807@free-man.net> <1289751286818-3041836.post@n4.nabble.com>
	 <4CE07571.30706@free-man.net>  <1289822678513-3042946.post@n4.nabble.com>
Content-Type: text/plain; charset="UTF-8"
Date: Mon, 15 Nov 2010 19:24:32 +0700
Message-ID: <1289823872.2533.4.camel@hans-laptop>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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.