Re: time dimension help!

Without knowing all the datails of your cube and application, it looks
like there may be some scope for replacing custom rollups with standard
aggregation functions. The last value for HeadCount probably can't be
aggregated over time; but how about the other measures, which are
averages or weighted averages? If site and program are regular
dimensions, then using standard aggregation on those should speed up
queries.

If you start with the fact data fields, and consider the various
averages that are needed, can they (or most of them) be derived from
appropriate base measures?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Multiple aggregated links between devices impossible?
    ... between Cisco devices, but only one 802.3ad aggregation is possible if ... That the standard only requires one between different vendors. ... proprietary aggregation mechanism before LACP. ...
    (comp.dcom.lans.ethernet)
  • Re: KLive: Linux Kernel Live Usage Monitor
    ... > kernels with a summary of the config file I used during build (e.g. ... Aggregation of results seems the biggest problem right now. ... If there was a more standard way to add extraversions and localversions ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Semi-additive measures in SQL2005
    ... Deepak Puri wrote: ... "Who is correct the BOL or..", ... inconsistent on semi-additive aggregations. ... This option does not change measures with a regular aggregation ...
    (microsoft.public.sqlserver.olap)
  • Re: Different Aggregation Functions by Dimension
    ... Select the aggregation function for the selected measure. ... table lists the aggregation functions that are available. ... Aggregated by returning the measure's first child member. ... Aggregated by returning the measure's first nonempty member. ...
    (microsoft.public.sqlserver.olap)
  • Re: Where Between Date Range
    ... AS 2005 makes possible using sets in the WHERE clause, ... 2005 engine makes aggregation on the fly. ... Vladimir Chtepa. ... > Deepak Puri ...
    (microsoft.public.sqlserver.olap)