none
FACT table Partition

    Question

  • Hi,

     

    I have a big joint cube in which I am using a FACT table which suppose to be process on daily and Monthy basis ie. "Daily Inventory" & "Monthly Inventory". 

     

    I am guessing, can I can create a Named query on the same FACT table based on filtering data on the daily basis from Oracle i.e. filter view of daily data...

     

    I believe I can bind that Named Query to a partition i.e. Daily View of Daily. Further linking that partition to the Integration services packages and execute them on daily basis versus the other one on Monthly basis. Agian it is a one big join cube.

     

    Help is appreciated

     

    Thank You 

    Sunday, September 30, 2007 2:40 PM