Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5121
People Online:
Visitors:
288
Members:
0
Total:
288
Online Now:
New Topics
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1354
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
Performance Management
Forum:
Lawson Business Intelligence/Reporting/Crystal
Search this forum:
136 Subscribed to this forum
Page 30 of 34
<<
<
28
29
30
31
32
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
LBI 9 Reporting Issue
Started by
Deleted User
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
6
4233
1
by
Matthew Nye
1/22/2009 3:07 PM
Row Level Security in Crystal Reports
Started by
MSS
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. &160; &160; &160; &160; &160; &160; &160;
3
4256
0
by
John Henley
1/15/2009 3:29 PM
Load Balancing RAS
Started by
jellis
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.
2
4346
0
by
jellis
1/13/2009 11:52 PM
Links
Started by
A_R_Consltnt
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.
2
4023
0
by
A_R_Consltnt
1/12/2009 5:54 PM
Inital LBI Implementation Questions
Started by
Deleted User
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...
18
13964
3
by
John Henley
1/12/2009 12:26 AM
Reporting, Part 7: Categorizing Reports
Started by
John Henley
<p>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 sat...
0
3540
0
1/10/2009 5:02 PM
Data Dictionary
Started by
Greg Moeller
Was it in this forum where I had found a data dictionary for the LBI tables&160; All 3 schemas. Even some documentation on field names, uses, etc would be good. &160; I know I found one somewhere once, but I cannot remember where it was.&160; If it was here, could I request it be sent again
4
12218
2
by
Greg Moeller
12/15/2008 5:25 PM
Allow Multiple values for a parameter
Started by
Joshua Adams
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
3
4126
1
by
John Henley
12/12/2008 5:13 PM
Repoint Crystal(Using Lawson OLE-DB)
Started by
Deleted User
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&160; We are using Crystal 10.
2
3983
2
by
Deleted User
12/3/2008 10:03 AM
Search inside crystal reports...
Started by
Shane Jones
Anyone know Hopw I can select about 1000 cyrstal reports and search all of them for a string in the 'Selects', 'formulas',&160;'section experts', etc.... I&160;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&160;&160;
2
4621
2
by
Will
11/28/2008 9:58 PM
Is Lawson-Analytics Architect supports Essbase ASO applications?
Started by
Gangadhar
Hi there, Is it possible to load outline and data from Lawson GL program (IA120)&160;into Essbase ASO application Thank you for your replies in advance!
0
3698
0
11/12/2008 4:14 PM
How to change Essbase Application type in Lawson program
Started by
Gangadhar
Hi, I am new to this forum and Lawson. We are buliding Essbase outline and data load using Lawson IA120.&160; 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 appreciate...
0
3743
0
11/12/2008 1:55 PM
How do I hide the Tools dashboards from users?
Started by
mmanosca
Can anyone shed some light on how&160;to hide the Tools dashboard from users&160; The tab is visible but when they click on it it&160;gives&160;them an access denied error. Thanks, Mike
2
3592
1
by
mmanosca
11/7/2008 7:46 PM
Linking to a RS Crystal report from a Smart Notification
Started by
Nick
Has anyone been able to pass a parameter from a Smart Notification to a Crystal report in LBI&160; We would like to be able to populate the report's parameter (Employee ) from a related link in a SN.&160; Thanks!
0
4094
1
11/5/2008 4:01 PM
DME Syntax
Started by
Petter
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...
2
6803
2
by
jeremy.zerr
10/23/2008 4:58 PM
Use Perl to query DME via HTTP
Started by
jeremy.zerr
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.&160; Sometimes, 65536 data records is a limitation of Excel that elimina...
4
7082
1
by
jeremy.zerr
10/23/2008 4:32 PM
Crystal report links error?
Started by
Milo Tsukroff
Can anyone help out here, or, have you seen this before&160; Our reporting department has again found problems with our Crystal Reports reports.&160; These reports are developed for LBI.&160; They suddenly find that all of the reports they check on have links that seem to have 'gone wild'.&160; Even worse, sometimes they see a field ('BUDGET_NBR') in&160;one of our two&160;custom views just disappear, or, the field shows up in the other&160;view which doesn't have that field in the first...
2
4231
0
by
Milo Tsukroff
10/10/2008 7:49 PM
Creating a Crystl Report against an ldap export ldif file
Started by
Kate Liamero
We have to do an audit on our Lawson Users.&160; I have an ldap export in an ldif file.&160; I then imported that in excel and wanted to create a crystal report against it.&160; My problem is the lawson security fields for Groups and roles.&160; They are multivalued fields/ arrays.&160; I want to be able to list the user and then in one column extract the list of&160; the users groups and in another column list their roles. This can probably be done right in the excel file also but I have ...
3
5096
1
by
k-rock
10/7/2008 8:19 AM
Connecting to a RW report
Started by
stcyrk
I keep receiving an unknown error when trying to connect to a report.&160; 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 &91Database Vendor Code:62&93 Anyone encounter this
3
4414
0
by
John Henley
9/15/2008 1:39 PM
LBI and SQL 2005?
Started by
Roger French
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.
1
3846
0
by
Matthew Nye
9/8/2008 5:05 PM
Adjust Alert Light Bulb Color
Started by
kflores01
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...
6
4453
1
by
kflores01
9/4/2008 10:52 AM
Tying activities data in ACTRANS to ARDISTRIB
Started by
Deleted User
Hello All, I need help with tying a given activity transaction (table ACTRANS) to it's supporting details within table ARDISTRIB.&160;&160; 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.&160;&160;&160; I can see this bre...
5
5256
1
by
Deleted User
9/3/2008 7:16 PM
Compiled Reports in CRX?
Started by
Phil Simon
Hello I am running CRX and we use Control M to schedule reports.&160; 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.&160; Evidently, this has changed.&160; 'To create a Compile Report within Crystal, go into Crystal Reports and open a report,&160; from the menu select REPORT | COMPILED REPORT.&160; The Compile Report dialog box will be disp...
10
6233
1
by
John Henley
8/30/2008 2:55 PM
Viewing Scheduled Rpts in LRS
Started by
Phil Simon
Hello.&160; We are running LRS v1 and I have a pretty basic question.&160; I know that LBI has more to offer than LRS but perhaps I am missing something.&160; 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&160; It doesn't appear as if you can publish the report to a dashboard and then have the end-user simply view the instance.&160; Is this by design&160; Version 1.2 &160; Document...
1
3502
1
by
Chris Martin
8/18/2008 3:00 PM
Lawson Support for Essbase
Started by
wkeller
Does anyone have information related to Lawson's&160;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.&160; If so, has an announcement been made&160;concerning the date Essbase support would&160;be discontinued
3
6368
1
by
k-rock
8/11/2008 2:51 PM
To join the discussion you need to
register
first. (Registration is free!) If you are already a registered user please
login
to join the discussion.
Page 30 of 34
<<
<
28
29
30
31
32
>
>>
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
----S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
----Lawson Design Studio
--Lawson Smart Office
----Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft O...
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PS...
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operat...
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/R...
----Smart Notification
--Lawson M3 Business Performance...
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support
Forums
Performance Management
Group: Performance Management
Forums
Topics
Replies
Subscribers
Last Post
Smart Notification
189
635
71
RE: SQL Help
by
Greg Moeller
11/9/2023 2:49 PM