(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Hi,
We are developing a solution when enterprise schedules could be reported via backend from Primavera and Project Online (Enterprise Master Schedule). Our solution already works with P6 schedules and we need to add all schedules from Project Online. We can't find a solution for one critical issue's and I need support from this forum.
Milestone's slippage (from last month) calculated based on Schedule ID and Milestone ID by comparing two datasets (from previous and current month).
Schedule ID and Milestone ID must be:
a) user defined;
b) unique per schedule;
c) not blank;
We aleady have a set of Governence Control Reports (via Tableau) and able to see what has been changed since last month (new/removed schedules, new/deleted milestones, ID changed (calculated absed on UID), milestones renamed, baseline removed, etc)
Primavera has Activity ID and Project IDs which met these criteria but I can't find out what I can use on PoL.
Activity ID - not stable - changesd if new activity added;
Activity UID - not user defined; (if a user delete milestone by mistake and created it again it would be new UID and slippage could not be calculated;)
WBS could be user defined, unique and not blank but only if WBS Code definition setup.
Is it possible to configure permissions to have WBS always defined (Now users and change WBS Prefix and mask)?
or is it any other options avaliable?
For user developers can't find Activity UID and WBS code at backend but I am assuming it just thier knowledge of Project Online backend. Please support with this as well ifyou know any secrets :)
Thanks in advance
Printer-friendly version
Send to friend
Alex,
I'm not on Project Online, but based on MSP desktop I would be skeptical of the stability of WBS. You can force it to be unique and non-blank, but it's hard to inhibit the user from completely re-organizing and re-numbering (in MSP). I've also been frustrated using activity UID as a comparison key in the past - contractor would routinely delete and replace hundreds of records tasks at a time just as part of routine progress updates. Still, on the desktop version I think that's what we are stuck with. Microsoft's own Compare Projects tool, which is pretty slick, relies on it.
There don't seem to be many knowledgeable POL users here on PP. Have you inquired on Technet? https://social.technet.microsoft.com/Forums/projectserver/en-US/home?forum=projectonline
Good luck, tom
I checked and I do not see it
Privet message via Planning Plannet...
sent to where ?
Activity ID NEVER changes
Key | Name | Type | Description | Default |
PK | acct_id | integer | FK to ACCOUNT table - identifies cost account for activity |
|
give me your email address I have the schema
Email: PPadmin@planningplanet.com
Replies