Yes, you need to partition the table for improvements to ETL (SSIS) and partition the Cube and only process updated partitions.

Whether by date or version does not matter. What ever works best with your skills and knowledge.

Thomas