TM1 Forum

Hello,
I have been using the following codes to zero out the data and I keep getting "Unable to register subset" error.
I usually have to click all the tabs and save before running to avoid that error.Is there another way?


CurYr=NumberToString(Yr);
vScenario ='Actual';
vCube = 'Expense';
vDimName1 = 'Scenario';
vDimName2 = 'Year';
vTemp = 'SystemUseOnly_Load' | STR(RAND, 10, 8);
vViewName = vTemp;
vSubName = vTemp;

SubsetCreate(vDimName1, vSubName);
SubsetCreate(vDimName2, vSubName);
SubsetElementInsert(vDimName1, vSubName, vScenario, 1);
SubsetElementInsert(vDimName2, vSubName, CurYr, 1);

ViewCreate(vCube, vViewName);
ViewSubsetAssign(vCube, vViewName, vDimName1, vSubName);
ViewSubsetAssign(vCube, vViewName, vDimName2, vSubName);
ViewZeroOut(vCube, vViewName);
ViewDestroy(vCube, vViewName);
SubsetDestroy(vDimName1, vSubName);
SubsetDestroy(vDimName2, vSubName);

This means that the subset you are trying to create already exists.

Oops! Just noticed that you had the RAND so that's unlikely to be your answer. Maybe it doesn't like the dot in the name (although you can save it that way without TI)