We have added new partitions in our SQL 2008 Sales cube for 2017 data and since then the cube process run for very very long time. I have created the new partition using script of existing one and tried processing manually, but no luck. The same view being used in old partition and it runs fine.
I did try adding 2017 dates in old partition and it runs successfully. So the new partition has some issues.
Any suggestions would be appreciated.
Thanks
Vishwanath