Re: Where Between Date Range

Hi,

AS 2005 makes possible using sets in the WHERE clause, but under hood AS
2005 engine makes aggregation on the fly. It has better performance
comparing with AS 2000, that should have additoonal CM, that always
calculated on PTS side, but it is always slower as precalculated aggregates.

Vladimir Chtepa.

"Deepak Puri" <deepak_puri@xxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:eM7QuNVFGHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
> (A) In AS 2005, you can directly specify a set in an MDX where clause,
> like:
> WHERE {[NonSelectedDate].[2005].[Jan].[01]:
> [NonSelectedDate].[2005].[Mar].[26]}
>
>
> (B) As Vladimir noted, leveraging MS OLAP aggregations is important in
> improving efficiency - one approach is discussed in Chris Webb's blog
> below:
>
> http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
> 107.entry
>
> http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
> 111.entry
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: What does "expression" refer to in the Totals list in a Query?
    ... Expressions are fields in the SELECT clause ... Sum means add up all values for the grouped by fields. ... Since the expression is tacked on after aggregation, ... You can therefore refer to that in your Expression. ...
    (microsoft.public.access.queries)
  • Re: Box query
    ... Changing the having clause won't fix a problem that already happened ... I'm changing the aggregation expression. ... intersect is a simple expression ...
    (comp.databases.theory)
  • Re: DateDiff
    ... The purpose of the GROUP BY clause is to perform some sort of aggregation on some field. ... When I take out the group by Employee id, the query runs fine. ...
    (microsoft.public.access.queries)
  • Re: Querying mean values without using "Totals"
    ... You cannot use an aggregate in a WHERE clause. ... The WHERE clause is executed BEFORE any aggregation, so, the result ... Using the expression builder with the function "Avg" in the cell ... possible to have a aggregated function in a WHERE instance". ...
    (microsoft.public.access.queries)
  • 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)
Quantcast