07-14-2014 02:31 AM
I am facing problem in excel add-on. The issue encountered here is that only 2 cubes are not accessible anymore in OLAP server in excel 2007. Rest of the cubes are visible and working fine.
I have checked the permissions and its same as for other cubes. Kindly help in resolving issue. Thanks
07-14-2014 02:56 AM
Have you already tried to access the cubes from Information Map Studio or Enterprise Guide with the same UserID?
07-14-2014 06:46 AM
If I interpret your .png right, you try to find something in the OLAP Server that also appears in the Workspace Server(s)
The Workspace Server (at least in my installation) can only let you access libraries and tables, _not_ cubes.
I suspect that you often have cubes with the same name as the table that they were built from, but some tables do not have an "associated" cube. Without a cube, you can't find anything in the OLAP server.
07-14-2014 07:02 AM
Actually the cubes were visible before 10th JUL 2014. After that those 2 cubes are not accessible. All other cubes are visible and working fine. I just want to know is there any specific property for cubes to hide or something besides authentication rights
07-14-2014 07:16 AM
Are the cubes still visible in OLAP Cube Studio? From your .png, I suspect that the cubes have been deleted and only their respective tables still exist.
07-15-2014 02:45 AM
Well, then the only thing I can think of is opening a track with SAS TS.