Adding element to existing dimension

Post Reply
shosty
Posts: 18
Joined: Fri Jul 12, 2013 2:07 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2013

Adding element to existing dimension

Post by shosty »

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!
User avatar
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

Post by stephen waters »

- Make sure you have saved after adding element in Dimension editor
then
- Subset editor, select all?
shosty
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

Post by shosty »

stephen waters wrote:- Make sure you have saved after adding element in Dimension editor
then
- Subset editor, select all?
I made sure it was saved.

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"....
User avatar
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

Post by jim wood »

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
shosty
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

Post by shosty »

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?
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.
shosty
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

Post by shosty »

Issue resolved.
User avatar
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

Post by stephen waters »

shosty wrote:Issue resolved.
How? Was it a TM1 problem?
lotsaram
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

Post by lotsaram »

stephen waters wrote: How? Was it a TM1 problem?
As opposed to what? A "technical issue somewhere between screen and keyboard"?
Wim Gielis
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

Post by Wim Gielis »

lotsaram wrote:
stephen waters wrote: How? Was it a TM1 problem?
As opposed to what? A "technical issue somewhere between screen and keyboard"?
a PEBCAC ! :-)
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
User avatar
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

Post by qml »

Another frequent error type (I am sure that not in this case though!) is the One Delta Ten Tango variety.
Kamil Arendt
User avatar
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

Post by stephen waters »

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.
User avatar
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

Post by Martin Ryan »

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