3 Replies Latest reply on Apr 20, 2012 3:36 PM by 932102

    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?