TM1 Forum

hi,
How the control cubes can help us in writing the rules.
In the standard demo in converting the currencies, the rules are written in control cubes, how the elements in the control cubes are connected to our cube created manually.
How the control cubes are going to function?

Thanks and regards
TM1 9.5.1(32-bit)
Excel-2007.

What do you mean by "the standard demo"? I just had a look at PlanSample and can't see any control cubes that relate to forex.

In any case, control cubes that you create yourself will work like any other cube you create, except that 1) they'll be hidden when control cubes are hidden and 2) you can't delete them via the user interface.

It's generally bad practice to create your own control cubes, except perhaps for really adminy things like controlling email bursting. But I'd usually recommend using security to hide these sort of cubes from people, rather than creating control cubes.

Martin

Dear Marrtin,
Standard demo in the sense training from IBM, and control cube was not created manually what i asked? in the training demo there is an situation for currency changing. This control cubes are used.

Thanks and regards.

For a forex calc? Really? I wouldn't want to say anything negative about our good IBM friends, but using control cubes to hold Forex rates is not what I'd call best practice.

IMHO, the only way that control cubes should be used in a forex calculation is that the currency codes should be stored as attributes against cost centres. Attributes are stored in control cubes - but that is the only way the control cubes should be involved. The rules will reference the attributes via attrs, not via DBs into the control cubes.

Marrtin (moving up from Ryan at least).

Martin Ryan wrote:IMHO, the only way that control cubes should be used in a forex calculation is that the currency codes should be stored as attributes against cost centres.

Even that would be a bad idea because you wouldn't be able to have any time distintinction to the rates without having a bunch of attributes. I wouldn't put it past IBM though.

By currency codes I meant currency codes, e.g. NZD, AUD, USD, GBP and so on. http://en.wikipedia.org/wiki/ISO_4217, http://www.currencysystem.com/codes/