How have other tackled the Inventory Cube? I am thinking along the lines of
these two strategies

1. 1 and only one snap shot at a time that we decide accurately reflects
realistic inventory levels. Meaning not necessarily at the end of the month
when they could be low.

or

2. Take 4 snapshots a month and average those 4 together giving me my
inventory snap shot for the month. Does anyone have other ideas? I'm
interested in hearing how you have solved this interesting situation.

-mike

Hello Michael,

The inventory problem is one of the most typical semiadditive measure
problems. Please refer to the following Article
which talks about Inventory snapshot recommendations for most accurate
results.

OLAP Services: Semiadditive Measures and Inventory Snapshots
http://msdn.microsoft.com/library/de...us/dnolap/html
/olapover.asp

Also, following book would be a good read for more info on inventory
problems,

Ralph Kimball's book: The Data Warehouse Toolkit
*
Please let me know if above information help answer your question.

Thanks for posting to MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional

Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security."
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
phx.gbl

Hello Michael,

Sorry about the wrong URL in my previous post . The correct URL is ,

OLAP Services: Semiadditive Measures and Inventory Snapshots
http://msdn.microsoft.com/library/de...us/dnolap/html
/semiadd2.asp?frame=true


Thanks

Vikrant Dalwale

Microsoft SQL Server Support Professional


Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security."
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------

This does not provide information on obtaining fact table data and methods
for inventory. It assumes you already have a fact table.



"Vikrant V Dalwale [MSFT]" <vikrantd (AT) online (DOT) microsoft.com> wrote

Hello Michael,

As this is more of a design question -- not really about the product issue
-- , I would recommend that you may research it in the technical literature
for some ideas, for example:
http://search.barnesandnoble.com/tex...iry.asp?isbn=0
471200247


Thanks for posting to MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional


Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security."
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
<NcIVBTuuDHA.2520 (AT) cpmsftngxa07 (DOT) phx.gbl>
phx.gbl