Subset Element Insert using TI Process
Posted: Tue Oct 16, 2012 5:05 pm
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.
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.