Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pawan_patel123
Starting Member
1 Post |
 Posted - 2005-02-25 : 07:51:44
|
| Dear Friends,I want to show stock level using a calculated member which is semiadditive. Now the problem is that the last data available is at level 2005 >> January and am using expression given below :(ClosingPeriod([Month],[Measure].[Closing Stock]))Product Quarter Month Closing Stock XYZ Qtr 1 January 50XYZ Qtr 1 January 40 But when the cube is viewed using Quarter or year level it show blank since it searches for December Values. How can I change it to the last member available.Looking forward to your response.thanks in advance. |
|
|
|
|
|
ClosingPeriod