Hi Experts,
I designed the query on top of Inventory Cube , it has 5 years of inventory moments, so query is taking 45 mins to execute it, for this cube data is not loaded through 2LIS_03_BX data source, data is loaded through 2LIS_03_BF Data source only, now i have to reduce the Quey time
Please correct me if i am wrong
1. If i initialize the stock now(say on 06.01.2012) through 2LIS_03_BX data source and load historical data through 2LIS_03_BF Data source
Say if user want to see the Stock on 07.01.2012 of Material
system calculates like as below
Stock of the Material on 07.01.2012 = Opening stock of the material on 06.01.2012(using 2LIS_03_BX data source) + Stock Received on 07.01.2012(Moments from 2LIS_03_BF Data source) - Stock issued on 07.01.2012(Moments from 2LIS_03_BF Data source)
Stock of the Material on 08.01.2012 = Opening stock of the material on 06.01.2012(using 2LIS_03_BX data source) + Stock Received on 07.01.2012((Moments from 2LIS_03_BF Data source) + Stock Received on 08.01.2012(Moments from 2LIS_03_BF Data source) - Stock issued on 07.01.2012 - Stock issued on 08.01.2012(Moments from 2LIS_03_BF Data source)
2. If user want to see the stock before stock inialization date(say 05.01.2012),
how this value gets calculated
Stock of the Material on 05.01.2012 = all Received Qty since 5 years(<= 05.01.2012,(Moments from 2LIS_03_BF Data source)) - all Issued Qty since 5 years(<= 05.01.2012, (Moments from 2LIS_03_BF Data source)) ?
or
it uses Initialization stock value to calculate the Stock on 05.01.2012?(using 2LIS_03_BX data source and Moments from 2LIS_03_BF Data source)
Regards
Chandra