Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Question - creating a dimensional model for incident management

Go down

Question - creating a dimensional model for incident management Empty Question - creating a dimensional model for incident management

Post  ngllamedo Fri May 25, 2012 6:01 am

Hello, folks. I'd like to ask some newbie questions.

I'm starting a new dimensional model for manage incidents who comes from sources like Remedy.

I want to measure things like
Number of total ticktes
Number of tickets in process
Number of resolved tickets
Average resolution time taking in account category or priority or subcategory or all together...
...

What I have do until now, is a large fact table with all the characteristics in it, but I think this is NOT a dimensional modeling.

INCIDENT_FACT
PK IDEN_ISSUE
IDEN_ALTERNATIVE_ISSUE
FK1 ID_COMPANY
FK2 ID_SUBCOMPANY
FK3 ID_ISSUE_TYPE
IDEN_BRIEF_DESC
IDEN_DESC
FK4 ID_GROUP_REPORTED
FK5 ID_GROUP_OPEN
FK6 ID_GROUP_ASSIGNMENT
FK7 ID_GROUP_RESPONSIBLE
FK8 ID_GROUP_CLOSE
FK9 ID_USER_REPORTED
FK10 ID_USER_OPEN
FK11 ID_USER_ASSIGN
FK12 ID_USER_CLOSE
CL_CAUSE_1
CL_CAUSE_2
CL_CAUSE_3
FK13 ID_CATEGORY_1
FK14 ID_CATEGORY_2
CL_PRIORITY_1
CL_PRIORITY_2
CL_NOTIFY_BY
FK15 ID_DEPARTMENT
BU_BUSINESS_IMPACT
BU_CUSTOMER_VISIBILITY
BU_SIH_PROJECT
BU_SIH_TASK
BU_CURRENT_STATUS
EX_SLA_ALERT
EX_PEND_REASON
EX_RESOLUTION_CODE_1
EX_FIX_VERSION
EX_AFFECTED_VERSION
LC_NOTIFICATION_DATE
LC_OPEN_TIMESTAMP
LC_ACCEPTED_TIMESTAMP
LC_FIRST_RESPONSE_TIMESTAMP
LC_RESOL_TIMESTAMP
LC_CLOSE_TIMESTAMP
LC_REOPEN_TIMESTAMP
LC_RESOLUTION_DURATION
LC_PENDING_DURATION
LC_DOWNTIME_DURATION
LC_RESPONSE_DURATION
INC_CNT_ID_ISSUE
INC_CNT_INCOMING_TICKET
INC_CNT_TICKETS_IN_PROCESS
INC_CNT_RESOLVED_TICKETS
INC_CNT_CLOSED_TICKETS
INC_CNT_CAUSE_RESOLVED_TICKETS
INC_CNT_PRIORITY_RESOLVED_TICKETS


What can I do? any clue for a newbie in this world?

Image of my model:
Question - creating a dimensional model for incident management Facttableincidentmanage

Thanks and sorry for my poor English,


ngllamedo

Posts : 1
Join date : 2012-05-25

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum