title: Need for OLAP cubes if we can Build views based directly off the RAW table
body: <p>Assume that the table in the source data is is clean and in a state where they can be used directly.</p>
  
  <p>I am trying to understand whether building views based off the RAW table is better than creating cubes. To make the VIEWS dynamic, we can have .NET application which would take paramteres for the view and execute a View with Parameters and get the data for Reporting and analysis.</p>
  
  <p>If I want to view the Sales of a Product for United states in the Month of Februaray. So, I can create a view joining Product, Customer get the sales for a particular day in the month of February.</p>
  
  <p>Instead of forming a Star Schema with Product, Date, Customer dimension. I am really trying to understand what is the standarad a company should go with.</p>
  
  <p>I have folks telling Cubes are only good for analysis not good for reporting . Whatever information we want  we can get it by creating a DYNAMIC Views</p>
  
  <p>Any advise or ideas on this ?</p>
  
  <p>Thanks!!</p>