Security not working

[Anonymous]

Hi,

attached shows two tabs.  the first is the security and the second it the load.  The Security for Luis.Black is not working.

Any help appreciated please.

Regards,

Laura 

[tresesco]

Put a space between 'INLINE' and '[' and retry.

[Anonymous]

syntax issue. fixed but security still not working.

[pradeep_s]

Please UnQualify NewState Column.

QUALIFY*;

UnQualify NewState;

WAU:

Load

      AccountNumber

      ,AccountName

      ,NewState;

SQL

SELECT

      a.AccountNumber

      ,a.AccountName

      ,CASE WHEN a.State='NSW' THEN 'NSW-Black'

            WHEN a.State='VIC_South' THEN 'VIC-Red'

       ELSE a.State End as NewState

  FROM Case a;

UNQUALIFY *;

[pradeep_s]

Laura,

Please UnQualify NewState Column.

QUALIFY*;

UnQualify NewState;

WAU:

Load

      AccountNumber

      ,AccountName

      ,NewState;

SQL

SELECT

      a.AccountNumber

      ,a.AccountName

      ,CASE WHEN a.State='NSW' THEN 'NSW-Black'

            WHEN a.State='VIC_South' THEN 'VIC-Red'

       ELSE a.State End as NewState

  FROM Case a;

UNQUALIFY *;

[tresesco]

How is the behavior? Is it working for some and not for some, or working for none?

[Anonymous]

all the others have access to everything and they do see everything.  its just luis.black that should see only VIC and see's everything

[tresesco]

Have you checked the 'Initial data reduction ..' in the document properties settings?

[Anonymous]

yes.  I've checked and they are on.  I added another user with the same credentials and their security didn't work either

[tamilarasu]

Hi Laura,

Try below attached file.

[Anonymous]

no luck.  does it have something to do with the field being created from a Case?