locked
Web Standard Views Not Displaying RRS feed

  • Question

  • We have views posted from a new AS 2005 cube. Some people can view them via Web Standard and some can't.  We have olap security set for PAS and we have a GLOBAL\Domain Users  active directory member in the cube role.

     

    The cube developer has two client machines --  one has Web Professional 6.3 with the latest hot fix .2214 installed; the other machine doesn't have Web Pro installed.  She can access the views in Web Standard on the machine that has the client but not on the one that doesn't. 

     

    We are trying to roll-out the reports to executives who do not have the Web Professional client.  They are not able to see them.  (Our off-shore/India based sql server production support people can access the web standard links just fine.  I am also able to see them.  I have confirmed this from machines with and without Web Pro installed and both machines produced the reports.) 

    >>The error message says "The selected page could not be opened because the cube could not be found." 

     

    Can you please suggest trouble shooting steps and/or solution?

    Thanks,

    KateT

    Wednesday, August 20, 2008 1:28 AM

Answers

  • Hi Kate,

     

    It does not matter if PAS Web Standard users have Web or Desktop Professional on their machines when they try to access views.  Only HTTP traffic is sent to and from PAS and PAS has the providers that do the querying to the OLAP server. 

     

    I'm assuming the users who cannot get access are seeing cube cannot be found errors?

     

    Your cube developer's setup should give you some clues on what is happening.  Is she logged in as the exact same domain user on both machines?  Are both machines on the same network and/or domain (this really shouldn't have an impact AFAIK but sometimes it provides good context clues if the machines are on different domains or networks).

     

    Other steps you could try is checking the Security Event Viewer log in Windows to see which users are hitting the web server.  You can simulaneously run SQL Profiler on the SSAS server to see which users show up there.  Another idea might be to switch to Basic temporarily for troubleshooting - if you're currently using Integrated authentication.

     

    Also, try using Shift-F5 when refreshing the browser between tests and occassionally clearing the PAS cache.  These were a couple lessons we re-learned recently.  http://blogs.technet.com/proclarity/archive/2008/08/13/pas-security-lessons.aspx.

     

    -Joey

     

     

     

    Wednesday, August 20, 2008 5:54 PM