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.
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.