Data Analysis....user can't access

P

ProjectAnalyst

Today I added a user to a group that can access Data Analysis. But she gets
an error that the query can not be processed, and either she doesn't have
permissions to the database or the database doesn't exist.

All existing users can access the data analysis views.

I did have to rename and rebuild the OLAP cube last week because we had to
recreate our production instance of Project Web Access (it was either deleted
by a cruel server admin or just disappeared on its own...scary)

Any idea how I can get the cube and this user on speaking terms?
Thanks.
 
P

ProjectAnalyst

By the way, I have installed:

MSXML6.0
ASOLEDB9.0
SQL Native Client

on her laptop, and also set IE setting to allow accessing data sources
across domains, and basically set her computer up like everybody else's.

also...she can't get to the cube using my computer either.
 
P

ProjectAnalyst

I also raised her into a group that has admin privileges, with exactly the
same results.
 
P

ProjectAnalyst

I'm not sure if this worked or not, since the user has gone home, but I
simply ran the cube and it added her to the database role on the Analysis
Server.

I am hopeful that she will be able to access the data in two days when she
returns to the office.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with creating Data Analysis View 3
Data Analysis Data Security 1
Cube Build Warning Message 4
Cannot create Data Analysis view 2007 4
Data Analysis (OLAP) doubles planned work values 0
Show Details is greyed out 1
Cube database problems-Help me 4
Analysis Service Not Working 1

Top