| Author |
 Topic  |
|
|
reportportaluser
India
3 Posts |
 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 |
|
|
reportportaluser
India
3 Posts |
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.
|
 |
|
|
reportportaluser
India
3 Posts |
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? |
|
|
|
marco
Netherlands
588 Posts |
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
|
|
|
| |
Topic |
|
Report Portal
Subscription and excel web query issue
