I am trying a calculated member in Cube Editor.Expression is as follows
Net=((SalesAmount-Discount)*Currency Factor)/Currency Factor. If i take
Currency factors as measures(sum by default),the calcultion is not
correct.Hence i want to calculate on each day of invoice sum up the value
and display by Customer Dimension.Any ideas how to write Value Expression
in Cube Editor for Calculated member"Net" as definded above.

Thanks in Advance
MV

--
Message posted via http://www.sqlmonster.com