Hi Philip,

i have modified the code as following:

<script>
$.support.cors = true;

$(function () {
var dataSource = new $.ig.OlapXmlaDataSource({
serverUrl: 'http://localhost/olap/msmdpump.dll'
});
var promise = dataSource.initialize();
promise.fail(function (error) {
// break here to inspect the error
});
promise.done(function(rootMetadataItem) {
// everything is OK. inspect the rootMetadataItem
});

$('#dataSelector').igPivotDataSelector({
dataSource: dataSource,
height: "650px",
width: "240px"
});
$("#pivotGrid").igPivotGrid({
dataSource: dataSource,
height: "650px",
width: "670px"
});
});
</script>

Combo box continue to be empty.

Promise object has some attributes to check errors?

Thanks

Marco

Hi Marco!

If you have followed all the instructions for configuring cross-domain access for the XmlaDataSource as described in the help topic that you mentioned and it still does not work, there are two things you can check:

In order to understand what the error exactly is, you will need to drill-down into the __innerException property of the exception that you get. In fact, most probably there will be multiple nested __innerExceptions and you will need to reach the one on the deepest level, to see the actual error message.

Another thing is to check the Network tab of the developer tools in Chrome, where you can inspect the actual response from the server.

I am awaiting your reply.

Regards,

Philip

Hi Philip,

i have captured two txt files from console.

The first one named 'initial_load' contains the error i get browsing the html page for the first time

The second one named 'next_page_reload' contains the error i get reloading the same page from chrome.

Have you any ideas ?

Thanks a lot

Marco

Hi Marco!

We inspected the logs and noticed the "XMLAnalysisError.0xc1180001" error. This leads us to believe that the IIS  user used for anonymous access to your database on the SQL Server does not have the read permission to it.

Could you check in SQL Management Studio that this user (by default this is IUSR) has read permission for your database. I am attaching a screenshot to illustrate this (the AdministratorOLAP role has read access for the datasource and for the cubes - see the General and Cubes pages from the Edit Role dialog in the bottom picture).

Let me know if this resolves the issue.

Thanks,

Philip

Hi Philip,

fantastic, now it works fine, see the attached snapshot.

Thanks a lot

Marco

I'm really glad you got it working. I think other community members might benefit from your experience as well.

Be sure to stop by the forums at any time if you have any other issues/questions.

Best,

Philip