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 |
|
QAZAFI
Yak Posting Veteran
50 Posts |
 Posted - 2009-03-24 : 03:17:56
|
| Hi AllI am facing some problem in my Analyses services Cube.I have a time dimension and in time dimension I have a hierarchy Year Quarter Period? July, August September and so onI have a fact for actual values and year to date valueExamplePeriod Actual values Year to date values1 15 152 12 273 10 371st Quarter 37 79My year to date values for 1st quarter is 79 but I would like to display as 37 because I am already getting the sum for each period. Is there any way I could achieve that. Is Analyses service have any way to calculate year to date values and not to sum them on quarter and year level. Simply I would like to display period 3 year to date value as 1st quarter value and period 6th value as 2nd quarter value.I will really appreciate that if some one could help me out Many thanks Syed Qazafi |
|
|
QAZAFI
Yak Posting Veteran
50 Posts |
Posted - 2009-03-25 : 02:23:52
|
| Hi DearDOes any one have the answer of this question ?Many thanksSyed |
 |
|
|
QAZAFI
Yak Posting Veteran
50 Posts |
Posted - 2009-03-26 : 05:07:38
|
| Thanks all I have got the answer of my question and I have solve the problemSye Qazafi |
|
|
|
|
|
|
Year To date total Problem