Post reply

What happens when a Default partition is not set up

  • September 29, 2014 at 2:22 pm

    #150784

    Hi,

    If I have a cube with datasourceview definition queries selecting the complete data from the fact table, but my partitions set up only for current year and last year. what would happen to the rest of the data. Would that be in the cube. If not, would that affect the processing time? Please advise if anyone knows.

    Thanks,

    Praveena

  • September 30, 2014 at 3:34 am

    #1749078

    venus.pvr (9/29/2014)

    Hi,

    If I have a cube with datasourceview definition queries selecting the complete data from the fact table, but my partitions set up only for current year and last year. what would happen to the rest of the data. Would that be in the cube. If not, would that affect the processing time? Please advise if anyone knows.

    Thanks,

    Praveena

    If you do not have a partition that covers the rest of the data then no, it won't be in the cube. In terms of processing time then it could make it faster - it all depends on the setup of your table (indexes, partitions etc.). It would stand to reason that less data = less processing time but if you're limiting the data with a query it may not always be the case!

    I'm on LinkedIn

  • September 30, 2014 at 7:39 am

    #1749140

    That makes sense , thank you for the answer.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply