M
Michael
I am fairly new to project server 2003 and Project Web Access (PWA),
but have been able to extend an OLAP cube for Task Risk and Issues as
part of the Project server Solution Starter SDK. When creating the
view from the SDK for the Task Issues and Risks in
PWA, I am able to create the view in the Manage Views section with no
issue. Connection to my OLAP data source works fine and I am able to
drag and drop my OLAP fields onto a chart (bubble chart in my case).
However, when I click the Save Changes button, and return to edit the
View, the view has none of the fields\data (filters, X data, Y data,
etc) I added to the chart originally from the olap connection. The
connection actually reverts back to the default of
MSP_Portfolio_Analyzer. The same is true
when I go to the Projects heading link across the top, select my
project, and
then select Analyze Project in Portfolio Analyzer under the Actions
menu. Essentially, I have to reconnect back to my OLAP source and
re-drag and drop my fields each time I want to view my OLAP
information. I believe I am missing some thing simple on my end but
can't figure out for the life of me what?
More background Information:
Currently I have an Analysis Manager Database called
MSP_RiskIssue_Cube. In this database I have the following cubes;
MSP_Portfolio_Analyzer (virtual cube), MSP_Risk_Cube, MSP_Issue_Cube.
When I create a Portfolio Analyzer View using the Manage View page of
the Admin page of Project Web Access, I am able to connect to my
MSP_Risk_Cube (or MSP_Issue_Cube) with no problem. I am also able to
drag and drop fields from these cubes onto a chart in the View. The
chart I'm creating is a bubble chart similar to the example in the MS
Project Solution Starter to extend the OLAP cubes for Risk and Issues.
Once I save the new\edited view, a message is presented saying that the
View was successfully modified\created. However, when I go back into
the view, all the fields I dragged and dropped onto my bubble chart are
gone and the data source is now back to the default cube of
MSP_Portfolio_Analyzer. The chart type is back to the default as well
and is not a bubble chart any longer. The same is true when I go to
the Projects heading in the top menu, and then select Analyze Projects
with Portfolio Analyzer under the Actions menu. The View itself (at
least the name) is saved successfully to the project db, as I can see
the view name information in the MS Project db.
Cube Roles -> I've added my own domain name and the entire share
point admin group (just in case it was trying to use this account to
access information on the db) to all cubes in this database. I'm not
sure what other access roles would need to be added as I am a db admin,
a PWA admin, and a member of the sharepoint admin group. Also, I am
able to access the OLAP cubes via the Chart Wizard of the Manage Views
page in PWA.
Here is a link to the step in the Solution Starter that is not saving
->
http://msdn.microsoft.com/library/d...dkCubesUsingTaskIssuesAndRisks_HV01096323.asp
Thanks in advance.
but have been able to extend an OLAP cube for Task Risk and Issues as
part of the Project server Solution Starter SDK. When creating the
view from the SDK for the Task Issues and Risks in
PWA, I am able to create the view in the Manage Views section with no
issue. Connection to my OLAP data source works fine and I am able to
drag and drop my OLAP fields onto a chart (bubble chart in my case).
However, when I click the Save Changes button, and return to edit the
View, the view has none of the fields\data (filters, X data, Y data,
etc) I added to the chart originally from the olap connection. The
connection actually reverts back to the default of
MSP_Portfolio_Analyzer. The same is true
when I go to the Projects heading link across the top, select my
project, and
then select Analyze Project in Portfolio Analyzer under the Actions
menu. Essentially, I have to reconnect back to my OLAP source and
re-drag and drop my fields each time I want to view my OLAP
information. I believe I am missing some thing simple on my end but
can't figure out for the life of me what?
More background Information:
Currently I have an Analysis Manager Database called
MSP_RiskIssue_Cube. In this database I have the following cubes;
MSP_Portfolio_Analyzer (virtual cube), MSP_Risk_Cube, MSP_Issue_Cube.
When I create a Portfolio Analyzer View using the Manage View page of
the Admin page of Project Web Access, I am able to connect to my
MSP_Risk_Cube (or MSP_Issue_Cube) with no problem. I am also able to
drag and drop fields from these cubes onto a chart in the View. The
chart I'm creating is a bubble chart similar to the example in the MS
Project Solution Starter to extend the OLAP cubes for Risk and Issues.
Once I save the new\edited view, a message is presented saying that the
View was successfully modified\created. However, when I go back into
the view, all the fields I dragged and dropped onto my bubble chart are
gone and the data source is now back to the default cube of
MSP_Portfolio_Analyzer. The chart type is back to the default as well
and is not a bubble chart any longer. The same is true when I go to
the Projects heading in the top menu, and then select Analyze Projects
with Portfolio Analyzer under the Actions menu. The View itself (at
least the name) is saved successfully to the project db, as I can see
the view name information in the MS Project db.
Cube Roles -> I've added my own domain name and the entire share
point admin group (just in case it was trying to use this account to
access information on the db) to all cubes in this database. I'm not
sure what other access roles would need to be added as I am a db admin,
a PWA admin, and a member of the sharepoint admin group. Also, I am
able to access the OLAP cubes via the Chart Wizard of the Manage Views
page in PWA.
Here is a link to the step in the Solution Starter that is not saving
->
http://msdn.microsoft.com/library/d...dkCubesUsingTaskIssuesAndRisks_HV01096323.asp
Thanks in advance.