Rule for Attribute cube for Months with a current month flag

[BigG]

Hi, I have a Current Month flagged "Y" in my Month dim. I would like to apply logic through a rule in the attribute control cube to another attribute Act_For saying if Current Month or greater then type "F" in Act_For else "A". I also have a Month_Number I can use as an 'index' of sorts. Dont know if this is possible but if anyone has some suggestions then great...

[Martin Ryan]

I think the below should work. In pseduo code
- Set the first month to Actuals
- Write a rule so that the first month after the current month is forecast
- All other months can just be the same as whatever last month was.

I've used a "Prev" attribute, but I guess you could make your index work too. Though might not be as straightforward.

Code: Select all

# Set the very first month to 'A' manually.  Or can do via rule if you have no feeders.
['Act_For', 'Month 1] = S: stet;

['Act_For'] = S:
if(attrs('Month', attrs('Month', !Month, 'Previous'), 'CurrentMonth')@='Y', 'F',
DB('ThisCube', attrs('Month', !Month, 'Previous'), 'Act_For'));

HTH

EDIT: I should have read closer, you said the current month was forecast, not actuals. Logic still applies though...

[BigG]

Simple as it is inthe end, it took me a couple of reads ...but I finally got it, Will give that a go, thanks Martin