control cube

Post Reply
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

control cube

Post by viswaraju »

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.
User avatar
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

Post by Martin Ryan »

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
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
viswaraju
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

Post by viswaraju »

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.
User avatar
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

Post by Martin Ryan »

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).
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
tomok
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
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

Post by Martin Ryan »

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
Post Reply