Environment: MOSS 2007, SQL Analysis Server 2008; Kerberos authentication
I have a Web Part that displays a Pivot Table from a Trusted Excel doc. When I open the Dashboard page with this web part, I see correct and refreshed data from the cube. When ANOTHER user does the same, (this user does NOT have ANY permissions to view
or browse the base cube) they first get an error saying the data cannot be queried, which is fine. BUT, when they click the OK button they see the LAST CACHED VERSION of this Excel Pivot Table from when it was last saved. This happens even if I set the "Refresh
Data on opening of file".
How do I make it so that if a User does NOT have permissions on the cube, that Excel Services won't show them anything at all. Stale data is worse than no data at all because even though they don't have permissions to view it, they might then think it is
Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Create an audience for the users that have access to view the reports and after the audience is compiled add the audience to the EWA webpart, this will enabvle the WebPart to show up for the users that have access and to not display for the users who
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.