How to understand this? Deleting Elements

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

How to understand this? Deleting Elements

Post by macsir »

Hi, all. For preparing the exam, I found lots of interesting things in TM1 which I have not noticed before. Here is one of them,
for Deleting Elements from a Consolidation, everyone knows TM1 just move the element out of the consolidation, however
Note: If you define the element only within the consolidation, TM1 deletes the
element from the dimension as well.


How to understand this note? I can't repeat what it is saying in TM1. One consolidation only has one child inside it. When I Deleting this only element from a Consolidation, TM1 still just move it out of the group rather than deleting it from the dim. What's wrong here? :geek:
Deleting Elements from a Consolidation
Follow these steps to delete elements from a consolidation.
Procedure
1. Select the elements you want to delete.
v To select a single element, click the element.
v To select multiple adjacent element, click the first element, hold down SHIFT,
and click the last element.
v To select multiple non-adjacent elements, hold down CTRL, and click each
element.
2. Click Edit, Delete Element from Consolidation or click Delete .
A confirmation dialog box displays that lists the dimension name and asks if
you are sure you want to delete the object that you have selected. Click Yes to
proceed with the deletion, click No or Cancel to cancel the deletion.
TM1 deletes the element from the consolidation, and keeps any other instances
of the element in the dimension.
Note: If you define the element only within the consolidation, TM1 deletes the
element from the dimension as well.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
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: How to understand this? Deleting Elements

Post by Alan Kirk »

macsir wrote:Hi, all. For preparing the exam, I found lots of interesting things in TM1 which I have not noticed before. Here is one of them,
for Deleting Elements from a Consolidation, everyone knows TM1 just move the element out of the consolidation, however
Note: If you define the element only within the consolidation, TM1 deletes the
element from the dimension as well.


How to understand this note? I can't repeat what it is saying in TM1. One consolidation only has one child inside it. When I Deleting this only element from a Consolidation, TM1 still just move it out of the group rather than deleting it from the dim. What's wrong here? :geek:
Most likely the documentation, unless it's a version-specific thing. I can't reproduce it either in 10.1. I had a test hierarchy that I had created through some API tests. Let's leave aside the fact that the buggy piece of ... software... that is Dimension Editor wasn't showing the last element in the dimension and concentrate on deleting the one named 7th Army. This is the whole dimension, "show all elements" and all. The dimension had been created entirely by the API and was otherwise untouched at the time. The element therefore appears in one place only, at the hierarchy point shown:
DimEdit1.jpg
DimEdit1.jpg (82.56 KiB) Viewed 3115 times
The result? It's bounced out of the hierarchy but remains as an orphaned N element in the dimension. (If you sort by hierarchy 20th Army appears under 3rd with 7th at the bottom, outside the total):
DimEdit2.jpg
DimEdit2.jpg (66.91 KiB) Viewed 3115 times
The statement makes no sense anyway. An element can never be defined "only within the consolidation". It always exists in its own right as an N, S or C element, and may be merely attached to one or more consolidations. I thought that perhaps they meant that if you added a new element as a consolidation's child and then removed it before saving the dimension, you'd lose it entirely... but even that didn't work. I did that and when I went to look in Subset Editor lo and behold there was the new N element, just without any parents.

It's not impossible that the statement was true (most likely as a bug) in an older version but it doesn't appear to be true now.
"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.
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: How to understand this? Deleting Elements

Post by macsir »

Thanks, Alan, for the confirmation. :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply