Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning Everyone,
I'm having some issues with section access. Here is the error message I'm receiving: What am I missing? Thanks
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LET vToday = today();
Let vCYear = year(vToday);
LET vPYear = year(vToday) - 1;
LET vPrevYear = vYear - 5;
LET vRolling4 = makedate(vYear - 5, month(vToday), 1); // rolling 4 years
LET vRolling3 = makedate(vYear - 4, month(vToday), 1); // rolling 3 years
LET vPrevToday = makedate(vYear - 2, month(vToday), 1);
LET vFormatToday = Num(vToday);
Let vFormatRunDate = date(vToday, 'YYYY-MM-DD');
Let vRunDate = date(vToday, 'YYYY-MM-DD');
Section Access;
LOAD
"ACCESS",
"USERID",
SAPROFITCENTER,
[Node1],
[Node2],
[Node3],
[Node4],
[Node5],
[Node6],
[Node7],
[Node8],
[Node9]
FROM [lib://QVD/Section Access/SAUsers.QVD] (qvd)
;
Section Application;
ExpandedNodes:
LOAD
[Node1],
[Node2],
[Node3],
[Node4],
[Node5],
[Node6],
[Node7],
[Node8],
[Node9],
ParentGroup,
Path,
NodeIDCostCenterName,
ParentIDGroup,
Node
FROM [lib://QVD/Section Access/ExpandedNodes.QVD]
(qvd);
ExpandedNodeNames:
LOAD
Level1,
Level2,
Level3,
Level4,
Level5,
Level6,
Level7,
Level8,
Level9,
ParentCostCenterGroup,
"Davey Hierarchy",
NodeIDCostCenterName,
ParentIDCostCenterGroup,
Level,
DepthCostCenterGroup
FROM [lib://QVD/Section Access/ExpandedNodeNames.QVD]
(qvd);
AncestorNodes:
LOAD
NodeIDCostCenterName,
AncestorIDCostCenterGroup,
AncestorNameCostCenterGroup,
DepthDiffCostCenterGroup
FROM [lib://QVD/Section Access/AncestorNodes.QVD]
(qvd);
ProfitCenters:
LOAD
NodeIDCostCenterName,
"Profit Center",
SAPROFITCENTER,
"Profit Center Name",
"PC Desc"
FROM [lib://QVD/Section Access/CostCenterGroupHierarchy.QVD]
(qvd);
Exit Script;
All rows in Section Access need to be in uppercase:
Upper([NODE1] as NODE1
All rows in Section Access need to be in uppercase:
Upper([NODE1] as NODE1