Aggregate(field, scope) function against Analysis Services 2005

Hi folks,
I am trying to make use of a new feature that is supposed to be in
RS2005, AS2005 but Im not sure if it is really there.
The web page
<http://www.microsoft.com/sql/technologies/reporting/faq.mspx> mentions
that AS 2005 has "Report server support for server-calculated
aggregates".
Also the BOL documentation suggests that Aggregate supports aggregation
supplied by the data provider. I was led to hope that RS Aggregate
would somehow get the MDX aggregate of the scoped data.
When I tried I could not get it to work.
The following yields the correct number:
=Sum(Fields!YTDSales.Value, "table1_Group1")
The following parses OK but yields an empty cell:
=Aggregate(Fields!YTDSales.Value, "table1_Group1")
The reason I am doing this is to write generic reports that allow users
to select measures that may aggregate in different ways (e.g. Total
Cost and Margin%).Did you ever get a solution to this? I am having the same difficulty. I want
to use the power of Analysis Services to do the calculations and
aggregations. That way we can centralize the definition of all calculations
and the calculation script and just pull the results into whatever reports we
want.
"FatOaf" wrote:
> Hi folks,
> I am trying to make use of a new feature that is supposed to be in
> RS2005, AS2005 but Im not sure if it is really there.
> The web page
> <http://www.microsoft.com/sql/technologies/reporting/faq.mspx> mentions
> that AS 2005 has "Report server support for server-calculated
> aggregates".
> Also the BOL documentation suggests that Aggregate supports aggregation
> supplied by the data provider. I was led to hope that RS Aggregate
> would somehow get the MDX aggregate of the scoped data.
> When I tried I could not get it to work.
> The following yields the correct number:
> =Sum(Fields!YTDSales.Value, "table1_Group1")
> The following parses OK but yields an empty cell:
> =Aggregate(Fields!YTDSales.Value, "table1_Group1")
> The reason I am doing this is to write generic reports that allow users
> to select measures that may aggregate in different ways (e.g. Total
> Cost and Margin%).
>