Hi,

I have a fact table as follows:

Yr Mn Doc# Acct Transaction Amt
--------------------------------------------
2003 01 Document_1 Account_1 $10
2003 01 Document_2 Account_2 $20
2003 02 Document_3 Account_1 $100
2003 02 Document_4 Account_2 $200

Now when I create the cube, I want to be able to introduce a
calculated member called OB (Opening Balance). just so that, I can get
the following view:

Yr Mn Acct# OB Transaction Amt
--------------------------------------
2003 01 Account_1 $0 $10
2003 01 Account_2 $0 $20
2003 02 Account_1 $10 $100
2003 02 Account_2 $20 $200

Is this possible ? How ?

Thanks a lot.

Try:

WITH MEMBER Measures.[OB] AS
'Iif(Time.CurrentMember is Time.CurrentMember.Parent.FirstChild, 0,
(Time.CurrentMember.Parent.FirstChild, [Unit Sales])) '

Thanks

Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.