I 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,
------- 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'