3 Replies Latest reply: Apr 20, 2012 8:36 AM by 932102 RSS

    Does OLAP cubes store primary fact data (10gr2)?

    929869
      Does Oracle OLAP(OLAP option of 10g database) physically store inside cube data of fact table it is based on?
      More detailed:
      1. There are fact table F and several dimension tables around it - D1, D2, D3
      2. In analytical workspace there is a cube C. C mapped to F and D1, D2, D3
      3. After the cube have been maintained does it contain all the data of table F? Will records of table F be duplicated in cube С somehow?