| Author |
IE cube slice and dice
|
|
|
| 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 2005-09-21, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <#TmoxQnvFHA.3756@tk2msftngp13.phx.gbl>,
simon_hooker@NO.SPAMiprimus.com.au says...
> 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
>
>
>
| |
|
| 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
"Darren Gosbell" <xxx@xxx.com> wrote in message
news:MPG. 1d9be819892ca3f29896
b3@news.microsoft.com...[color=darkred]
> 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_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <#TmoxQnvFHA.3756@tk2msftngp13.phx.gbl>,
> simon_hooker@NO.SPAMiprimus.com.au says...
| |
| Darren Gosbell 2005-09-22, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <OoH6uEwvFHA.2960@tk2msftngp13.phx.gbl>,
simon_hooker@NO.SPAMiprimus.com.au says...[color=darkred]
> 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
>
>
> "Darren Gosbell" <xxx@xxx.com> wrote in message
> news:MPG. 1d9be819892ca3f29896
b3@news.microsoft.com...
| |
| dbahooker@hotmail.com 2005-09-24, 3:23 am |
| you can tunnel analysis services via https i believe
|
|
|
|