Re: XMLA + Reporting Services in MS SQL Server 2005



[This followup was posted to microsoft.public.sqlserver.olap and a copy
was sent to the cited author.]

Hi,

I experience the exact same problem with Reporting Server 2005 using
Analysis Server 2005 as a data source.

This issue was also addressed by another poster (JasonF) on Jan. 8th.

Here is his original message:

********************************************
I am trying to create a report in SQL Server 2005 Reporting Services
using an Analysis Server 2005 database as my Data Source. There are a
couple of issues that are happening. First after I build my query and
run a preview of the report the query is not saved when I got back into
the data tab.

Then when I try to re-create the query and go back in the preview tab VS
2005 shuts down with a fatal error.
********************************************


Is there any news on the status of this issue?

Regards
--
Jorg




In article <1139821449.955172.14030@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, you
say...
Hi,

Any idea why you can't first open a Reporting Services report and then
a XMLA OLAP report based on SQL Server 2005. No data available in the
OLAP report.

If you first open a XMLA OLAP Report and than Reporting Services report
you see both data in the report. But opening again a XMLA OLAP Report
ends with no data.

A bug in SQL Server 2005 or should a setting be changed ?

Regards, Marco


.



Relevant Pages

  • Re: Server Performance Report - Memory in use - showing No data
    ... Please find below the report I received this morning. ... There still isn't any 'Server Specifications' or 'Memory use' data ... click the Backup snap-in in Server Management, ... Critical Errors in Application Log ...
    (microsoft.public.windows.server.sbs)
  • Re: Erroneous E-mails sent entries in Server Usage Report
    ... One of the sbs2k3Sp1 boxes did previously report outgoing messages correctly in the Usage Report. ... I gave up modifying the default recipient policy years ago and now create my own policy on each server before creating users. ... the information "E-mail sent to external recipients" lists *zero* messages being sent by all users other than Administrator. ... Please check the Message Tracking Center. ...
    (microsoft.public.windows.server.sbs)
  • Re: Server Performance Reports broken
    ... I'll try to reinstall R2 and report back on how that goes. ... we cannot remove WSUS from R2 features directly. ... tries to collect WSUS information and WSUS node still appears in Server ... Step 1: Reinstall monitoring component: ...
    (microsoft.public.windows.server.sbs)
  • Re: Erroneous E-mails sent entries in Server Usage Report
    ... As far as I can recall, this problem was not present on my own server before ... did previously report outgoing messages correctly in the Usage Report. ... I gave up modifying the default recipient policy years ago and now create my ... Please check the Message Tracking Center. ...
    (microsoft.public.windows.server.sbs)
  • Re: Server Usage Report
    ... Server firewall to access the Internet. ... Configure ISA Server for monitoring and reporting. ... The SBS Usage report does not pull data from ISA. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)