Database Software

Hi All,

I know that the OLAP cubes store the leaf data and then builds the aggregate data on top of it and stores with in it. I have huge amounts of data ( like billions of data in my fact table and 6-8 dimension tables). If you keep the leaf data along with the agg data with in the cube would be too large to build.

So I am thinking to have to store only the agg data within the OLAP cube and for the leaf data it should still read from the Relational tables. Something like Hybrid OLAP.

(what I mean is

1. create the dimensions and cube in the AWM on 11g.
2. I will also specifiy the levels that I want the agg data to be calculated and stored in the OLAP cube.

(what I want is

1. I want to store only the agg data in the cube and leaf data still in the relatlional tables.
2. when I read the cube and drill down to the leaf level , it should fetch the leaf level data.

Is this possible in Oracle OLAP, if yes please provide some pointers

Thanks
S