Please have a look on below scenario with attached image - I am facing an issue in getting the correct stock value "Before initialization day".
1. I did initialization on 01.03.2015.
2. I have taken postings data from from 01.01.2015 - 31.12.2099 while filling up setup tables.
3. Now in my CUBE I have the stock from 01.01.2015 - 31.12.2099.
PROBLEM - In my query I am getting correct stock data if I see from 01.03.2015 (From the day of initialization), however I am not getting correct stock value before 01.03.2015 (Before initialization date).
I am not sure what is missing or what is going wrong in OLAP that I am getting big difference in stock before the initialization day.
Could you please give me any hint to resolve or at least understand the problem area?
Message was edited by: Rudra Sonar