Strings - attributes or separate dimension?

Post Reply
JFerguson
Posts: 9
Joined: Fri Jan 08, 2010 7:04 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: UK

Strings - attributes or separate dimension?

Post by JFerguson »

I know TM1 & strings don't really mix, but when dealing with capital projects, there's a fair amount of static data i.e. as description, location, etc etc. So in setting up a capital project cost cube, I've decided to split out the strings and put them into a separate cube with 2 dimensions (project ref & strings).

Am I going to too much trouble or would using attributes be a better approach?
User avatar
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Strings - attributes or separate dimension?

Post by Steve Rowe »

Hi JF,
Sounds OK, a string cube is much more accessable to users as well.
Cheers
Technical Director
www.infocat.co.uk
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Strings - attributes or separate dimension?

Post by Martin Ryan »

Attributes are in fact held in simple two dimension cubes with the same structure as you mention (go to View -> Control Objects to a see these attribute cubes, plus a few other control cubes) so in your case it's a simple matter of how you'd like to see and use them.

If they're going to be used in rules then I'd suggest attributes would be better. If it's simply for information purposes then a string cube like you've got is probably better because it's easier to present to the users.

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