What are the advantages of running queries on Cube over on ODS?
We know that we can run queries on both Cubes and ODSs, but what are the advantages of running queries on Cubes over on ODSs? We always hear that ODS provide more detailed information, but could someone gives us example of how detailed information can ODS gives v.s. Cube?
This deals with our decision whether we would use ODS or Cube to generate our queries.