Skip to Content
0
Former Member
Aug 12, 2016 at 10:05 AM

Use Measure for Calculated Dimension? (SAP Lumira 1.29 Desktop)

222 Views

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