SQLServerCentral / Data Warehousing / Analysis Services / problem with olap in excel / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 03:39:26 GMT20problem with olap in excelhttp://www.sqlservercentral.com/Forums/Topic1423161-17-1.aspxI have security table and I join it into my fact table, everything is working properly in SSAS but when I try to join via excel to my cube I have problem with dimansion with is join to security. (example)tblsecurity - fields ((local\jones),number)tbldim1 ( parent1, ------ parent_name2 ------- number (key)When I expand hierarchy via ssas browser I see all level but when I try to do this via excel I receive message from excel' Query couldn't be open or it not possible open database table-please check server or contact your administrator system'Fri, 22 Feb 2013 10:34:38 GMTczekala.lukasz