Hi Guys,
I have the following problem.
Situation:
1. In SAP Lumira Desktop I want to create a linear regression or trend line for dimensions x and y not associated with time (revenue and price).
2. Then I want to calculate the corresponding 'y' for each 'x' (y= alpha + beta*x) that is a point on this trend line. And get the delta/difference between the y of the trend line and the actual y.
What I already did, since the dimensions are not associated with time is create a series of Calculated Measures & Dimensions to get an intercept (alpha) and slope (beta) of the trend line (this works perfectly!). So basically I solved the formula of the trend line (y = alpha + beta*x), with two Measures alpha (1) and beta (2).
Complication:
The Measures alpha and beta are calculated measures, and I cant use - for some reason - the outcome of these Calculated measures to Calculate a new dimension. So I can't calculate the 'y' for the 'x' of each record in the data.
In addition, I can't just use the sum or build on these calculated measures with new calculated measures, since I want to use a filter (which records are under the trend line, and which are above), therefore I need an extra dimension.
Resolution:
My Questions:
1. Is there a way to use these calculated measures for a new dimension?
2. Is there an easier way to get what I want. E.g. another way to calculate the delta/difference?
Thanks a lot in advance for any help!
Rutger