Error in Section Access

tmumaw — Sat, 16 Nov 2024 17:34:01 GMT

Good Morning Everyone,

I'm having some issues with section access. Here is the error message I'm receiving: What am I missing? Thanks

The following error occurred:

Field 'Node1' not found

The error occurred here:

LOAD "ACCESS", "USERID", SAPROFITCENTER, [Node1], [Node2], [Node3], [Node4], [Node5], [Node6], [Node7], [Node8], [Node9] FROM [lib://QVD/Section Access/SAUsers.QVD] (qvd)

Here is my script:

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;

Re: Error in Section Access

tmumaw — Wed, 27 Jan 2021 19:25:21 GMT

All rows in Section Access need to be in uppercase:

Upper([NODE1] as NODE1

topic Re: Error in Section Access in App Development

Error in Section Access

Re: Error in Section Access