Delete rows from an accumulated table

Comments

3 comments

  • Avatar
    Robert Hauenstein

    Also interested to see if this is possible.

    0
    Comment actions Permalink
  • Avatar
    Kulpreet Singh

    Hi,

    There is no solution or comment on this post from Sisense. is there any way to delete old data from table?

    Thanks

     

    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Unfortunately there are no possibilities, except relaunching a full build (with a proper time filter in your import script). Most of the cube I use, I schedule a full refresh from time to time, or have to do one on some occasion.

    Then, it depends why you need to get rid of those historical data. If this is for performance issue, most of the time you should be fine. If you reach your license size limit this is more a problem.

    But if this is for preventing users to see oldest data, you can simply use a security rule : simply add a calculated column based on the date, and set security rule for users based on this column.

    Best, David.

    0
    Comment actions Permalink

Please sign in to leave a comment.