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);
Unable to register subset
-
- Posts: 26
- Joined: Thu May 29, 2008 2:58 am
Re: Unable to register subset
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)
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)