Hi Ben,
As indicated previously, I don't have a problem with building the cube... As
this was built successfully. Infact I opened SQL Server Management Studio and
connected to the Analysis Services instance and I saw all the cubes are there.
However, my problem is in creating a Data Aalaysis View. This is the scenario:
I am connected to PWA as a Project Server Admin
- Click "Server Settings"
- Click "Manage Views"
- Click "New View"
- Select "Data Analysis" as the View Type
- Type a Name & Description for the View
- Select the "Default Server" option [The name is 100% correct]
- Now, when I try to select the "Analysis Services Database to be Created"
list I get the error: "Failed to connect to the Analysis Services server.
Verify the server name and try again" !!!
Any ideas?
:
Does the cube build now?
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/
:
Yes, I installed it on the server as I am working as an admin through PWA on
the actual server.
Any ideas?
:
Have you installed the SQL Server Analysis Services 9.0 DB Provider on the
client?
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/
:
Well, it didn't work :-(
I tried to create a new Data Analysis view based on the instructions in the
previous post, however, whenever I try to select the Analysis Services
database, I get an error: "Failed to connect to the Analysis Services server.
Verify the server name and try again". Well, I am 100% sure that the server
name is correct !!!!
Any ideas ??
By the way the cube was previously built successfully as seen below. I even
restarted the server just in case but this didn't help.
The cube build result:
===== Initiating cube build process =====
[10/23/2007 2:30 PM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[10/23/2007 2:30 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[10/23/2007 2:30 PM] Cube build initialization started
[10/23/2007 2:30 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[10/23/2007 2:30 PM] Cube build session started
[10/23/2007 2:30 PM] Analysis Services session started
[10/23/2007 2:31 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[10/23/2007 2:31 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[10/23/2007 2:31 PM] Process OLAP database session started
[10/23/2007 2:31 PM] Analysis Services session started
[10/23/2007 2:33 PM] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[10/23/2007 2:33 PM] Verifying and running post-process server event handler
===== Process Completed =====
[10/23/2007 2:33 PM] Cube build request completed successfully.
:
I found the instructions
Important Note: These instructions are part of and quoted from the Microsoft
Document:
"Cube Building Service in Office Project Server 2007"
I haven't tried these yet, but I will do and post my comments (If any)
Create a Data Analysis view:
1. Log on to Project Web Access as an administrator.
2. Click Server Settings.
3. In the Look and Feel section, click Manage Views.
4. On the Manage Views page, click New View.
5. On the New View page, in the Name and Type section, change the View Type
to Data Analysis. After you make the selection, the page refreshes with new
configuration options specific to the selected view type.
6. In the Name and Type section, enter a name and description for the Data
Analysis view.
7. In the Analysis Services Settings section, specify information about the
SQL Server Analysis Services instance that you are using to create your cube.
• If you select the Default server option, you will use the instance of SQL
Server Analysis Services you specified when you configured your cube build
and configuration settings.
• If you select the Custom server option, you have the option to select a
different instance of SQL Server Analysis Services.
8. In the Analysis Services Database to be created list, select the database
that hosts the Project Server 2007 cube.
9. In the Cube list, select the cube you want to use for this view.
There are fourteen cubes to choose from that are automatically generated by
the Cube Building Service (CBS). You can also create cubes that store
additional data not created by the CBS. As a result, organizations can now
report on Timesheet, Issues, Risks, and Deliverables data, in addition to
Project and Resource information.
10. In the View Options section, in the Show Data as options, choose how you
want the data to be displayed:
• PivotChart only
• PivotTable only
• PivotTable with PivotChart
11. Select Show Field List if you want the field list to be visible when the
view is used.
12. Select Show Toolbar if you want the toolbar to be visible when the view
is being used.
13. In the View Definition section, pick default measures and dimensions
from the PivotField List and add them to the PivotTable or PivotChart.
14. Choose the data you want to display in the view and drag it to the row,
column, or filter field in which you want it to appear. You can select
multiple measures and dimensions by pressing the CTRL key while you make
selections.
15. In the Security categories section, select the categories that you want
to make available to this view.
16. Click Save to create the view.
:
I have just managed to build the Project Server Cube after struggling for few
hours.
Lucily, I found the following article:
http://www.pptspaces.com/msprojectreporterblog/Lists/Posts/Post.aspx?ID=25
which was very helpful. Whether it is right or wrong , I don't know , but it
is the only thing that helped me in building the cube.
We have Project Server 2007 installed on Windows Server Enterprise 2003
(SP1) and SQL Server Enterprise 2005 (SP2).
Now, when I click Data Analysis in the Quick Launch of PWA I get nothing, In
otherwords there are no views. How can I create views??
Step-by-step instructions and a simple example will be greatly appreciated.
Note: I am loged in as a Project Server Admin.
Thanks.
