0

I hope you are well. I have this problem and I am a beginner in data warehousing. I hope to find a solution to it.

I have an OLTP database from the GLPI system. We are only interested in ticket management (a ticket is an issue raised by an employee in the form of a ticket). Each ticket can have several statuses: new, in progress, pending, planned, resolved, closed. In the OLTP database (data source), each time the status of a ticket is modified, the 'status' attribute is also updated, along with the modification date. Additionally, we have ticket closing and resolution dates.

Our job is to create a dashboard to track and visualize the number of tickets for each period, as well as the statuses of each ticket during each period.

The ETL runs every day. Our problem is how to capture these ticket transactions and display them. The supervisor suggested the idea of creating a fact table for each status, but we found that this is not logical.

How I can keep the history and display the statuses of each ticket by date for example the month passed how many tickets were closed?

2 Answers 2

1

The supervisor suggested the idea of creating a fact table for each status

I don't think it is a good idea. Looks like it's slowly changing dimension pattern.

1

Sounds to me like a case for a Periodic Snapshot Fact Table, eg

Date, TicketsOpened, TicketsClosed, OpenTickets

1
  • Thank you for your answer. I think so too, can you please give me sources to learn this type of table, because I cannot find them? Commented May 13 at 20:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.