• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Excel Services displays cached data to all users when SSAS cube is down

We are using WSS2007 to display excel reports connected to our SSAS cube.  Our MDX security filters work just fine when the cube is up, but in the event the cube is down, our users have figured out how to display the original cached excel file via web services.

1. the cube must be unavailable
2. the user clicks on a report library file (.xlsx) via the SharePoint portal
3. they see " Data Refresh Failed "
4. they click back in IE7
5. they click the exact same report again
6. the original cached copy loads

we have the excel file to always refresh upon opening and excel services central admin is set to "Stop When Refresh on Open Fails".  As you can imagine, this is a major security concern in our organization.

Any ideas?

Thanks in advance!
0
tsgrempel
Asked:
tsgrempel
1 Solution
 
tsgrempelAuthor Commented:
I've figured out the solution.  My users had read access instead of "View Only" on reports.  Now when they click ok or go back to the reports, it takes them to the homepage.  Before, with "Read" permissions, it loaded the stale cached copy.

Problem solved.
0
 
EE_AutoDeleterCommented:
rampravee,
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.

EE_AutoDeleter
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now