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

    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?