Subset Element Insert using TI Process

Post Reply
rill22
Posts: 8
Joined: Thu Dec 15, 2011 9:36 pm
OLAP Product: tm1
Version: 9.5.0
Excel Version: 2010 and 2007

Subset Element Insert using TI Process

Post by rill22 »

I'm trying to rebuild an existing subset using a TI Process and I'm using a cube for my data source. When I run the process the elements will get removed from the subset, but it wont put the new list of elements into the subset. The elements I'm trying to add into the subset are already in the dimension. When I run the process below, I get a successfully completed message but the new elements are not in the subset.

PROLOG TAB:
SubsetDeleteAllElements('Dimension', 'Subset');

DATA TAB:
SubsetElementInsert('Dimension', 'Subset', Element, 1);


WHAT I'VE TRIED...
- Disabled the SubsetDeleteAllElements in the prolog tab
- moved the SubsetElementInsert to the metadata tab
- placed SubsetElementInsert('Dimension', 'Subset', Element123, 1); into the prolog tab to make sure it would add the element - WORKED.
- placed SubsetElementInsert('Dimension', 'Subset', Element123, 1); into the data tab to make sure it would add the element - DID NOT WORK.
User avatar
qml
MVP
Posts: 1097
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: Subset Element Insert using TI Process

Post by qml »

The answer lies with your data source. It's probably empty and therefore neither Metadata nor Data get executed.
Kamil Arendt
Post Reply