Unable to use Data Analysis in Project Web Access with SQL Express

S

SebastianG

Hello,
So I've just started learning about Project Server and we are using Project
Web Access to allow company-wide access to Project. However, I am not able to
use the Data Analysis feature, which we desperately need. The problem is that
I am unable to create a new PivotTable or PivotChart view to use in Data
Analysis.

The error I am getting when I try to create a new Data Analysis View within
Project Web Access is a popup modal that states "This Website uses a data
provider that may be unsafe. If you trust the website, click OK, otherwise
click Cancel". This modal comes up about ten times before I am allowed to
proceed. Once I do, I get an error within the Analysis Services section that
states "You must have the valid Analysis Services database name and cube
name". That is where I no longer know what to do.

I have been reading and researching for a week straight and cannot find out
if I can even use Data Analysis when my database is SQL Express. Don't I need
SQL Analysis Services? How can I find, or create, an Analysis Services
Database in my Project Server 2K7 installation to use? What should my next
step be?

Any help would be most appreciated, as I am completely stuck. Many thanks!

Best,
Sebastian G.
(e-mail address removed)
 

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

Top