Section access not reducing crosstable fields..help?

[gauthamchilled]

Hi, I have the following script. I want abc user to see only Weight as a measure. but abc user is able to see all the measure here in the  attached the application. kindly help how to reduce the field

SECTION ACCESS;

LOAD * INLINE
[
ACCESS,USERID,PASSWORD,upper(Measure)
ADMIN,ADMIN,ADMIN,*,
USER,abc,abc,Weight];

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SECTION APPLICATION;


CrossTable(Measure, Data)
LOAD Id,
[Volume l.],
Weight
FROM

(ooxml, embedded labels, table is Sheet1);

[MK_QSL]

Try like this...

SECTION ACCESS;

LOAD * INLINE

[

  ACCESS,USERID,PASSWORD,MEASURE

  ADMIN,ADMIN,ADMIN,*,

  USER,ABC,ABC,WEIGHT

];

SECTION APPLICATION;

CrossTable(MEASURE, Data)

LOAD Id,

     [Volume l.],

     Weight

FROM

(ooxml, embedded labels, table is Sheet1);

[Siva_Sankar]

Manish,

I changed to upper case still not working,.

[gauthamchilled]

Yes, Even I tried it. find the app

[MK_QSL]

Try exactly what I wrote...!

[gauthamchilled]

Hi,

I just copied your code and pasted it. Now I cant even open as user abc but I can able to see as admin. Can you point me where I am wrong>?

[avinashelite]

Hi ,

As I observe in the section access part for the Measure column you dont have any data that 's why its not allowing to see the data .

Try to add some data in the Measure column for abc and then check it will surely work

[avinashelite]

try like this :

SECTION ACCESS;

LOAD * INLINE

[

  ACCESS,USERID,PASSWORD,MEASURE

  ADMIN,ADMIN,ADMIN,*,

  USER,ABC,ABC,WEIGHT

];

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SECTION APPLICATION;

CrossTable(MEASURE, Data)

LOAD Id,

     [Volume l.],

     Weight as WEIGHT

FROM

(ooxml, embedded labels, table is Sheet1);

[MK_QSL]

SECTION ACCESS;

LOAD * INLINE

[

  ACCESS, USERID, PASSWORD, MEASURE

  ADMIN, ADMIN, ADMIN, *

  USER, ABC, ABC, WEIGHT

  DUMMY, DUMMY, DUMMY, VOLUME

];

SECTION APPLICATION;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CrossTable(MEASURE, Data)

LOAD

  Id,

  UPPER(Volume) as VOLUME,

  UPPER(Weight) as WEIGHT

Inline

[

  Id, Volume, Weight

  1, 123, 100

  2, 145, 200

  3, 167, 300

];