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.
control cube
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: control cube
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
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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
- Regular Participant
- Posts: 177
- Joined: Thu Nov 05, 2009 8:45 am
- OLAP Product: IBM COGNOS TM1
- Version: 9.5
- Excel Version: 2007
Re: control cube
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.
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.
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: control cube
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).
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).
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: control cube
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.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.
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: control cube
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/
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer