How to load bursting rights into Lawson Business Intelligence

, ,

So, you have a list of users with several LBI bursting rights. Manually doing this is common but prone to mistakes while also timely.  This is where loading a file into LBI is more efficient.

 

  1. First let’s build a template file in excel (this can be used over and over again in the future).
    1. You’ll need to know how structures are setup in your LBI system since this will vary
  2. In this example we have an ACCOUNTING UNIT structure that is equal to a number value, ours is 4 digits.
  3. I will explain each column in order of your template file

    1. Action mode, A for Add, C for change, D for delete.
    2. Username
    3. Username
    4. Structure Name (ACOUNTING UNIT in our example)
    5. Structure Sub-name (ACCOUNTING UNIT under Group1 in our example)
    6. Condition (equal to, greater than etc.)
    7. Assigned value to structure
    8. Used to create a 2nd column after column G
    9. Represents element group (multiple would create sub groups within same structure)
    10. Represents multiple element fields within a structure group (see below example)
    11. Owner – typically Lawson or another admin user
    12. Start Date (how far back could the user access older reports)
    13. End Date (how far in the future could user access new reports)
  4. Now once you create your load file, go into LBI Reporting Services Administration and go to Import Rights
  5. Browse and select your CSV template file
  6. Click Validate Only to see any returned errors
  7. If contents are valid, add file again and this time click the Validate and Load button

Go to maintain rights and validate your user was loaded with proper data. Good luck!

 

Many organizations opt to engage Lawson consultant teams for managing their Lawson Business Intelligence (LBI) system. These consultant teams offer managed services at a fixed monthly rate and possess extensive knowledge and expertise in managing LBI. This service is particularly suitable for larger organizations, but smaller organizations that do not require a full-time Lawson employee on-site may also find it beneficial. Nogalis provides this service, and you can contact us via our contact page for further information.