SAS Excel Add-on Issue

Reply
New Contributor
Posts: 4

SAS Excel Add-on Issue

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


SAS Cubes.png
Super User
Posts: 7,758

Re: SAS Excel Add-on Issue

Have you already tried to access the cubes from Information Map Studio or Enterprise Guide with the same UserID?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: SAS Excel Add-on Issue

Posted in reply to KurtBremser

Yes the cube is accessible there with same userID

Super User
Posts: 7,758

Re: SAS Excel Add-on Issue

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: SAS Excel Add-on Issue

Posted in reply to KurtBremser

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

Super User
Posts: 7,758

Re: SAS Excel Add-on Issue

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: SAS Excel Add-on Issue

Posted in reply to KurtBremser

Yes Cubes are visible and everything is fine except those 2 cubes.

Super User
Posts: 7,758

Re: SAS Excel Add-on Issue

Well, then the only thing I can think of is opening a track with SAS TS.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 7 replies
  • 271 views
  • 0 likes
  • 2 in conversation