Rules for rollover?

[dharav]

Hello All

I am working on a model where rollover would take place on the basis of control cube. If we change the month in control cube than up to that month data would come from actual and rest of them must STET.

I wrote following rule after creating an attribute called cherry,

['Forecast']=IF((Attrn('forecastcalculations',!forecastcalculations,'Cherry')<=ATTRN('ForecastCalculations',DB('1f_Admin','Actual Month','Version - Month View'),'Cherry')),['Actual - Current Year'],STET);

When above rule is triggering, the all months are getting locked and getting actual instead of getting actual till Jun. I also think letter part of the rule must indicate how it would select forecast month to get actual and leave remaining.

Let me know if you have any thought on this.

Thanks

Dharav Patel

[Steve Rowe]

I think you should right click on data point in the cube that is locked but you think should not and trace the calculation. This should help you deduce what the issue is.

[tomok]

When above rule is triggering, the all months are getting locked and getting actual instead of getting actual till Jun.

Without the N: before the start of the right hand side of the rule then you are applying it to all nodes, even consolidations. That's why your "All Months" rollup is not working the way you expect.

[dharav]

Hello All

When above rule is triggering, the all months are getting locked and getting actual instead of getting actual till Jun.

Without the N: before the start of the right hand side of the rule then you are applying it to all nodes, even consolidations. That's why your "All Months" rollup is not working the way you expect.

I have applied both N: and None (N:+C:) ahead of the rule and tried it. Result is same. According to me, there is something missing in the rule itself which should


My existing Rule says if attribute of actual month (from control cube) is less than attributes of elements of month dimension than it should considered actual current year otherwise STET. I should mentioned in the rule if attribute of actual month (from control cube) is less than attributes of elements of month dimension than it should considered actual data only for those months whose attribute is less.

E.G.:

Suppose in my control cube actual month is jun. Jun has attribute value 6.
In month dimension jun has value 6
Now, rule should get actual from Jan to Jun and STET from Jul to dec.

Could you let me know, how would it be helpful to me to modify the existing rule?



Thanks

Dharav

[dharav]

Hello All

After a long wait, I got the drill to execute rollover rules

(Here, I wanted to build generic rule which satisfy the demand of actual month during all twelve months)

In admin cube, if we change forecast month to Aug (7+5) than Aug (7+5) should include 7 month actual and 5 month only open for it.
I achieved through control element attributes cube through comparing attributes of all elements of month dimension and the attribute of actual month appear in admin cube.

It works as expected.

Thank You for your input and time.

[Wim Gielis]

I achieved through control element attributes cube through comparing attributes of all elements of month dimension and the attribute of actual month appear in admin cube.

Using attributes in rules like this, is indeed good practice! Much better than relying on indexes or parents of elements in dimensions.