I have configured Mondrian XMLA but i am fails to load with Pivot Table, i am facing “XMLHttpRequest cannot load http://localhost:8080/xmondrian/xmla. No ‘Access-Control-Allow-Origin’ header is present on the requested resource. Origin ‘http://localhost’ is therefore not allowed access.” issue. How to resolve this to load data in Pivot Table?
Yes, you have a very common issue with CORS. Despite the fact that web application is on localhost and XMLA server is also on localhost they have different ports so browser treats them as two different sources.
Please find here (http://www.flexmonster.com/doc/connecting-to-pentaho-mondrian/) how to allow your application to make a cross-origin request.
Please note that CORS requirement is not a specific restriction of our component but browser’s native limitation.