Session Access?

[pgrs4219]

Hi Community,

I have a requirement that needs to implement Session Access by Field name let say "CITY" i need only few user see all the city's data rest need to see few..

Here is the script that i used but no success.

Section Access;

LOAD ACCESS,

     NTNAME,

     CITY

FROM

[..\..\..\LOCAL_SOURCES\CITY\Session_ Access.xlsx]

(ooxml, embedded labels, table is [Authentication]);

Section Application;

LOAD * INLINE [

    %dim_CITY, CITY

   A, A

   B, B
  C, C
  D, D
  E, E
  F, F
  G, G
  H, H
  I, I
  J, J
K, K
L, L
M, M
N, N
O, O
P, P
Q, Q

];

AM attaching the XL file that i used.please help me with this.

Thanks

[Gysbert_Wassenaar]

You need to use a separate line for each city in the section access table. Comma separated strings will not be matched with individual city values in the application tables.

[maxgro]

maybe

Section Application;

LOAD * INLINE [

    %dim_CITY, CITY

  A, A

  B, B

  C, C

  D, D

  E, E

  F, F

  G, G

  H, H

  I, I

  J, J

K, K

L, L

M, M

N, N

O, O

P, P

Q, Q

];

SECTION Access;

LOAD ACCESS,

    NTNAME,

    SubField(CITY, ',') as CITY

FROM

SessionAccess.xlsx

(ooxml, embedded labels, table is [Qv Authentication]);

* in section access is for all listed values, not for all values

[pgrs4219]

Hi Maxgro,

Thanks for your reply,what should i used to let some users to see all the subfilelds inside the CITY.

[pgrs4219]

Hi Gysbert,

Thanks for your reply,Can you please share the exact script as am new i am unable to get it.

Thanks

[Colin-Albert]

Adding a user record with * in the city column will allow that user to see all cities that exist in the Section Access table.

marcus_sommer has put together a good post with links to many items on Section Access.
This should give answers to your questions. Section Access

[pgrs4219]

Thanks you maxgro,perfectly working.