Hi,
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
Regards,
Bilawal Sarwar
Have you already tried to access the cubes from Information Map Studio or Enterprise Guide with the same UserID?
Yes the cube is accessible there with same userID
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.
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
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.
Yes Cubes are visible and everything is fine except those 2 cubes.
Well, then the only thing I can think of is opening a track with SAS TS.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.