Using Lawson Security, not LAUA. Have roles that restrict access to certain tables. When using DME data source in InfoSet I can't use a user authentuication that is CHECK LS=Y. How do I enforce security so that users using this data source are restricted to only the tables they should get to - without having to replicate all of that in LAUA

I was wondering if anyone had used LSN to pull information from a SQL database outside of Lawson We are looking at creating some notifications when changes occur in our Time and Attendance system, and I have everything ready on that side. I'm unsure about how to set up the JDBC data source in LSN though. Is it possible to do Thanks! Nick

We use smartnotes as a push only tool. I create notifications and push them out to management and Human Resources. I am always being asked if they can get the information in a spreadsheet. I know that in the options link at the bottom of all the notifications is an options link which should allow them to expot the note to a spreadsheet. Why am I the only one that this option works for. Every other user has the Options link grey and will not work. Could it have something to do with them not being...

I need to send a smart note out and have the from address be different then our standard notes. All notes come from LBIdomain.com. Is there a way to override this so that one specific notification can come from a different email address for example johndomain.com I know you can use device to control who things are sent to but don't seem to see a way to override the sending address, I know I can change the reply to address but will not work for this notification.

We are using some of the Lawson-provided Smart Notes and InfoSets. However, to keep track of the few we are using, we are creating copies in our own 'PeaceHealth' namespace. Creating the solution pack to port Supply Chain to Production was simple because they were the first (and only) Smart Notes and InfoSets in the namespace. However, now that there are copies of the Finanacial Smart Notes and InfoSets in the same namespace, I would like to create a solution pack to move just those four Smart N...

In test, at the bottom of the smart note display are two links to export the data as CSV or XLS. In production, those links are missing and a different section (with 'Related Links and Options' and 'General Information') is displayed. Within the Smart Notification - Content Administration Tools I can preview the two templates (Default is embedded into Master) and they show the CSV/HTML links. But when I preview the smart note it shows the 'Related Links' (etc) section. Does anyone have an idea ...

I am trying to create a crystal report based on the LBI database that lists the names of all Smart Notifications along with owner and date created.  Can anyone tell me what table I should use  Thanks in advance!

We just completed our upgrade from LBI 9031 to LBI 904. After the upgrade I am testing my application links from the emails generated by smart notes.   For some reason these links are not working. It is not recognizing the LBI service even when the service is present. Anybody come across this tia, Ruma.

Newbie question - Does anyone know how to link to a crystal report from a smartnotification

Hello, Hope you can help. I'm looking ot build a bursting notifcation that bursts to the user who rasied a zero value purchase order in M3. As our M3 username matches the windows log-on name in active directory, is there a way i can link smartnotes to AD to read the username in the infoset, then read the user name and e-mail address in AD. One solution i have is to export the AD user name and e-mails into a database, and create an infoset over that one, then create the brusting notification ...

I need to take annual contributions and divide them by 24 to include in my Notification. Is there a way to do this in the InfoSet or in the Notification

Could someone help me out with this report

Does anyone know of a complete listing of the various charting parameters and options for charts in SN  I have looked in the Smart Notification User and Admin Guide (Appendix B), and searched the Lawson KB, but I haven't been able to find a comprehensive list. Specifically, I am having trouble finding a way to show the labels for all of the x-axis vales on a horizontal chart. Even some of the seemingly standard options (such as colopt=, which I have finally figured out is what columns to...

I have an infoset which queries the lawson DB and returns pedning time records from the PRPENDTIME table as well as the employees email address. We then have a smartnote that sends a not the employee when the time has bee approved. The note is snet out based on the condition of having new items and the email address comes from one of the columns in the infoset. Is there a way I can send to the email adress from the infoset without including the email address in the data in the smart note Curren...

I am unable to change the Template for a Smart Notes.  I've imported my standard set of templates but when I go into Notification 4 to change the Template  for a Dashboard Template and preview, nothing changes.  No matter what template or option I select it will not change from the default Template.  I had this problem a few years ago but forgot how I resolved.  I looked at knowledge base but could not find anything.

We upgraded last night our LBI server to 9.032. Once completed, I was running through validation and my infosets will not update. I am getting an invalid query message. When I take my selection criteria out to limit the records in the query I can see the results in preview. Does anyone know of syntax changes that would cause this to happen between versions

Hi, I am trying to create a smart note with infoset that has the user e-mail id on it, but I need to burst the smart note on dashboard also, so I need to quuery LDAP (ADAM), to get the user id. Lawson Security has the e-mail id along with user id on it. How do I query LDAP via smart notes so that I can schedule it to update and also get the user id. Thanks in Advance, Raj.

I'm attempting to build a SN that will return vendor information (Vendor Number, Name, Tax_ID, etc) for vendors who have duplicate tax IDs in the APVENMAST table. I have the following JDBC connection Infoset created that returns the Tax_IDs that exist in the APVENMAST more than one time, but I cannot figure out how to pull the Vendor Number, Vendor Name, etc in the same JDBC connection..  Any ideas/suggestions SELECT APVENMAST.TAX_ID, Count(APVENMAST.TAX_ID) AS CountOfTAX_ID FROM APVENMAST ...

I am trying to create a smart notification to notify users when a buyers message clears up in lawson. Has anybody created this already Can you tell me which tables and field is updated when procurement clears up a buyer's message. Thanks in advance, Ruma.

Current version of LBI is 9.0.2.2.127 (FWS, RS, SN).   We restart Tomcat each morning at 4:00 am, at  6:00am  we have a Smart Notes emailed via the scheduler.   The Smart Notes that is emailed contain links that drills into other Smart Notes. What should happen is the user receives an email they click on the Department Name, sign on to LBI and the second filtered Smart Notes opens.    Since we reboot Tomcat each morning, the Smart Notes are emailed out, but the links do not work. Lawson GS...

We are attempting to create Smart Notes using Hyperion Essbase.  SN version 9.0.2.2.127 Hyperion Essbase 7.1.3.0 Build2.  Our Lawson and LBI are both hosted by Siemens.  When I go and set up the information in SN InfoSet,  I get a message that the Database can not be found.  Does anyone have a SN using Hyperion Essbase working  If so, any suggestion

I have an issue that I hope someone can shed some light on... We have a handful of dashboards active now, mostly for upper management.  The next step is to create something for the Sales reps.  Ideally, I would like to create a single 'Sales Rep' dashboard that all Sales reps could access.  The dilemma is securing that dashboard so they only see their information.  I know that I could use DME for Lawson data, but much of the data I need to display is from an ETL process that gets data from our ...

Hi, I am looking a way of triggering a java program during LSN delivering a notification. Do you think it is possible I am trying to setup XML via HTTP type of device, however, I do not have enough info to get it working. Any suggestions thanks. Chiahao

We have a smart note notification that we would like to dump out onto the web.  I can see in Smart Notes where you can select a output of html file.  However how would you tell it what the name and directory where you would like the file placed  Is it even possible to do this Thanks --JayR

I know in Reporting Services you can import a csv file to load multiple emails at once. However, I am unable to find any documentation on how to do this in smart notifications. I'd like to be able to send basic smart notifications to all users, but presently, we only have a handful of devices added in Smart Notes. Is anyone aware of a method of adding email devices into smart notifications other than individually Or, can I somehow use those devices that are available within Reporting Services s...