Using Inventory Management in BI

[chris_robertson]

We are trying to make use of inventory data in BI. Weu2019ve installed business content for the cube 0IC_C03 and followed the steps in u2018How tou2026 Handle Inventory Management Scenarios in BWu2019 to get the data to the cube. The best I can understand I've loaded and compressed in the right order.

When we run a report it only seems to be reporting on the opening balance as defined in the 2LIS_03_BX load. It does not appear to be looking at the material movements as loaded in 2LIS_03_BF to calculate balances in the past. We installed from business content the Stock Overview report. Here is a sample of what Iu2019m seeing when drilled into a specific material that I know had inventory movements in 07 & 08 of 2008:

06/2008 1,002 EA

07/2008 1,002 EA

08/2008 1,002 EA

09/2008 1,002 EA

10/2008 1,002 EA

Anybody have any suggestions on what I need to look at? My understanding was that the query would used the material movements to calculate the balances for those months.

Thanks,

Chris

[chris_robertson]

I think we found the issue. In thread [] Sayed referenced note 353042. I'm not getting the process key into BI. So my transformation rules are not loading the correct values. I'm pretty certain that this is the issue though I still can't make sence of the solution steps noted in 353042.

Chris

(FYI - Sayed if you repost that to this thread I'll reward you points.)

Edited by: Chris Robertson on Oct 16, 2008 9:36 PM

[chris_robertson]

I needed to use transaction BF11 in R/3 and select the BW application.

The End,

Chris

[former_member181964]

Hi,

Check my thread..

Thanks

Reddy

[chris_robertson]

Reddy,

What I'm doing is basically what you posted in your thread. If I use MB5B to get this data for the material I see:

06/2008 0 EA

07/2008 902 EA

08/2008 1002 EA

09/2008 1002 EA

10/2008 1002 EA

In the BI query I'm only seing 1002 for each month which is the inital value loaded into the cube from 2LIS_03_BX. I assume that I'm diong something wrong in loading the cube or I'm missing a parameter in the query that says to calculate these values. But I'm not sure where to look.

Thanks,

Chris

[m_verbaan2]

Chris,

I assume you load to cube 0IC_C03 (or a copy).

If I can recall correctly you have to use InfoObject 0RECORDTP to display the correct data. This is due to the nature of this cube (stock snapshots),

0RECORDTP = 0 indicates the non-cumulative changes

0RECORDTP = 1 indicates the value of the marker that is stored as a non-cumulative change (= end non-cumulative.)

For me tcode LISTCUBE gives data for Record type = 1, and nothing for value 0.

Give it a shot!

Grtx

Marco

[chris_robertson]

Yes I'm loading into 0IC_C03 with no changes from Business Content.

I did listcube and can select 0RECORDTP = 0. It returns rows but every key figure is 0. I select 0RECORDTP = 1 and I can see rows with values. If I sum the total qty I get 1002 so 0RECORDTP = 1 is getting me the marker value amount.

So do I need to select 0RECORDTP = 0 on the query?. I can't find it on the query definition to do this. The query seems to be returning only the marker value.

[former_member181964]

Hi,

If you followed the steps correctly you must get the correct values in BW report and it will match with MB5B in ECC.

Do like this...

If you have any opening stock problem, please run the report

SAP_REFPOINT_COMPLETE and select Insert of Missing Records

and then check the data in the cube.

While checking data in MB5B, you need to give proper selections i.e. date and check valuated stock radio button.

Note: check what are date ranges that are you are giving in BW report and in ECC

Thanks

Reddy