Custom control cubes

Post Reply
stex2727
Posts: 66
Joined: Tue Sep 15, 2009 11:29 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Custom control cubes

Post by stex2727 »

Tis Christmas time and all is quiet. Dear Santa I would like to have a custom control cube for my TM1 server for Christmas.

I know a similar end result could be achieved through security but I like the functionality that it is generally hidden from the end user unless they display control cubes. I wonder if any of Santa's little helpers know of a work around?

Stex
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Custom control cubes

Post by Alan Kirk »

stex2727 wrote:Tis Christmas time and all is quiet. Dear Santa I would like to have a custom control cube for my TM1 server for Christmas.

I know a similar end result could be achieved through security but I like the functionality that it is generally hidden from the end user unless they display control cubes. I wonder if any of Santa's little helpers know of a work around?
There's nothing to stop you from creating your own control cubes starting with a } character. IIRC you can't do it via the GUI but you can certainly do it via TI.

I don't necessarily encourage this (though I admit to having done it myself) since there's always the remote possibility of the name that you choose going into use in a future version of TM1, but it's viable.

I'd actually take your request one step further and ask for the ability for each user to filter individual objects (to make only their most commonly used ones visible by default), though I suppose that you can achieve the same end (kinda-sorta) with Applications. (Can be a bey-hatch to do through the GUI when you have a lot of objects, though.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
stex2727
Posts: 66
Joined: Tue Sep 15, 2009 11:29 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Custom control cubes

Post by stex2727 »

Thanks Alan, never thought of TI, nice. You should be safe if you prefix it with something odd }'insert company name here', but then again it is IBM (if you cant beat em, buy em)

ta
Stex
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: Custom control cubes

Post by Martin Ryan »

Only minor gotcha is that if you create a custom control cube you can't delete it via the front end. You have to stop the server, delete the back end file and restart. This can be a bit annoying during the dev stages when you might find you have to keep rebuilding to get the dimension structures just right.

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
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Custom control cubes

Post by Alan Kirk »

Martin Ryan wrote:Only minor gotcha is that if you create a custom control cube you can't delete it via the front end. You have to stop the server, delete the back end file and restart. This can be a bit annoying during the dev stages when you might find you have to keep rebuilding to get the dimension structures just right.
Not sure what you mean here.

If you mean that you can't delete it via the GUI, then no, but you can't create it that way either; as I said, you do it through TI via the CubeCreate function. Similarly the CubeDestroy function in TI will delete the cube and the .cub file. There's no need to restart the server; you can create and destroy it as many times as you need to (with as many different combinations of dimensions as you want) using those two commands. Or certainly you can in 9.0 and I doubt it's any different in 9.5.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply