Hello All,

What I'm trying to do is create:

Beginning Inventory
+ Orders
- Sales
-------------------
Ending Inventory

for any given date range (day, week, month, year, 15th to 15th, WHATEVER!)


How do I tell the cube to provide the Beginning Inventory for the First day in whatever date range? My SQL table has beginning inventory saved for every day.

Seems simple but I can't figure it out.

Thanks for your help!