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.
Subset Element Insert using TI Process
- 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
The answer lies with your data source. It's probably empty and therefore neither Metadata nor Data get executed.
Kamil Arendt