Milind,
Where to start in BW might be a bigger question than whether to use it for this one report. You would probably have to put in some effort getting up and running before you create your first report... on the other hand if its already available then you would just be building on an existing process.
We have been dealing with similar requirements at our company. Although you may have different business processes maybe some of this will help you. By "Inventory Management scenarios" I assume you mean delivered Business Content....
The first part of your report requiremnets are based on master data in BW - Material Master and attributes. You may need to enhance what is delivered.
<b>Total plant stock</b> - there is delivered business content that can probably account for that requirement (Material Movements cube - Company, plant, material, sloc, etc. and stock type ie. Project, restricted, QI, etc.
<b>Requirements</b> - We use planned reservations as part of our requirements. There is no delivered business content for Reservation documents. We had to create our own extract, ODS (flat file structure) and cube that aggragates material/plant over time.
<b>Usage/consumption</b> - we haven't extracted this yet, but it looks like the same scenario as reservations (no business content). We are either going to create a unique extract/ODS/Cube, or consider enhancing the Materials movement cube noted above.
Once you have these structures in BW, you can combine them into a new structure/cube that will include all your report requirements.
The benefit to doing this in BW is that your users will be able to do more dynamic analysis on the fly rather than downloading in excel and creating calculation each time, etc. Hope that helps
Bill Coombs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.