Answers.Body: <p>What do you mean? If you want to just do some reporting you could use any toolset like Pentaho, ClickView, Business Objects, Tableau or Periscope that you can attach to the CiviCRM database. Data warehousing sort of assumes you want to do your reporting on a frozen copy of the database, which you can easily do by dumping the CiviCRM database regularly. If you use a toolset that works with OLAP cubes you will have to define those cubes in your toolset. Something like ClickView does not need that. It does however require that you know your way around the CiviCRM database.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-11T17:13:25.380Z
Answers.Text: Erik, thanks, checking out all of those tools. I did see Pentaho in action at Jon G's demo at CiviCon in Denver. I'm doing a one-off analysis of our membership data, so will use a 'frozen' copy of the data. As well, I want to create useful reports/graphs that will update in real time off of the live  database, so for example to show continuously-updated membership counts per week/month/quarter/year and the changes/deltas over previous time periods - so at a glance all logged-in Civi users can see member counts and increases/decreases by our Regions, staff person who did the sign-up etc.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-12T10:47:44.673Z
Answers.Text: My data analysis guru is a big fan of ClickView for real-time dashboards, might be worth having a look?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-12T15:25:53.840Z
Answers.Text: Erik, thanks, I think you mean QlikView, right? As in http://www.qlik.com/us/explore/products/qlikview
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-15T06:23:33.137Z
Answers.Text: Yes I do JoeMcLaughlin, sorry about the typo :-)
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-10T10:49:05.697Z
Answers.LastActivityDate: 2015-09-10T10:49:05.697Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p><a href="https://civicrm.stackexchange.com/users/12/jon-g">Jon G</a> wrote this as part of an Answer to a <a href="https://civicrm.stackexchange.com/questions/2253/is-it-possible-to-get-point-in-time-membership-data">Question</a> about point-in-time/snapshot queries for membership data - "consider putting Civi data in a data warehouse that supports OLAP cubes. <a href="https://civicrm.stackexchange.com/users/271/parvez-saleh">Parvez Saleh</a> at Veda has implemented this and can probably speak to best practices." What is the best way to do this? </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-09-09T18:50:24.230Z
Comments.Text: Here's some info: https://forum.civicrm.org/index.php?topic=36111.0
Comments.UserDisplayName: Zachary
Tags: <civimember>
Title: How can I put Civi data in a data warehouse that supports OLAP cubes?
ThreadText: # How can I put Civi data in a data warehouse that supports OLAP cubes?
  
  (Asked by: username_0 on 2015-09-09)
  
  [Jon G](https://civicrm.stackexchange.com/users/12/jon-g) wrote this as part of an Answer to a [Question](https://civicrm.stackexchange.com/questions/2253/is-it-possible-to-get-point-in-time-membership-data) about point-in-time/snapshot queries for membership data - "consider putting Civi data in a data warehouse that supports OLAP cubes. [Parvez Saleh](https://civicrm.stackexchange.com/users/271/parvez-saleh) at Veda has implemented this and can probably speak to best practices." What is the best way to do this?
  
  **Tags:** civimember
  
  > **Comments:**
  > **username_1**: Here's some info: https://forum.civicrm.org/index.php?topic=36111.0  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-09-10. Score: 1 | Accepted answer
  
  What do you mean? If you want to just do some reporting you could use any toolset like Pentaho, ClickView, Business Objects, Tableau or Periscope that you can attach to the CiviCRM database. Data warehousing sort of assumes you want to do your reporting on a frozen copy of the database, which you can easily do by dumping the CiviCRM database regularly. If you use a toolset that works with OLAP cubes you will have to define those cubes in your toolset. Something like ClickView does not need that. It does however require that you know your way around the CiviCRM database.
  
  > **Comments:**
  > **username_0**: Erik, thanks, checking out all of those tools. I did see Pentaho in action at Jon G's demo at CiviCon in Denver. I'm doing a one-off analysis of our membership data, so will use a 'frozen' copy of the data. As well, I want to create useful reports/graphs that will update in real time off of the live  database, so for example to show continuously-updated membership counts per week/month/quarter/year and the changes/deltas over previous time periods - so at a glance all logged-in Civi users can see member counts and increases/decreases by our Regions, staff person who did the sign-up etc.  
  > **username_2**: My data analysis guru is a big fan of ClickView for real-time dashboards, might be worth having a look?  
  > **username_0**: Erik, thanks, I think you mean QlikView, right? As in http://www.qlik.com/us/explore/products/qlikview  
  > **username_2**: Yes I do username_0, sorry about the typo :-)  
  
  ---
  
  