Dear All,
Persume that I have a cube with the following measures and dimension:
DimTime, measures.LatchSignal, measures.Voltage
0,1,4
1,0,5
2,0,6
3,0,5
4,1,3
5,0,7
6,0,5
7,1,6
8,0,7
Is there anyway I can repeat the value of voltage on and after the time when latch signal = 1, so that the result is rendered as follows:
DimTime, measures.LatchSignal, measures.Voltage, measure.latchedVoltage
0,1,4,4
1,0,5,4
2,0,6,4
3,0,5,4
4,1,3,3
5,0,7,3
6,0,5,3
7,1,6,6
8,0,7,6
Thanks and regards,
Tony Chun Tung Siu
Hi Tony!
Why do you try to make it in MDX. What the problem do you solve?
I would make it in DSV in oder to get
0,1,4,4
1,0,5,NULL
2,0,6,NULL
3,0,5,NULL
4,1,3,3
5,0,7,NULL
6,0,5,NULL
7,1,6,6
8,0,7,NULL
then apply lastnonempty aggregation function for the measure latchedVoltage
|||Hi
I just wanna plot a graph for such signal implementation. This works!.
Thanks
Tony
No comments:
Post a Comment