Showing Nulls in Access point with section access

[Anonymous]

I used below script for the section access. When I/my colleague opens it through desktop we were able to see valid value, But through access point it was showing as nulls. And the dimension  was created out of a cyclic dimension group and field used in this cyclic group was not the one used in section access. The %REGION field had the values of different regions like south, west etc.,

Section Access;

LOAD upper(ACCESS) as ACCESS,

    upper(NTNAME) AS NTNAME,

    upper(%REGION) as %REGION

FROM

[http:xxxx/QMS/AuthTable]

(html, utf8, embedded labels, table is [SA_Dashboard]);

Section Application;

Desktop view

Access point View

Cyclic Group and Field used for this dimension (Location Branch)

[Anil_Babu_Samineni]

For me it sounds - You didn't engage any section access for your group? Can you share which expression it makes problem?

[Anonymous]

@Anil,

Don't go by the $0, as it's the first of the month, it's showing like that. I am able to see the numbers when I select previous months, the only issue is the discrepancy between desktop and access point view. I am not sure what exactly is causing the issue, but it's for the Channel and two of the other cyclic dimensions. I have highlighted the expression for which it was showing nulls. Basically if the LocationBranch is null or blank it should show as adjustments. I have given admin access to qvservices and my colleague, and for me I only assigned south. But my colleague nor me can see that as adjustment when we open the dashboard through AccessPoint.

[pradosh_thakur]

Did you add the system user account as an admin in the  section access script  ?

[Anonymous]

@Pradosh

Yes I have given admin access for system user account.