Get project cost monthly on MS Project SQL Server database -


i'm building custom reports company work projects.

i have cost of project month month , show on excel sheet.

however, i'm struggling find how cube summarize data.

so far, i've got this:

declare @res_name nvarchar(510) declare @begin_date datetime declare @end_date datetime  -- set these variables select @res_name = 'team member' select @begin_date = '2013-01-01' select @end_date = '2013-12-31'  -- end variables select            p.wproj_id project_id,        proj_name project,        month(assn_start_date) startmonth,        year(assn_start_date) startyear,        sum(assignmentactualcost) cost,        sum(assn_act_work)/60000 assigned_work,        sum(assn_rem_work)/60000 remaining_work            msp_web_projects p,       msp_web_assignments a,       msp_view_proj_assn_std vpa   p.wproj_id = 489 ,     a.wproj_id = p.wproj_id ,     vpa.wproj_id = p.wproj_id ,     assn_start_date between @begin_date , @end_date group month(assn_start_date), year(assn_start_date), proj_name, p.wproj_id order year(assn_start_date), month(assn_start_date)

it shows data, different showed cube.

what need know table stores information cost of know task or project, don't know how it.

thank's in advance.


-

Comments

Post a Comment

Popular posts from this blog

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

java - IntelliJ - No such instance method -

using intellij's 12 ultimate, i'm running following code in debugger: java import play.api.libs.json.jsvalue; public class foo { ... public jsvalue tojson() { ... } public class fooexample { ... foo foo = new foo(); system.out.println("...); //<-- breakpoint at breakpoint, right-clicked source code , picked "evaluate expression," typing in: foo.tojson() . but following error showed up: no such instance method: play.api.libs.json.jsvalue$class.com.foo.foo.tojson () am doing wrong? foo#tojson calls scala code, if matters. edit had breakpoint after instantiation of foo. downvoted it, deserved it. edit my answer no longer valid after op modified question (i.e. moved breakpoint actual is).. a breakpoint hit before line executed. in case foo has not yet been declared or instantiated (i.e. foo constructor has not yet been called). you'll need put breakpoint @ next line (or step on current line) if want evaluate foo ....
Read more