Integrating Analysis Services 2005 with Reporting Services 2005

Hi,
I found an article
"Integrating Analysis Services with Reporting Services"
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/RSDSetEx3.asp)
for SQL-Server 2000 saying:
"Reporting Services 2005 will also add support for server-side aggregates.
This feature will enable report authors to take advantage of aggregations as
they are defined in Analysis Services, in addition to using the aggregate
functions available in Reporting Services. Reporting Services will also
expose server-side formatting features such as the cell background
property."
How can these server-side aggregates be used in 2005-reports, that is how
can different levels of aggregation been taken from a cube an displayed in a
table without further calculations inside the report?
RalphUnfortunately, server-side aggregates didn't make it to RS 2005. RS
essentially flattens the cube query results into a two-dimensional dataset.
As a result, the (All) member aggregates are lost. That said, you can return
the All member values as columns by creating calculated members in the MDX
Query Designer.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
news:OI1icDT6FHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I found an article
> "Integrating Analysis Services with Reporting Services"
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/RSDSetEx3.asp)
> for SQL-Server 2000 saying:
> "Reporting Services 2005 will also add support for server-side aggregates.
> This feature will enable report authors to take advantage of aggregations
> as they are defined in Analysis Services, in addition to using the
> aggregate functions available in Reporting Services. Reporting Services
> will also expose server-side formatting features such as the cell
> background property."
> How can these server-side aggregates be used in 2005-reports, that is how
> can different levels of aggregation been taken from a cube an displayed in
> a table without further calculations inside the report?
> Ralph
>|||Hi,
hmm, I tried the AddCalculatedmembers as proposed in the above article. If I
preview the query result in the query designer, everything works as expected
and i get all the desired levels. But if I try to display this dataset just
1:1 in a table inside a report, only the lowest level is shown. What am I
doing wrong?
Ralph
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im Newsbeitrag
news:OpjMDTT6FHA.2384@.TK2MSFTNGP12.phx.gbl...
> Unfortunately, server-side aggregates didn't make it to RS 2005. RS
> essentially flattens the cube query results into a two-dimensional
> dataset. As a result, the (All) member aggregates are lost. That said, you
> can return the All member values as columns by creating calculated members
> in the MDX Query Designer.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
> news:OI1icDT6FHA.2888@.tk2msftngp13.phx.gbl...
>> Hi,
>> I found an article
>> "Integrating Analysis Services with Reporting Services"
>> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/RSDSetEx3.asp)
>> for SQL-Server 2000 saying:
>> "Reporting Services 2005 will also add support for server-side
>> aggregates. This feature will enable report authors to take advantage of
>> aggregations as they are defined in Analysis Services, in addition to
>> using the aggregate functions available in Reporting Services. Reporting
>> Services will also expose server-side formatting features such as the
>> cell background property."
>> How can these server-side aggregates be used in 2005-reports, that is how
>> can different levels of aggregation been taken from a cube an displayed
>> in a table without further calculations inside the report?
>> Ralph
>>
>