Below is the scenario
1 . Initial load of last 3 years -
I am Using Framework manager Model and filter on Calendar table to load last 3 years of Data in my first load and everything works fine.
2. last 2 periods refresh –
After initial load I am refreshing cube for last 2 periods. I am getting double count of records during my second load for last 2 periods.
Cube Properties :
Time based partitioning – period level