601,100
562,"CHARACTERDELIMITED"
586,"C:\TM1Models\D2G Performance\Uploads\Employees2.csv"
585,"C:\TM1Models\D2G Performance\Uploads\Employees2.csv"
564,
565,"q@K2q:S:EQbi]20Y3aJDX_Gzrs`Lfw]v]7T2lgG9v9ctRBZwcaaFEPrWJNbD;:dtx6nRiaPswk8]:4VLAaii^mVe2SOGu5h[GY:fa\a]h\xwY^Xump8MiY[5=`QO7Z`dzqM7W_XC5kKBe1SkYv@X;9MX[IuVtgOT0kO?V4V=qGWU1gpB4eu=f<1PNaqfvBwHbh3XUmgy"
559,1
593,
594,
595,
597,
598,
596,
800,
801,
566,0
567,","
588,"."
589,","
568,""""
570,
571,
569,1
592,0
599,1000
560,1
pFiscalYear
561,1
2
590,1
pFiscalYear,"2010"
637,1
pFiscalYear,FiscalYear? eg 2010
577,9
Employee
Department
Position
Salary
FTE
StartMonth
EndMonth
Name
Region
578,9
2
2
2
1
1
2
2
2
2
579,9
1
2
3
4
5
6
7
8
9
580,9
0
0
0
0
0
0
0
0
0
581,9
0
0
0
0
0
0
0
0
0
582,9
VarType=32ColType=827
VarType=32ColType=827
VarType=32ColType=827
VarType=33ColType=827
VarType=33ColType=827
VarType=32ColType=827
VarType=32ColType=827
VarType=32ColType=827
VarType=32ColType=827
572,38

#****Begin: Generated Statements***
#****End: Generated Statements****

vDim = 'ExistingEmployees';

#****************************************************************
# Unwind Dimension
#****************************************************************
x = DIMSIZ(vDim);

While(x >= 0);

    vElement = DIMNM(vDim, x);

    x2 = ELPARN(vDim, vElement);

    While(x2 > 0);
        vParent = ELPAR(vDim, vElement, x2);
        DimensionElementComponentDelete(vDim, vParent, vElement);
        x2 = x2 - 1;
    END;

    x = x - 1;

END;

#DimensionDeleteAllElements(vDim);

#****************************************************************
# Make sure Attributes are created
#****************************************************************
AttrInsert(vDim, '', 'Description', 'A');

#****************************************************************
# Top Level
#****************************************************************
DimensionElementInsert(vDim, '', 'All HR Regions', 'C');
573,10

#****Begin: Generated Statements***
#****End: Generated Statements****

vDim = 'ExistingEmployees';

DimensionElementInsert(vDim, '', Employee, 'N');
DimensionElementInsert(vDim, '', Region, 'C');
DimensionElementComponentAdd(vDim, Region, Employee, 1);
DimensionElementComponentAdd(vDim, 'All HR Regions', Region, 1);
574,14

#****Begin: Generated Statements***
#****End: Generated Statements****

vDim = 'ExistingEmployees';

AttrPutS(Employee | ' ' | Name, vDim, Employee, 'Description');

CellPutN(Salary,'LabourExistingInputs','Local','Budget Entry', pFiscalYear, Region, Employee,'Override Salary');
CellPutS(Position,'LabourExistingInputs','Local','Budget Entry', pFiscalYear, Region, Employee,'Position Grade');
CellPutS(Department,'LabourExistingInputs','Local','Budget Entry', pFiscalYear, Region, Employee,'Department');
CellPutN(FTE,'LabourExistingInputs','Local','Budget Entry', pFiscalYear, Region, Employee,'FTE');
CellPutS(StartMonth,'LabourExistingInputs','Local','Budget Entry', pFiscalYear, Region, Employee,'StartMonth');
CellPutS(EndMonth,'LabourExistingInputs','Local','Budget Entry', pFiscalYear, Region, Employee,'EndMonth');
575,3

#****Begin: Generated Statements***
#****End: Generated Statements****
576,CubeAction=1511DataAction=1503CubeLogChanges=0
638,1
804,0
1217,0
900,
901,
902,
903,
906,
907,
908,
904,0
905,0
909,0
911,
912,
913,
914,
915,
916,
917,0
918,0
919,0
920,50000
921,""
922,""
923,0
924,""
925,""
926,""
927,""
