Section Access

[#1]

Section Access;

Load [Access]

      ,[NTName]

      ,[UserName]

      ,[Password];

      SQL SELECT *

  FROM[Access];@

  STAR is *;

LOAD  UPPER([NTName]) as NTName

      ,[CostCenter]as COSTCENTER;

      SQL SELECT *

  FROM [CostCenter];

I must filter data based on costcenter

Will the above code work?

Initial Data reduction is turned on.

Strict exclusion turned on

Security - reduction - turned on.

[chiru_thota · Accepted solution]

It should work.

Only error I can see is you should end the code with

SECTION APPLICATION;

Thanks,

Chiru

*******************************************************************

Section Access;

Load [Access]

      ,[NTName]

      ,[UserName]

      ,[Password];

      SQL SELECT *

  FROM[Access];@

  STAR is *;

SECTION APPLICATION;

LOAD  UPPER([NTName]) as NTName

      ,[CostCenter]as COSTCENTER;

      SQL SELECT *

  FROM [CostCenter];

******************************************************************

[#3]

Thanks will try now..

[hic]

It is USERID, not UserName. And you need to use upper case. I.e.

Section Access;

Load Upper(Access) as ACCESS

      ,Upper(NTName) as NTNAME

      ,Upper(UserName) as USERID

      ,Upper(Password) as PASSWORD;

      SQL SELECT * FROM [Access];

  STAR is *;

LOAD  UPPER([NTName]) as NTNAME

      ,UPPER(CostCenter) as COSTCENTER;

      SQL SELECT * FROM [CostCenter];

Further, the "Star Is *" doesn't always solve the problem. It will only be matched against other values in this table - not the values of other tables.

HIC