We have two GLs S60040-Opening Stock and S60041- Closing Stock. We want to copy month-wise closing stock of previous month to opening stock of next month.
TIMES dimension is in following format:
I am unsure whether member formula will be a correct approach or writing a Business Rule ?
I tried using PREVMEM property of TIMES dimension but was unable to fetch the data of S60041 in subsequent month at S60040.
Please suggest how should I go ahead with the solution.