Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
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);
Manish,
I changed to upper case still not working,.
Yes, Even I tried it. find the app
Try exactly what I wrote...!
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>?
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
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);
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
];