Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Scheduled LBI report to a constant server location

 5 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
BarbR
Veteran Member
Posts: 306
Veteran Member
9/26/2011 1:55 PM
    We would like to be able to have scheduled LBI reports go to a constant server location so that they can be picked up by a later scheduled process (a ProcessFlow). The LBI analyst tells me that when the report runs it is written to a unique folder for every date with a unique instance number. That will make it difficult for the Process Flow to FTP "get" the reports. Has anyone found a way to write the report to the same location each time?
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    9/26/2011 2:02 PM
      This is a feature of LBI that has not yet been tackled. Mark Cook was looking into ways of doing that, but I haven't heard from him in a while now, so don't know the status.
      In case you are wondering, lots of people have asked for similar functionality... and Mark was going to compile a list of what people were looking for. The top requests would get worked on.
      Matthew Nye
      Veteran Member
      Posts: 514
      Veteran Member
      9/26/2011 2:25 PM
        Other clients have used a 3rd party application that can read PDF files to determine what the file related to and then move that file to a predefined location. I also had a client use a 3rd party app that can detect email attachments. The application would intercept all those that were from the RS server and depending on the attachment and user it was being sent to, save the attachment to a network location. These are the only ways Ive seen anyone successfully do this.
        If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
        Joe O'Toole
        Veteran Member
        Posts: 314
        Veteran Member
        9/30/2011 5:58 PM
          We developed a query that reads several of the LBI SQL tables and creates a script that copies the last published instance of a given report to a "static" location where our distribution engine looks for them. I have this set to run daily and it picks up any reports published within the last 24 hours. All the information you need is in the Lawson LBI tables and it will take some effort for you to do find them and unsderstand the relationships, but it definitly can be done. A down side is Lawson data structure changes could potentially break the process down the road. We are running LBI V 9.022 but from what I hear the newer versions are still using the same table layouts.
          Massimo Emilione
          Advanced Member
          Posts: 29
          Advanced Member
          10/3/2011 1:18 PM
            There is not a way to do this directly from LBI. If you have the IT resources you can do this with 3rd party tools or create your own.

            At last year's cue we came up with a bunch of things that LBI needs (i.e. Report activity- Who ran what reports & When, LBI Security Report - Who has access to each Dashboard, Module, & Link, Who is Currently logged in, Email IT group when an error has occurred in LBI logs)

            One of my previous request was fixed in 9042, which was to allow for sizing in a module when links exist.
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
            10/7/2011 3:22 PM
              I believe that I can help with the 'Who has access to each Dashboard, Module, Link' report. I've written one for our use that I'd be willing to share.
              Caution: This was written on LBI 9.0.4.1, so not sure if it will work with other levels.

              Maybe someone could help expand this report, and make it more functional and/or fluffy.
              Attachments