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

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

      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?