That is time phased work by day, not duration. Duration is the amount
of
working time required to complete all work for the Task (working
minutes
between start and finish dates)
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Ok, Well,
But i find out the table and query the below.
SELECT TaskName,
[TimeByDay]
,AD.[AssignmentWork]
FROM [ProjectServer_Reporting].[dbo].[MSP_EpmAssignmentByDay] AD
inner join Msp_EpmAssignment A on ad.AssignmentUid = A.AssignmentUid
inner join msp_epmtask T on A.TaskUid = T.TaskUid
give you're feedback.
:
Ha ha!
I understand the misunderstanding (I think)
There is "datewise" (we say timescaled) work by day, by hour..
There is NO timescaled duration :d uratioin is about time running,
duration
is just a figure, not something that can be cut down by day..
Sorry!
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
ok, thanks
already i have we used the same.
dbo.MSP_EpmTask_UserView, showing TaskDuration columns.
consolidated
hrs
only, for ex. task is days it will displayed 16hrs only, two days
breakup
details i need.
that's what i mentioned very clearly DATE WISE baseline duration.
if i am trouble you for lot, Shall i close this call.
:
Ok, Download the Software Development Kit (SDK) for Project
Server
from
microsoft.com and look at the FILE pj12ReportingDB.chm
This will show you the full schema for the reporting db. I
recommend
using
the built in views such as dbo.MSP_EpmTask_UserView because all
Views
ending
with _userview automatically have relevant custom fields added to
them.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Hi,
When i want to generate the report for my resource wise Planned
and
Actual
hrs report for Resource utilization details.
we don't want to probable planned hrs, only baseline duration
against
Actual
hrs
that details stored in the DB(ProjectServer_Reporting) but
Table
details i
need.
:
They mean date wise as in from a date perspective. They are
also
referring
to emails, not Project.
I'm afraid both Jan and I have no idea what you mean or what
you
want
to
achieve. There are baseline dates (start and finish), baseline
duration,
cost and work but nothing else.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Thanks for your effort,
But still you're not clear my Query
http://www.microsoft.com/communitie...25-4469-add6-a0e5ea45f48f&lang=&cr=&sloc=&p=1
http://www.derkeiler.com/Newsgroups/microsoft.public.win2000.security/2002-09/8289.html
Pl. Check the above url - They are used datewise the
DATEWISE
word
is
the
common word, Date Range ok
Hi,
You absolutely want to use the word datewise, which is not
in
the
English
dictionary, so I'll forget about it.
Do you mean you want durations in hours instead of days?
That is through Tools, Macro, Macros, Format_Duration, Run.
Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi,
I need datewise Baseline Duration in hrs, ok
:
It's not the data, it's what you mean by the word
datewise.
What
do
you
mean?
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi
Task Name Duration Start Finish
Work
Baseline Start Baseline Finish
Baseline
Duration
Baseline Work Resource Names
Task1 2 days 26/06/09 9:00 AM 30/06/09 9:00 AM 16
hrs
26/06/09
9:00
AM 30/06/09 9:00 AM 2 days 16 hrs R1
Just copy the notepad, wrap the test
this is my MPP task line, when published it will store
in
the
Some
of
the
table correct, but here displayed in the MPP Baseline
work
is
16hrs,
the same task datewise stored in some where, WHERE IT
is
STORED.
still you're not clear, give your mail id : i will
forward
my
MPP
:
Hi,
I still do not understand the question.
AFAIK, There is no such thing as a "date wise
Baseline
duration
"
you can ent anything to jandemesATprom-ade.be
Greetings,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi
I know that, i will give the sample data, when i
baseline
after
that
publish
that date wise Baseline duration where will store.
now your clear or i will send the detail XL sheet.
give your mail ID
:
Hi,
Baseline duration is a number of days, not a date.
BaselineStart and BaselienFinish are dates.
Does that help?
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi RG,
Project Server 2007,
My Query :
TASK St Dt Fin.Dt Duration
Task1 26/06/2009 29/06/2009 2Days
in MPP it will display only for 2days, where to
i
find
out
the
Datewise
Baseline Duration
:
Ah, that isn't a question, it's simply saying
the
version
of
project
