Post reply

limiting the amount of data getting into my cube

  • June 8, 2006 at 3:01 am

    #114396

    I have a cube. It has a time dimension “year”. My cube is pulling in over 6  years worth of data and this is killing the reporting apps. How do I limit the amount of data that my cube is getting? Wana limit it to just data from a year ago. im using sql server 2000 and analysis services 2000

  • June 8, 2006 at 6:34 am

    #642494

    Hi,

    if you want to restrict dimension values then in properties advanced set sourcetablefilter.

    to restrict the data from fact table edit partition click on next until you reach the last screen, you will find advanced where you can put filter on table that refers to year.

    hope this helps

    regards

    chethan

  • June 8, 2006 at 10:30 am

    #642590

    yes, that was quite helpful. in the source table filter text box, does it require MDX or SQL? there's no button to bring up an MDX builder or anything

     

     

    Thanks

  • June 8, 2006 at 9:09 pm

    #642697

    hi

    you can write a filter like this,

    "TableName"."ColumnName"=2005.

    its just like a condition in the where clause of SQL

    hope this helps

    regards

    chethan

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

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