Risks list and data analysis

[Andrew Stokes]

Hi

I would like to modify the default list in the project workspace to follow
our organisation's methodology. We include proximity in our risk methodology
which is also used in the calculation of exposure. Would it be possible to
bring this data into the data analysis cubes?

I am also having problems bringing any new data into the data analysis from
the project workspaces (Deliverables, Risks, Issues) into the data analysis
views. I have previously viewed deliverables and risks in the data analysis
views but now new data doesn't show. I have rebuilt the cubes on many
occasions but the only data that shows is old data. Can anyone tell me what
might be wrong?

Regards

Andrew

 

[Ben Howard]

Hi Andrew,
Re Proximity; the problem I have encountered is getting this to automaticaly
calculate and the issue is that WSS will not calculate this field on the fly,
until you edit the risk. The only way around this that I have found is to
create an SRS report which lists the risks in due date order, thereby giving
some resemblence of proximity.

Re OLAP cubes; make sure you publish the project after adding the info into
the WSS site. Publishing the project forces a WSS sync to data into the
reporting DB - then build the cubes.

HTH,

 

[Andrew Stokes]

Ben

Thanks for your reply on both points. After publishing the projects all WSS
data appeared (I think I need some more practice on PS)

On the risk and proximity issue, I thought that the cubes were building from
data directly in the WSS databases rather than replicating the data in the
project server databases. I was hoping to be able to customise the WSS lists
to fit our organisation and then create custom cubes based on the project
server ones to show this new data. I suppose project server uses the
SharePoint object model to pull out the relevant data and push it into the
reporting DB.

I suppose one could query the WSS databases directly in a custom cube but
this would be unsupported by MS of course. I'll probably do as you suggest
and use date ordering for proximity.

Thanks again,

Andy

 

[Ben Howard]

Hi Andrew, glad it helped. FYI, all cubes build from the reporting database.