cancel
Showing results for 
Search instead for 
Did you mean: 

Statistical setup for S001 LIS structure

former_member185837
Active Participant
0 Kudos

I've read several threads about the issue of loading those InfoCubes which are still populated through the old fashioned LIS structure-based DataSources. However, it's not clear to me which steps need to be performed to implement a delta loading scenario.

Specifically, the 0SD_C01 InfoCube (Customer) is loaded by the 2LIS_01_S001 DataSource, which is based on the S001 LIS structure.

I read in an old book (Business Information Warehouse for SAP, by Naeem Hashmi, 2000 Prima Publishing) that (in a SD scenario) <i>to build initial data loads for SAP BW, you need to first populate LIS tables S260, S261, S262 and S263. The process of populating such tables is called the <b>statistical update</b>.</i>

Then it explains the steps for preparing and loading initial statistical data for SD InfoCubes:

- Disable LIS updating using transactions OMO1 and OMO2.

- Execute statistical update program (transaction OLI7 for S260, OLI8 for S261, OLI9 for S262, and OLI7/OLI8 for S263).

- Load data in BW.

- Activate LIS structures updating (OMO1, OMO2).

<u>The <b>S001</b> structure is never cited</u>! Has it been forgotten or a different procedure needs rather to be followed? Does S001 need any statistical update? If yes, how should this be carried on?

In my system, S001 supports both full and delta update. The delta update is active and the DataSource has already been generated (checked with transaction LBW0). Moreover, the S001 table contains 31.180 entries, the S001BIW1 table contains 36 records, and the S001BIW2 table has 14.620 records.

What do I need to do? To perform an initil load on the BW-side, the S001 updating needs to be deactivated for sure. After this I shall reactivate it and schedule the delta loads. But is this enough?

Cheers, Davide

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185837
Active Participant
0 Kudos

I performed a test in the R/3 development system, running the report RMCVNEUA (transaction OLI7) for the S001 structure. To execute this program I needed to keep active the (V2, in my case) update.

Before the statistical setup, the S001 table contained 29.277 records. After the program run, it contains 52.177 records. Thus, statistical setup does have an effect on this LIS information structure.

Now I<u> wonder if OLI7 is the right transaction</u> to be used. Could OLI8 or OLI9 be needed instead? And before running the statistical setup, <u>do the S001's data need to be deleted</u>? And <u>what about the S001BIW1 and S001BIW2 tables</u>? <u>Should they be emptied</u> some way, or the statistical setup program perform all these (needed?) deletion steps automatically?

After running RMCVNEUA, I deactivated the LIS update for S001, so I could load its data through a BW INIT request. Now I have reactivated the V2 update. Can I schedule the DELTA requests?

Thanks a lot, any help would greatly appreciated,

Davide

former_member185837
Active Participant
0 Kudos

SAP Note 64636 explains the procedure for the statistical data setup in LIS. Reading it I've understood the concept of <u>data versioning</u> in LIS tables

Thus even if repeating the statistical setup implies adding new records in the LIS table, nonetheless the actual data is that in the '000' version.

It's true that the BW INIT request gets all the records in the LIS table (version-independent). However somehow (well, I still can't understand <b>how</b>) just the current/actual data is reported (i.e. those data having version '000' in the R/3 LIS table).

In fact, I could reconcile the data showed by a standard LIS analysis on S001 with the data reported by a standard BW query on the Customer InfoCube (0SD_C01).

Finally, was a new statistical setup needed for the S001 LIS InfoStructure, you would need to run just the RMCVNEUA report (which reads the order tables).

Cheers, Davide

former_member185837
Active Participant
0 Kudos

<i>And what about the S001BIW1 and S001BIW2 tables? Should they be emptied some way [...]?</i>

Just a final note on this. When BW creates an INIT request for a LIS InfoStructure's data, the deltas (i.e. the content of the S001BIW1 and S001BIW2 tables) are automatically deleted by R/3, if present.

Best Regards, Davide