IE cube slice and dice

[Simon]

Hi,


Is is possibe to author a report for distribution over an Intranet using
Reporting Services and provide slice and dice functionality to the user in
IE? Analysis Services will be used for the Cubes and hopefully Visual Studio
for constructing reports.

Can this be achieved without local client cube data?


Thanks,


Simon

 

[Darren Gosbell]

You can't really do this with RS. Have you looked at Office Web
Components? You need Office licenses for your clients, but in an
Intranet scenario this should not be an issue.

Also have a look at the BI Portal. It is freely available on
microsoft.com and uses OWC to present pivot tables (and charts) to the
users. It even lets you set up a list of pre-defined reports that the
users can then slice and dice to their hearts content.

 

[Simon]

Thanks.

It was looking to me like RS was not going to be the key but that OWC might
be helpful.

Do you know if OWC can be 'hosted' in an RDL report and then used by RS or
does Intranet/browser viewing of reports using OWC require building your own
web page/report and hosting it in your own web site. I want to avoid this
really.


Simon

You can't really do this with RS. Have you looked at Office Web
Components? You need Office licenses for your clients, but in an
Intranet scenario this should not be an issue.

Also have a look at the BI Portal. It is freely available on
microsoft.com and uses OWC to present pivot tables (and charts) to the
users. It even lets you set up a list of pre-defined reports that the
users can then slice and dice to their hearts content.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Hi,


Is is possibe to author a report for distribution over an Intranet using
Reporting Services and provide slice and dice functionality to the user
in
IE? Analysis Services will be used for the Cubes and hopefully Visual
Studio
for constructing reports.

Can this be achieved without local client cube data?


Thanks,


Simon

 

[Darren Gosbell]

To the best of my knowledge there is no way to host OWC inside of an RS
report.

If you have a Windows 2003 server though you are eligible to download
and install Windows Sharepoint Services. The BI Portal is based on
Windows Sharepoint Services, if I remember correctly the current version
may allow you to have both OWC and RS reports in the one list (I'm not
entirely sure as I don't have the latest version installed - running out
of disk space for all my virtual PC images

There are RS webparts available(which plug straight into a sharepoint
services website). If you have not used Sharepoint and webparts before
the allow you to set up webpages by dragging the webparts on the page so
building your own reporting portal can becomes more of a configuration
exercise than having to write and support custom code.

If memory serves me correctly the next version of RS is coming with
similar webparts supplied as part of RS.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Thanks.

It was looking to me like RS was not going to be the key but that OWC might
be helpful.

Do you know if OWC can be 'hosted' in an RDL report and then used by RS or
does Intranet/browser viewing of reports using OWC require building your own
web page/report and hosting it in your own web site. I want to avoid this
really.


Simon

You can't really do this with RS. Have you looked at Office Web
Components? You need Office licenses for your clients, but in an
Intranet scenario this should not be an issue.

Also have a look at the BI Portal. It is freely available on
microsoft.com and uses OWC to present pivot tables (and charts) to the
users. It even lets you set up a list of pre-defined reports that the
users can then slice and dice to their hearts content.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Hi,


Is is possibe to author a report for distribution over an Intranet using
Reporting Services and provide slice and dice functionality to the user
in
IE? Analysis Services will be used for the Cubes and hopefully Visual
Studio
for constructing reports.

Can this be achieved without local client cube data?


Thanks,


Simon

 

[dbahooker]

you can tunnel analysis services via https i believe