Page 1 of 1

single dimesnsion cubes

Posted: Thu Mar 03, 2011 5:55 am
by viswaraju
hi,
please can anyone can explain me. Why we need to develope the cube with single dimension? in what scenarios can we apply this?

There is any specific memory allocated to particular dimension(set of dimension) or cube(set of cubes)?

This doubts for TM1 only.

thanks and regards.

Re: single dimesnsion cubes

Posted: Thu Mar 03, 2011 7:11 am
by rkaif
In TM1 you can not create a cube with only one dimension. The minimum requirement is at least 2 dimensions in a cube. If you will try to create a cube with only one dimension then TM1 will throw the error: The new cube creation failed.

The following information is from TM1 Developers guide:
Every cube has at least two dimensions and a maximum of 256 dimensions.
Can you tell us why you need to make a cube with single dimension? Whats the requirement? May be we can suggest you some other way of doing that.

Re: single dimesnsion cubes

Posted: Thu Mar 03, 2011 8:16 am
by Alan Kirk
viswaraju wrote:hi,
please can anyone can explain me. Why we need to develope the cube with single dimension? in what scenarios can we apply this?

There is any specific memory allocated to particular dimension(set of dimension) or cube(set of cubes)?

This doubts for TM1 only.
That will be in version 9.6. IBM have also announced that they're releasing the two sided triangle, and the three sided square.

As has already been mentioned a cube needs at least two dimensions. However there's nothing to stop you from creating the second dimension with only a single element (which you could call, say "Data"). In this case the cube would look like a single column list of values, which is presumably what you're after.

Using the attributes of the dimension to store data is another option (though in reality those are also stored in a 2D cube) but has the disadvantage that you can't easily calculate with it.

Re: single dimesnsion cubes

Posted: Fri Mar 04, 2011 5:52 am
by viswaraju
Dear Alan,
This was the question i was asked in discussing about TM1.

thank you

Re: single dimension cubes

Posted: Fri Mar 04, 2011 10:42 am
by David Usherwood
In the days when I did Express (that's IRI, then Oracle, not Cognos) you could create 'cubes' which had one dimension, or no dimensions. Very handy it was too for centralised parameters etc.
And you had named hierarchies too!