54537

OLAP cube design reference for a IT support business [closed]

We are designing a dimensional model for an IT support business. There are cases (some call them tickets or incidents) with different statuses (feels like an SCD type II dimension) We also need to consider the count of cases and SLA time duration as measures.

Before going into detailed design, I reviewed Kimbal's data warehousing toolkit but couldn't find a matching business for our project. Are there any references for a dimensional model for this type of business

Answer1:

From your limited information it sounds like you want to model as an <strong>accumulating snapshot fact</strong> (as well as a transaction table). See Insurance claim processing pipeline in Kimbal's The Data Warehouse Toolkit.

It would only be a Type II SCD if the dimension entries were being updated, which in your described case they are not (you are updating the Fact table)

Recommend

  • MySQL, Query count results and display in PHP page
  • How does MQ Light assure that message is not removed from queue if app crashes during processing?
  • mosso versus gogrid which is better?
  • What will be the time trigger value based on the Business hour in salesforce?
  • MDX: How to Retrieve data Based on Latest Date For Each Student Id
  • d3 animated line graph
  • need to identify dynamic input/textareas when inserting to database
  • What is the fastest way to select nearest geographical place from mysql database?
  • Reverse output of polyfit numpy
  • GridBagLayout padding
  • Google Analytics - Using Client ID as a custom dimension
  • Zooming an element and its contents— an alternative to CSS3's zoom property?
  • Numpy: How to get rid of the minima along axis=1, given the indices - in an efficient way?
  • Implicit property animations do not work with CAReplicatorLayer?
  • jQueryUI dialog replacement for confirm?
  • Are there “Dynamic Playlists” of unit tests in Visual Studio?
  • Appium MobileElement swipe returns unknown server error
  • Retrieving specified columns from a list of csv files to create a data data frame in R
  • How to make R's read_csv2() recognise the text characters properly
  • Using Sax parsing to edit and write XML in VB6
  • Django: Count of Group Elements
  • Can Jackson SerializationFeature be overridden per field or class?
  • Does CUDA 5 support STL or THRUST inside the device code?
  • How to extract text from Word files using C#?
  • Sending data from AppleScript to FileMaker records
  • MySQL WHERE-condition in procedure ignored
  • vba code to select only visible cells in specific column except heading
  • Warning: Can't call setState (or forceUpdate) on an unmounted component
  • Windows forms listbox.selecteditem displaying “System.Data.DataRowView” instead of actual value
  • InvalidAuthenticityToken between subdomains when logging in with Rails app
  • KeystoneJS: Relationships in Admin UI not updating
  • trying to dynamically update Highchart column chart but series undefined
  • JTable with a ScrollPane misbehaving
  • embed rChart in Markdown
  • Can Visual Studio XAML designer handle font family names with spaces as a resource?
  • How can I remove ASP.NET Designer.cs files?
  • Are Kotlin's Float, Int etc optimised to built-in types in the JVM? [duplicate]
  • How to get NHibernate ISession to cache entity not retrieved by primary key
  • How can I use `wmic` in a Windows PE script?
  • Unable to use reactive element in my shiny app