Saturday, February 25, 2012

Reporting SVCS and OLAP

Hello
I have question about OLAP and reporting services, is there any way, or any
add in component for Reporting SVCS, for dynamic olap table. First when i
read feature of Reporting services i read something about integration with
OWC so i was thougt that i can add OWC PivotTable like component on my
Report, but this is not or so....
Is also there any SDK how to buil own component for Reporting Services
thank
Matej
Home page: http://magic.streznik.org
---Hi,
MS Reporting Services is for SQL Reporting and MS Analysis Services is
for MDX Reporting. With the addin of Panorama for MS Reporting
Services it is possible to have a MDX Report in MS Reporting Services
with parameters to choice from a slicer. With a simple click you can
go from static reporting in MS Reporting Services to the webclient of
Panorama for more analysis.
With QuickQuery And ReportBuilder you can make your own SQL Reports in
MS Reporting Services and in future also based on MDX Reports.
You can also use ReportPortal to have all in one concept.
On our website www.gmsbv.nl you will find more info, demos and trials.
Regards,
Marco
www.gmsbv.nl
"Matej Kavèiè" <matej.kavcic@.email.si> wrote in message news:<ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl>...
> Hello
> I have question about OLAP and reporting services, is there any way, or any
> add in component for Reporting SVCS, for dynamic olap table. First when i
> read feature of Reporting services i read something about integration with
> OWC so i was thougt that i can add OWC PivotTable like component on my
> Report, but this is not or so....
> Is also there any SDK how to buil own component for Reporting Services
> thank
> Matej
> Home page: http://magic.streznik.org
> ---|||Ok, there are two independent questions here.
1. OWC:
You might want to checkout MSDN at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
The dynamic pivot table functionality in Reporting Services is done via
Office Web Components (Office XP). Matrix reports (which you can build from
any type of data source) will be rendered as interactive pivot tables in
HTML with OWC.
2. Reporting from Analysis Services:
This question has come up several times on the newsgroup. You might want to
download and check out some samples from this link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
In addition, you may also want to subscribe to this discussion list:
http://groups.msn.com/OLAPServicesDevelopersForum. It should contain a
document in the discussion group under General about approaches how to
directly use Analysis Services 2000 as a datasource for Reporting Services
2000.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matej Kavèiè" <matej.kavcic@.email.si> wrote in message
news:ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hello
> I have question about OLAP and reporting services, is there any way, or
any
> add in component for Reporting SVCS, for dynamic olap table. First when i
> read feature of Reporting services i read something about integration with
> OWC so i was thougt that i can add OWC PivotTable like component on my
> Report, but this is not or so....
> Is also there any SDK how to buil own component for Reporting Services
> thank
> Matej
> Home page: http://magic.streznik.org
> ---
>|||There is also a MSDN article available now: "Integrating Analysis Services
with Reporting Services"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OxSEHJaVEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Ok, there are two independent questions here.
> 1. OWC:
> You might want to checkout MSDN at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
> The dynamic pivot table functionality in Reporting Services is done via
> Office Web Components (Office XP). Matrix reports (which you can build
from
> any type of data source) will be rendered as interactive pivot tables in
> HTML with OWC.
> 2. Reporting from Analysis Services:
> This question has come up several times on the newsgroup. You might want
to
> download and check out some samples from this link:
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
> In addition, you may also want to subscribe to this discussion list:
> http://groups.msn.com/OLAPServicesDevelopersForum. It should contain a
> document in the discussion group under General about approaches how to
> directly use Analysis Services 2000 as a datasource for Reporting Services
> 2000.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Matej Kavèiè" <matej.kavcic@.email.si> wrote in message
> news:ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> > Hello
> >
> > I have question about OLAP and reporting services, is there any way, or
> any
> > add in component for Reporting SVCS, for dynamic olap table. First when
i
> > read feature of Reporting services i read something about integration
with
> > OWC so i was thougt that i can add OWC PivotTable like component on my
> > Report, but this is not or so....
> > Is also there any SDK how to buil own component for Reporting Services
> >
> > thank
> >
> > Matej
> > Home page: http://magic.streznik.org
> > ---
> >
> >
>

No comments:

Post a Comment