Mike wrote:
I am interested in finding out how people are creating objects for rolling
time periods. I need to create an object that will add up three months of
amounts and average them. Also, the month and year need to be taken into
account when reporting in January and February. The time periods and
amounts that will be used are in the same table, should that be a problem?
Listserv Archives (BOB member since 2002-06-25)
you could: 1) get a dba to create an table table with ‘most current’ time frame.
prepare a generous bribe for this step.
2) create an object to access it. it’ll have many uses in your
queries.
3) create a condition object called ‘last 3 months’ (for example).
it should look for month in (curr_month, curr_month-1,
curr_month-2)
4) create an object for average. the formula should be
avg(measure)… it should average the measure regardless of timeframe. so it
should work for 3 months, 6months,etc.
5) select your measures. include the ‘average’ measure.
6) run the query.; you don’t need to select a date dimension. just
include the condition object in the condition window.
7) your results should roll up and perform the averaging
automatically.
frank b. duncan
decision support specialist (and still waiting for a ‘most current’ table)
national city corp.
______________________________ Reply Separator _________________________________
Mike wrote:
I am interested in finding out how people are creating objects for rolling
time periods. I need to create an object that will add up three months of
amounts and average them. Also, the month and year need to be taken into
account when reporting in January and February. The time periods and
amounts that will be used are in the same table, should that be a problem?
Listserv Archives (BOB member since 2002-06-25)