Adding element to existing dimension
-
- Posts: 18
- Joined: Fri Jul 12, 2013 2:07 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2013
Adding element to existing dimension
Hey all,
I need to add a new element to an existing dimension in use by at least one cube in a very large, very complicated model. I tried manually inserting the element into the dimension, but for some reason it only shows up in the dimension list if I click "Edit Dimension Structure", not when I open the default view. Creating a new subset doesn't seem to work either. The new element also does not appear in the cube I am trying to edit. DimensionElementInsert isn't working for me in TI, but that is probably because it is interfering with some other process, and I am not familiar enough with the model yet to modify anything, although it may have to come to that.
If someone could just walk me through a step-by-step process to manually add an element to a dimension so that it appears in a cube, that would be great and I would be eternally greatful!
I need to add a new element to an existing dimension in use by at least one cube in a very large, very complicated model. I tried manually inserting the element into the dimension, but for some reason it only shows up in the dimension list if I click "Edit Dimension Structure", not when I open the default view. Creating a new subset doesn't seem to work either. The new element also does not appear in the cube I am trying to edit. DimensionElementInsert isn't working for me in TI, but that is probably because it is interfering with some other process, and I am not familiar enough with the model yet to modify anything, although it may have to come to that.
If someone could just walk me through a step-by-step process to manually add an element to a dimension so that it appears in a cube, that would be great and I would be eternally greatful!
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: Adding element to existing dimension
- Make sure you have saved after adding element in Dimension editor
then
- Subset editor, select all?
then
- Subset editor, select all?
-
- Posts: 18
- Joined: Fri Jul 12, 2013 2:07 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2013
Re: Adding element to existing dimension
I made sure it was saved.stephen waters wrote:- Make sure you have saved after adding element in Dimension editor
then
- Subset editor, select all?
When I go into subset editor, the element I need doesn't appear. For the element to appear, I need to be in "Edit Dimension Structure". There, I can "select all" and overwrite the dimension, but the element I need still doesn't appear in any view that isn't "Edit Dimension Structure"....
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Adding element to existing dimension
How big is the dimension? If it's big have you tried searching for it by name after pressing the all button? Have you tried doing a dimension save as to see if it appears in the newly saved dimension?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 18
- Joined: Fri Jul 12, 2013 2:07 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2013
Re: Adding element to existing dimension
There's about 60 dimensions appearing when I go to Edit Dimension Structure, with about 30 appearing in the default view. When I attempt to create a new subset, only the 30 that appear in the default view are available. It does not appear after clicking All and searching by name. It just doesn't appear at all period unless I'm in Edit Dimension Structure.jim wood wrote:How big is the dimension? If it's big have you tried searching for it by name after pressing the all button? Have you tried doing a dimension save as to see if it appears in the newly saved dimension?
-
- Posts: 18
- Joined: Fri Jul 12, 2013 2:07 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2013
Re: Adding element to existing dimension
Issue resolved.
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: Adding element to existing dimension
How? Was it a TM1 problem?shosty wrote:Issue resolved.
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Adding element to existing dimension
As opposed to what? A "technical issue somewhere between screen and keyboard"?stephen waters wrote: How? Was it a TM1 problem?
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Adding element to existing dimension
a PEBCAC !lotsaram wrote:As opposed to what? A "technical issue somewhere between screen and keyboard"?stephen waters wrote: How? Was it a TM1 problem?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- qml
- MVP
- Posts: 1094
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Adding element to existing dimension
Another frequent error type (I am sure that not in this case though!) is the One Delta Ten Tango variety.
Kamil Arendt
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: Adding element to existing dimension
Had to google both of those but I like them!
However, I think the current TM1 icon for "All" in the subset editor is very poor and difficult to see. One of my many gripes about "Subset Editor" (actually selector and sorter) which I am hoping will be addressed in future.
However, I think the current TM1 icon for "All" in the subset editor is very poor and difficult to see. One of my many gripes about "Subset Editor" (actually selector and sorter) which I am hoping will be addressed in future.
- Martin Ryan
- Site Admin
- Posts: 1988
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Adding element to existing dimension
My personal favourite is "warm ware error". I hadn't come across one delta ten tango before, must remember that one.
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
Jodi Ryan Family Lawyer