We are currently an 803.7 Env shop with e-broadcasting and Report Designer reports. We plan on implementing LBI prior to going to LSF9. Our initial scope is to move the Report Designer reports over to Crystal and publish in LBI along with copying over our broadcasting functionality. We have an Oracle database and will be implementing with SQL Server as the Mid Tier database and Websphere. I have a couple of questions... 1) How long has it taken to implement LBI so that you are up to pre-L...

I haven't really found much information out there about how to use perl to access Lawson data through the DME's, so I figured I would share with you what I know. Sometimes, reporting calls for more powerful measures than excel can handle through the Office Add-ins, and well, I know that a scripting language like perl is more than capable through my years of prior experience doing data analysis for a semiconductor company.  Sometimes, 65536 data records is a limitation of Excel that eliminates i...

Hello I am running CRX and we use Control M to schedule reports.  According to the company's website, you can create a .EXE and run it on the Windows Command prompt. The problem is (as you will see below), there's no REPORT, COMPILED REPORT functionality in CRX.  Evidently, this has changed.  'To create a Compile Report within Crystal, go into Crystal Reports and open a report,  from the menu select REPORT | COMPILED REPORT.  The Compile Report dialog box will be displayed.  You have the opti...

Does anyone have information related to Lawson's on-going support plan for Essbase We are in the midst of upgrading to Lawson 9.0 and Essbase 7.1. as well as evaluating our company's overall BI strategy. Our IT staff has heard rumors to the effect that Lawson's Essbase strategy is to offer support for one more version of Essbase then discontinue their support in favor of LBI.  If so, has an announcement been made concerning the date Essbase support would be discontinued

Hello, I am a Lawson query user. When I set values for indexes, I cannot 'skip' a line in the index set. For example, I want to list all open invoices so I go to AROITEMS and use AROSET13 with my company code, process level and for a specific transaction type (invoices). However, I want to do it for all customers, I don't want to choose a customer number. If I leave customer blank, it will not filter for process level and transaction type. So I need something like a ' * ' so I get all customers...

Hello.  We are running LRS v1 and I have a pretty basic question.  I know that LBI has more to offer than LRS but perhaps I am missing something.  Is the only way in LRS to view a previously scheduled report as follows: give user access to Tools (as an admin) and then have them view the instance  It doesn't appear as if you can publish the report to a dashboard and then have the end-user simply view the instance.  Is this by design  Version 1.2   Document Number REPUG-12W-01     Rep...

Hello All, I need help with tying a given activity transaction (table ACTRANS) to it's supporting details within table ARDISTRIB.   As the company I'm working with currently has little activity and just started a new fiscal year, my matching process currently uses a SUM query in SQL to add up the amounts on any given date and then matches by transaction date and the total from the SUM query matching the 'summarized transaction' amount from ACTRANS.    I can see this breaking the moment there is...

In Lawson's Framework Services User and Administration guide (page 15) there is a display of a dashboard with alerts on the left hand side. Two of the alerts are red and one yellow. With the obvious intent, that the red alerts need immediate review. Similarly, I am interested in changing the color of a bulb from a default neutral (status_n_bulb.gif in the Status Icon field) to either green or red should the results from an alert are greater or less than particular thresholds within the alerts. T...

Trying to see if LBI (9.0.1.9) is compatible/certified with SQL2005. The install manuals only say SQL 2000. Just wanted to make sure of any gotchas if using SQL 2005 with LSF9.

I keep receiving an unknown error when trying to connect to a report.  I have verified the path in the query builder matches the path to the report on law\app. The error code is ADO Error: 0x80004005 Native Error: 62 [Database Vendor Code:62] Anyone encounter this

Can anyone help out here, or, have you seen this before  Our reporting department has again found problems with our Crystal Reports reports.  These reports are developed for LBI.  They suddenly find that all of the reports they check on have links that seem to have 'gone wild'.  Even worse, sometimes they see a field ('BUDGET_NBR') in one of our two custom views just disappear, or, the field shows up in the other view which doesn't have that field in the first place.  The reports are wrong in s...

Is there a way to repoint a Lawson OLE-DB link in Crystal from one Lawson server to another without have to redo the fields in the report  We are using Crystal 10.

We have to do an audit on our Lawson Users.  I have an ldap export in an ldif file.  I then imported that in excel and wanted to create a crystal report against it.  My problem is the lawson security fields for Groups and roles.  They are multivalued fields/ arrays.  I want to be able to list the user and then in one column extract the list of  the users groups and in another column list their roles. This can probably be done right in the excel file also but I have no idea how to do this there e...

Has anyone been able to pass a parameter from a Smart Notification to a Crystal report in LBI  We would like to be able to populate the report's parameter (Employee ) from a related link in a SN.  Thanks!

Can anyone shed some light on how to hide the Tools dashboard from users  The tab is visible but when they click on it it gives them an access denied error. Thanks, Mike

Hi, I am new to this forum and Lawson. We are buliding Essbase outline and data load using Lawson IA120.  Now we have changed the application Essbase application type to ASO. But we CANNOT build outline or data load to ASO application thru IA120. I am trying to see if there is any option to change Essbase application type within IA120 or IA10. throwing this below error while loading to ASO app: 'No message for 1056504 in message database' Any idea or help would be appreciated. ...

Hi there, Is it possible to load outline and data from Lawson GL program (IA120) into Essbase ASO application Thank you for your replies in advance!

Anyone know Hopw I can select about 1000 cyrstal reports and search all of them for a string in the 'Selects', 'formulas', 'section experts', etc.... I just don't wee how we are going to be able to open EVERY report to find a Plan code that is being changed. Any thoughts

Hello, Can someone please help as to what is the best way to link the GLTrans and FBDetail table to get resonable and correct rows The purpose is to create a report in crystal with budget and actual numbers. Thanks in advance. A.

How do you go about allowing the user to enter multiple values in a parameter After publishing a Crystal Report to LBI a parameter that is set to 'Allow Multiple Values' is rendered as a single text box. Is there a seperator that must be used between the multiple values If so what is this seperator

Was it in this forum where I had found a data dictionary for the LBI tables  All 3 schemas. Even some documentation on field names, uses, etc would be good.   I know I found one somewhere once, but I cannot remember where it was.  If it was here, could I request it be sent again

Hi, We are building a new infrastructure that will have multiple RAS servers. What I am curious is how some of you did the load balancing to these servers. Did you use a software or hardware solution. Thanks.

In this installment of our on-going reporting series, let's turn our attention from looking at individual reporting products solutions, and instead look at your report development project. If you're like most organizations I come across, your reporting project charter is to replace an existing reporting system-be it a formal existing system, or a simply a list of user requirements if you had no previous formal system. Regardless, you need to develop and use a process that focuses on satisfying t...

Hi, I would like to have row level security in Crystal for Lawson data in HR/PR/BN modules. What Row level security means in this context is the user has access to the data entered by him and few other users. Has anyone handled this before in Crystal Reports. Any help in this regard is appreciated. Thank you.

I created a report in development and published LBI Data Settings of a user and password we set up for all development reports. The report is in Crystal XI using a SQL Server stored procedure as the data source. This office is used to using tables as the data source. When I publish to LBI Dev the Data Settings are fine. When they publish in production, there is no user or password in the Data Settings area. How do I fix this