data warehouse - Is my accumulating snapshot design correct for my DW and my need -


i discovered accumulating snapshot design dw.

i need record bug info come bug tracker. bugs have info (a bug number, sentence ...). has status: created, canceled, affected, resolved

a bug don't have go through status (it can go created cancel, or created affected resolved ...)

here central fact table

ft_bug_track

idbug int

bugsentence varhchar(100)

createddate date

resolveddate date

affecteddate date

canceleddate date

fkstatus int

the status foreign key link dimension tells me in status i'm in (created, canceled ...)

(of course have others dimensions project, client, typeofbug ...)

everytime bug changing of status, i'll put new date needed , update fkstatus one

is design dw , system?

i have no idea if it's design situation, depends on requirements are, i.e. need able show in reports. if don't understand how data used , users expect find out it, should first before making big design decisions.

having said that, accumulating snapshots work best if goes through (relatively) well-defined, stable series of steps, manufacturing process or loan approval. unfortunately, case bug trackers: tickets can re-assigned different person without changing status; can re-opened , go through whole resolution process again; can 'bounce' , forth between 'in development' , 'in testing' , on. means can't know in advance how many dates , statuses required on lifetime of 1 ticket (unless have unusually simple process).

i worked on helpdesk reporting , came solution using 2 fact tables. first has 1 row per ticket , shows current status (new, assigned, closed, whatever), timestamps 'created' , 'last modified' only. second fact table has 1 row per ticket modification, can drill down detailed history of ticket. it's worth noting here many common changes ticket don't change status (e.g. adding comment) need decide 'modification' in case: change, or status change?

the etl process calculates , maintains ticket-level kpis on first fact table such how long ticket has been (or was) open, how long between submitting ticket , first being assigned etc. report users (e.g. managers) interested in durations between 2 specific events, , handling repeating or cyclical processes isn't particularly easy. reason try generate reports using main (aggregate) fact table, , leave second 1 interactive analysis, depends on want out off data.

even if doesn't answer question, hope gives ideas.


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more