Change Management Process in SharePoint Workspaces

[Projectability]

Has anyone in the group explored the potential for SharePoint sites to have a further list for Change Management on top of Risk and Issues? If so have they also been able to include this information in OLAP cubes for reporting purposes in the same fashion that Issues and Risks can be reported?

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==

 

[Mike Mahoney]

Has anyone in the group explored the potential for SharePoint sites to have a further list for Change Management on top of Risk and Issues? If so have they also been able to include this information in OLAP cubes for reporting purposes in the same fashion that Issues and Risks can be reported?

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHq....

Hi Dominic

The Olap cube data comes from the Reporting database. Unfortunately
new fields added to risk, issues or deliverables, or new custom lists
(change control) don't make it into the Reporting database. So you
need a custom solution to meet requirements around this data.

regards

Mike

 

[Projectability]

Mike,

Thanks for your input - I am assuming that it would be possible using MDX
expressions and other SQL witchcraft (I know virtually nothing about SQL
itself) to deliver the reporting I am suggesting I was just wondering if
anyone in this community had addressed this fairly common requirement.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==

Has anyone in the group explored the potential for SharePoint sites to
have a further list for Change Management on top of Risk and Issues? If so
have they also been able to include this information in OLAP cubes for
reporting purposes in the same fashion that Issues and Risks can be
reported?

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHq...

Hi Dominic

The Olap cube data comes from the Reporting database. Unfortunately
new fields added to risk, issues or deliverables, or new custom lists
(change control) don't make it into the Reporting database. So you
need a custom solution to meet requirements around this data.

regards

Mike

 

[Gary Chefetz]

Dominic:

We've developed a solution to pull SharePoint content data into custom
enterprise fields. Once there, the information is then available through the
reporting database and the OLAP cube. That's how we've solved similar
requests in the past.

 

[Mike Mahoney]

Dominic:

We've developed a solution to pull SharePoint content data into custom
enterprise fields. Once there, the information is then available through the
reporting database and the OLAP cube. That's how we've solved similar
requests in the past.

--
Gary L Chefetz, MVP, MCT, MCITP
msProjectExpertshttp://www.msprojectexperts.com
FAQs and Referencehttp://www.projectserverexperts.com
BLOG:http://projectserverhelp.com











- Show quoted text -

Dominic

If you are interested in 3rd party software, this organisation offers
a very flexible solution:

http://www.enesyssoftware.com/

regards

Mike