Urgent : Query on Non cumulative cube

Dear BI Experts,

I have a non cumulative cube to help me report Stock Balance. It has stock entries from Jan till June,2006. When I query on the cube to report the balance as of Current Period (July,2006) it doesnot return anything. What I expected is that it would show me current stock balance (from Jan till June,2006) though my selection date is in July where there is new stock update done in July.

I tried compression on the cubes as well but didnot change the result.

Can anybody help.

Kind regards,

priyadarshi