Skip to Content
0
Former Member
Jan 06, 2012 at 09:21 AM

What is the use of 2LIS_03_BX data source

108 Views

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