You will need to create a new calculated measure to represent the available stock value on any given day. You already have your date dimension linked to the fact table...

Thanks for the information. We're trying to use Excel 2007, so now we're looking into whether Excel 2007 can use the ADO MD client instead of OLE DB. ...

Edit - 09/03/08  Focus on provider differences.

After some additional testing we're focusing on the differences between the OLE DB and ADOMD providers.  We're connecting from a machine that is not...

Yes, they are on the same server.

Thanks,

JW

The question that comes to mind is how is the context being set for the evaluation of the expressions. The balance will be evaluated in the context of the...

Yes you can have a composite primary key in a dimension table. In the Dimension Wizard the step for specifying the key allows you to check multiple columns. ...