Hello Sharepoint experts:
I'm testing our recently set up Kerberos with Sharepoint, Excel Services, and some SSAS Cubes.
I create an Excel Pivot table using a Trusted Connection to a cube, the "Refresh Data when opening file" is checked. The file is published to a Trusted Excel Services location in Sharepoint. I then create a Dashboard and add an Excel Web Part to display
that pivot table. All works fine on my machine. When I get another user (one who does NOT have access to this cube) to go to the Dashboard page, that user can see all the data in the Pivot table.
If I then DELETE the cube that the Pivot table is based on, when the user (who never had access to it in the first place) goes to the Dashboard page, they get an error stating that the source may be unreachable or that access may be denied. This error is
expected. But what I DON'T expect is to NOT receive an error the first time
Seems that even if the user does NOT have access to the cube, Excel Services still lets them see the 'last saved version of the file' even though it is supposed to query the database for new results every time.
AND when I restore the cube WITH CHANGES, that user can then not only see the pivot table again, they can see the recent changes, even though the original file in Trusted Excel Services Locations was never updated.
Is it possi
View Complete Post