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 |
|
rockstar283
Yak Posting Veteran
96 Posts |
 Posted - 2011-08-09 : 18:55:26
|
| 8/5/2011 8/12/2011 8/19/2011 8/26/2011 Total Demand 315,792 25,000 500,000 Total Supply 150,564 210,526 35,000 200,000 Suplus Supply 150,564 -105,266 10,000 -300,000 Delta 150,564 45,298 55,298 0 Suplus supply = Total Supply - Total DemandCan somebody tell me how to calculate the Delta value in SSAS..I think its a calculated member..but I am not able to figure it out :(pls help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-10 : 07:50:04
|
| i think you need to add it as a calculated member using PREVMEMBER and CURRENTMEMBER------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How to find cumulative Delta value