title: Cube vs. Micro Cube in BusinessObjects
body: <p>I am having problems understanding cubes and microcubes in BusinessObjects environment.
  Although I have tried to find answers online, I did not find an answers that give overall explanations.
  Beside description of the functionality, I would like to know where is cube and where is micro cube located: on server or in browser?
  How many cubes/microcubes are there? One microcube per report or one micro cube per session, or sthg else?</p>
  
  <p>Furthermore, can anyone explain the difference in aggregations on database level as opossed to aggregation on report level (when defining a measure, there are two possibilities - to define aggregation on report and/or aggregation level). Although there are some answers online, they are too general. Therefore, I would appreciate a simple explanation with an example.</p>
  
  <p>And finaly, is it possible to color tables in data foundation layer? (since I have a lot of tables in a universe, it would be very helpful if I could color fact and dimensional tables).</p>