TM1 Rules targetting specific cube views in the same cube

[conray]

hello everyone,

i would like to know if it is possible to apply specific rules only to specific cube views (created before hand) on the same cube?

[Martin Ryan]

You mean, for example, only applying the rule to Actuals? Or 2010? Or New York and LA? Sure...

['Actuals'] = N: your rule;
['2010'] = N: your rule;
[{'New York', 'LA'}] = N: your rule;

Martin

[conray]

hmm maybe i should rephrase my question to, applying rules to specific cube subset.

Here is my case:
I have a sales monthly report. Inside the report, i will have sales figure for 12 different periods, from January to December.
so for example, during january, the sales figure for january will be the actual sales figure and from february onwards, it will be forecasted sales figure.
during july, the sales figure for july will be the actual sales figure and from august onwards, it will be forecasted sales figure.

So finally, every month the report is viewed for example during september, i need to show Actual January to September sales figure, and the forecasted sales figure on the september month.

i think this is a fairly common scenario which most people have, but i am not sure how i can do it.

[Martin Ryan]

Create another scenario called rolling forecast and write something like this

['Rolling Forecast'] = N:
if(['Actual', 'All Products'] <> 0, ['Actual'], ['Forecast']);

Martin

[jkassier]

Hi. In addition to the above post, I would strongly recommend pointing the rule at a separate assumption, to control when actuals actually flow through to forecast. If this is a monthly model, you may wish to view the actuals for a certain month before they impact your forecast, and the above rule would not allow this. Best is to simply link this to a separate assumption whereby you can easily control when actuals flow through to forecast.