PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 3/3/2006 9:09 PM by  John Henley
Drill modification possible?
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Greg Moeller
Private
Private
Veteran Member
(4132 points)
Veteran Member
Posts:1474


Send Message:

--
3/1/2006 8:31 PM
    We are working on setting up Lawson's Manager Self-Service and would like to
    remove access to some of the drill options that are available in the "Direct Reports"
    drill window (ie. Tax Information, Benefit Criteria, etc). I know that I can
    remove these drill options by removing access to the appropriate database tables
    via the "laua" utility. Are these drill options defined in a .htm or .js file in the
    portal environment? If so, can this file be editted to remove access for the drill
    options that we feel the managers/supervisors do not need to have access to?
    John Henley
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    3/1/2006 8:53 PM
    Drill panels are defined in the .or file for each system code as part of the way the Environment is architected, They are not specified separately in .htm/.js files in Portal. To remove them, you would need to remove access to the underlying database tables, as you specified. Which means that--if they are removed--you need to give the user TWO userids--one to use as a manager so they can't see their employee's personal data, and the second to use as an employee, so that they CAN their own data. I can't verify it, but my understanding is that individual drill panels are securable in the 8.1/9.0 security setup, as well as the long-awaited ability to use a single userid properly for employee and manager.
    Thanks for using the LawsonGuru.com forums!
    John
    Greg Moeller
    Private
    Private
    Veteran Member
    (4132 points)
    Veteran Member
    Posts:1474


    Send Message:

    --
    3/1/2006 8:58 PM
    Thanks, John. Not exactly what we wanted... but at least it is what we expected.
    Phillip Feller
    Private
    Private
    Basic Member
    (36 points)
    Basic Member
    Posts:12


    Send Message:

    --
    3/3/2006 6:14 AM
    There is another option for removing the MSS drill options, although it requires a fair amount of modification. You could define database views that duplicate the underlying tables, define them in dbdef, and dbreorg as views. You can now create new key numbers and rules, and modify the IDA calls so that they use the new key numbers. This allows you to remove drill around access for the new rules, without affecting the originals.
    John Henley
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    3/3/2006 9:09 PM
    Thanks Phil. Just keep in mind that technically this would be a modification to the .or files, which will get overwritten by MSPs, etc. So, depending on your customization policies, and resources, etc. could a bit of a maintenance issue.
    Thanks for using the LawsonGuru.com forums!
    John
    You are not authorized to post a reply.