FACT table Partition


  • 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