Problem with creating Data Analysis View

S

szymen

Hello,

We are using Project Server 2007 with SQL Server 2008 on Win XP. I'm having
a problem with creating Data Analysis View. Fields: "Analysis Services
Database to be created" and "Cube:" are empty and beneath is seen: "You must
have the valid Analysis Services database name and cube name".
I have done steps from other posts:
* Add the Project Web Access site as a trusted site.
* Clear the option to Block Pop Ups.
* Enable Access data source across domains.
* Have following components installed on client machine: OLEDB9.0, SQL
Native Client, Office Web Components
* built cube with following logs:

===== Initiating cube build process =====
[18/03/2010 23:00] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[18/03/2010 23:00] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[18/03/2010 23:00] Cube build initialization started
[18/03/2010 23:00] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[18/03/2010 23:00] Cube build session started
[18/03/2010 23:00] Analysis Services session started
[18/03/2010 23:01] 77 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[18/03/2010 23:01] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[18/03/2010 23:01] Verifying and running post-build server event handler
===== Processing OLAP database =====
[18/03/2010 23:01] Process OLAP database session started
[18/03/2010 23:01] Analysis Services session started
[18/03/2010 23:02] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[18/03/2010 23:02] Verifying and running post-process server event handler
===== Process Completed =====
[18/03/2010 23:02] Cube build request completed successfully.

Maybe You have any suggestions that can help.
 
S

Stephen Sanderlin [MVP]

S

szymen

Sorry for my mistake, we've got ASOLEDB10. I was just copy-pasting it from
another post applying for SQL 2005.

Stephen Sanderlin said:
If you're working with SQL 2008, the client systems need ASOLEDB10, not
9. Refer to http://technet.microsoft.com/en-us/library/dd285466.aspx.
Client security settings are also discussed in that article.

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com



Hello,

We are using Project Server 2007 with SQL Server 2008 on Win XP. I'm having
a problem with creating Data Analysis View. Fields: "Analysis Services
Database to be created" and "Cube:" are empty and beneath is seen: "You must
have the valid Analysis Services database name and cube name".
I have done steps from other posts:
* Add the Project Web Access site as a trusted site.
* Clear the option to Block Pop Ups.
* Enable Access data source across domains.
* Have following components installed on client machine: OLEDB9.0, SQL
Native Client, Office Web Components
* built cube with following logs:

===== Initiating cube build process =====
[18/03/2010 23:00] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[18/03/2010 23:00] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[18/03/2010 23:00] Cube build initialization started
[18/03/2010 23:00] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[18/03/2010 23:00] Cube build session started
[18/03/2010 23:00] Analysis Services session started
[18/03/2010 23:01] 77 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[18/03/2010 23:01] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[18/03/2010 23:01] Verifying and running post-build server event handler
===== Processing OLAP database =====
[18/03/2010 23:01] Process OLAP database session started
[18/03/2010 23:01] Analysis Services session started
[18/03/2010 23:02] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[18/03/2010 23:02] Verifying and running post-process server event handler
===== Process Completed =====
[18/03/2010 23:02] Cube build request completed successfully.

Maybe You have any suggestions that can help.

.
 
S

szymen

I solved the issue. The problem was that the user I was working on wasn't
added to members of ProjectServerViewOlapDataRole and I had to do it
manually. It was connected with the log:
[18/03/2010 23:01] 77 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'

szymen


szymen said:
Sorry for my mistake, we've got ASOLEDB10. I was just copy-pasting it from
another post applying for SQL 2005.

Stephen Sanderlin said:
If you're working with SQL 2008, the client systems need ASOLEDB10, not
9. Refer to http://technet.microsoft.com/en-us/library/dd285466.aspx.
Client security settings are also discussed in that article.

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com



Hello,

We are using Project Server 2007 with SQL Server 2008 on Win XP. I'm having
a problem with creating Data Analysis View. Fields: "Analysis Services
Database to be created" and "Cube:" are empty and beneath is seen: "You must
have the valid Analysis Services database name and cube name".
I have done steps from other posts:
* Add the Project Web Access site as a trusted site.
* Clear the option to Block Pop Ups.
* Enable Access data source across domains.
* Have following components installed on client machine: OLEDB9.0, SQL
Native Client, Office Web Components
* built cube with following logs:

===== Initiating cube build process =====
[18/03/2010 23:00] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[18/03/2010 23:00] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[18/03/2010 23:00] Cube build initialization started
[18/03/2010 23:00] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[18/03/2010 23:00] Cube build session started
[18/03/2010 23:00] Analysis Services session started
[18/03/2010 23:01] 77 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[18/03/2010 23:01] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[18/03/2010 23:01] Verifying and running post-build server event handler
===== Processing OLAP database =====
[18/03/2010 23:01] Process OLAP database session started
[18/03/2010 23:01] Analysis Services session started
[18/03/2010 23:02] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[18/03/2010 23:02] Verifying and running post-process server event handler
===== Process Completed =====
[18/03/2010 23:02] Cube build request completed successfully.

Maybe You have any suggestions that can help.

.
 

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