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.
single dimesnsion cubes
-
rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: single dimesnsion cubes
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:
The following information is from TM1 Developers guide:
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.Every cube has at least two dimensions and a maximum of 256 dimensions.
Cheers!
Rizwan Kaif
Rizwan Kaif
-
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: single dimesnsion cubes
That will be in version 9.6. IBM have also announced that they're releasing the two sided triangle, and the three sided square.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.
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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
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: single dimesnsion cubes
Dear Alan,
This was the question i was asked in discussing about TM1.
thank you
This was the question i was asked in discussing about TM1.
thank you
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: single dimension cubes
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!
And you had named hierarchies too!