Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Scenario I have is we have a recent calendar data loaded for 20 weeks. I have a multibox for weeks which shows a drop down list of all 20 weeks data. The reuirement is depending on the user access, admin role should be able to see all the 20 weeks data in the dropdown multibox and for regular user only recent most 13 weeks should be shown in the multibox field. It would be really helpful if you show me something with your example above to only show respective weeks depending on the useraccess role admin or user.
I was able to put the flag around the 'week' field saying that if (Week >13, 1, 0) as Week_Flag.
My 'Week' field has 20 weeks data now and depending on the section access, if its user then the 'Week' field need to reduce the data to show only recent 13 weeks. How should I do this or is there any alternative solution to this.
Please suggest if you have any samples to share that would be great too.
Thanks
DD
is this what you need? see attached example, which is basically this:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, VIEW
ADMIN, ADMIN, ADMIN, *
USER, USER, USER, 1
];
Section Application;
Calendar: Load *, if(Date >= Today()-(7*13),1,0) as VIEW;
Load Date(Today() - RecNo() +1) as Date AutoGenerate(365);
is this what you need? see attached example, which is basically this:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, VIEW
ADMIN, ADMIN, ADMIN, *
USER, USER, USER, 1
];
Section Application;
Calendar: Load *, if(Date >= Today()-(7*13),1,0) as VIEW;
Load Date(Today() - RecNo() +1) as Date AutoGenerate(365);
Thanks Juan!
It worked, as exactly what I was looking for thanks for all the help.
Just made these corrections:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, VIEW
ADMIN, ADMIN, ADMIN, 1
USER, USER, USER, 0
];
Section Application;
Thanks again,
DD
actually the * in the section access is intentional, so ADMIN can view everything in the calendar table..
Hi Juan,
The admin should be seeing all the data and user should only see the latest 13 weeks data, when logged in as a admin I only see 13 weeks data and not *.
Please suggest!
Thanks
DD
it seems the star in the section access isn't working (even with 'star is *')...leaving the VIEW field blank for ADMIN works:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, VIEW
USER, USER, USER, 1
ADMIN, ADMIN, ADMIN,
];
Thanks Juan!
This is exactly what I was looking for, appreciate all the help.
Thanks,
DD
Hi Juan,
Thanks for the solution but for some reason our section acces is complicated and its not working.
The section access is in the excel sheet as UserRoles sheet: which can be changed to admin/user/analyst for testing the other sheet access and it works.
OSUser | Role |
DDESAI\DIPTIDESAI | User |
'SheetAccess' in the excel has the following data which works to hide/show the sheet access for certain roles:
Role | Dashboard | Analysis | Geo | Outliers | Insights |
Admin | 1 | 1 | 1 | 1 | 1 |
Analyst | 1 | 1 | 1 | 1 | 0 |
Category Manager | 1 | 0 | 1 | 1 | 0 |
Senior Mgt | 1 | 0 | 1 | 1 | 0 |
Special User | 1 | 0 | 0 | 1 | 1 |
User | 1 | 0 | 1 | 1 | 0 |
The code for the Week field which needs to be 13/20 per user/admin role. Was successful to implement what you had mentioned in the calendar as:
date(WeekEnd(calendar_date),'MM/DD/YYYY') as Week,
if(calendar_date > Today()-(7*13),1,0) as Week_View
So when select the Week_View as 1 get only 13 weeks, when clear the selction get all the weeks its working like a charm.
The script for the section access and join to excel sheet using the roles is working fine, and I wasn't able to implement the section access part of you code, tweaking that I need help with since we have complicated section access code one is call to the database and one is the join to the above excel sheet code, how can we make it to work using Role and OSUser to make the weeks toggle between 13 for User and 20 for Admin.
SECTION Application;
LOAD NTNAME as USERID,
SECTIONKEY
Resident Sec;
Users:
LOAD Role,
upper(OSUser) as OSUser
FROM
UserSheetAccess.xls
(biff, embedded labels, table is UserRoles$);
Concatenate
Load 'User' as Role,
NTNAME as OSUser
Resident Sec;
Join
LOAD Role,
Dashboard as SH01,
Analysis as SH07,
Geo as SH02,
Outliers as SH10,
Insights as SH11
FROM
UserSheetAccess.xls
(biff, embedded labels, table is SheetAccess$);
Please help, any suggestion or workaround is greatly appreciated.
Thanks,
DD