| T O P I C R E V I E W |
| RobertL |
Posted - 10/22/2004 : 06:45:26
When I try to create an OLAP report I get the error message "An error occurred while processing the request". My guess is that there is a problem with my datasources.xml.
<?xml version="1.0" ?>
<DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" MaxRequestSize="128" AllowInsecureTransport="1" EnableNagleAlgorithm="1">
<DataSource>
<DataSourceName>ROBERTL</DataSourceName>
<DataSourceDescription>My Analysis server</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=ROBERTL</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>
</DataSources>
Where ROBERTL is the name of my Analysis Server. I'm pretty sure that all security settings are OK. Does anyone have any ideas of what the problem is?
Thanks |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 10/25/2004 : 19:42:06
First try recommend watching this installation video: [url]http://www.reportportal.com/Flash/Install.html[/url]
XMLA SDK 1.1 requires MSXML 4.0. It can be downloaded by clicking here [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en[/url].
When installing XML for Analysis SDK 1.1 don't forget to: Change the execute permissions for the "XMLA" virtual directory to "Script and Executables". Change msxisapi.dll to use anonymous authentication with a user account that has full access to the Analysis Services.
Try using the SDK sample application to make sure that XMLA SDK is properly installed.
You can also test the connection with this page MDX.htm. [url]http://www.reportportal.com/MDX.htm[/url]. Please save this page to desktop before running it. Sometime it is necessary to restart the IIS service or the PC for the XML/A web service to work. |
Report Portal
