ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Subscription and excel web query issue

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by reportportaluser[/i]
[br]Hi,

I am new to report portal, however my firm has been using this for a couple of years now.

I have two issues:

1. Subscriptions don't work.
When i check the history tab this is what I get:

Data at the root level is invalid. More info at pastebin: http://pastebin.com/EijG3Pwk

2. Excel web query don't work

The excel web query generated returns an error: the remote server returned an error (400). On checking the query.. the error thrown in excel is :

Execute Error: Data at the root level is invalid. Line 1, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.LoadXml(String xml) at ReportPortal.XmlaRequest.(String sMdx, String sServer, String sCatalog, String sURL); XMLA: http://localhost/xmla/msmdpump.dll

Can anyone help me out

Thanks
+ reportportaluser
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
reportportaluser	Posted - 04/20/2011 : 09:02:33 Hi, I am new to report portal, however my firm has been using this for a couple of years now. I have two issues: 1. Subscriptions don't work. When i check the history tab this is what I get: Data at the root level is invalid. More info at pastebin: http://pastebin.com/EijG3Pwk 2. Excel web query don't work The excel web query generated returns an error: the remote server returned an error (400). On checking the query.. the error thrown in excel is : Execute Error: Data at the root level is invalid. Line 1, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.LoadXml(String xml) at ReportPortal.XmlaRequest.(String sMdx, String sServer, String sCatalog, String sURL); XMLA: http://localhost/xmla/msmdpump.dll Can anyone help me out Thanks + reportportaluser
3 L A T E S T R E P L I E S (Newest First)
marco	Posted - 04/20/2011 : 14:27:29 Hi, Depends on your olap cube. You can have a MDX filter where you can query always the last child (current date) if this is the last date in your cube. Marco
reportportaluser	Posted - 04/20/2011 : 09:48:02 It's fixed.. sorry guys, I figure it while posting this topic. If you have read my post till here you could however help me one thing. I have a time filter that ensure that i get a daily report. How can i ensure that the report generated automatically sets the date dimension to current day?
reportportaluser	Posted - 04/20/2011 : 09:10:57 the excel issue seems to have resolved. I replaced local host in admin-->settings-->olap report-->xmla base url with an ip.

ReportPortal