Fact and dimensional structure for Ticket tracking (Sorry can't edit the topic)
Hi,
I am new to Dimensional modeling and SSAS reporting. I am working on creating a cube but first I have to create the fact and dim tables.
I have to keep track of the status of tickets, dates they were opened and closed, operator that worked on the ticket, count of the tickets, the duration in days the ticket was open before it closed, and the # of tickets per customer.
Tables
FactTicket: Count for ticket, duration of ticket, status of ticket,
DimDate
DimCustomer
DimOperator: Operator_id, type, ticketcode
Please let me know if I should add any more dimtables. Any suggestions or advice is appreciated.
Thanks.