
Infor BI–Office Plus: Create a Database Alias
Articles, NewsThis is a simple way to create a database alias.
Create your Alias:
Log on with Options
Select the Repository
On the Database Structure Pane - Click New Database Alias button
Fill in information:
Your…

Infor BI–Office Plus – Ad-hoc Report: 2 Simple Ways to Create Ad-Hoc Reports
Articles, NewsHere are 2 simple ways to create ad-hoc reports:
Once you have your Alias create
Click New Ad-hoc Report on the Office Plus section of the Ribbon
or
Double click the cube in the left side pane
Note: Each new ad-hoc…

Infor BI–Office Plus – Ad-hoc Report: How to Change Dimensions
Articles, NewsHow to Change Dimensions
Drag and drop your Dimension (column header) to the Dimension in the grid, the dimension will be switched.
Right click on the data for more formatting options:
Limit/filter…

Infor BI – Office Plus – Ad-hoc Report: Adding Charts to Ad-hoc Report
Articles, NewsAn easy guide on how to add charts to Ad-hoc Reports
Click Presentation
Chart and Table – puts a chart above the table
Table and Chart – puts chart below table
Change Chart Type. Done!

Infor BI – Office Plus – Ad-hoc Report: Adding Notes to Cells
Articles, NewsHow to add notes to cells
Make sure “Show cell notes” is enabled
Double click the cell you want to add your note
And you're done!

Submitting ACA (Affordable Care Act) to IRS
Articles, NewsOnce you have done all your Infor work to create your files for submitting to IRS, the steps below will help you get your file submitted successfully. The final files are generated when you run the BN299.
Download the schema package from…

How to delete a Lawson Users jobs more efficiently
Articles, NewsYou may be used to deleting users jobs through jobdef.
This works, though you must select each job individually and press delete. So it’s not very efficient.
A better way do to this is jobinq
In lid >> jobinq <DOMAIN\UserName>
This…

OT Pay Rate displaying incorrectly
Articles, NewsAfter upgrading to Infor 10 with Employee Self Service, when users view their Printable Pay Stub the Overtime Rate was displaying Regular Rate (see screen print #2).
Screen Print #2
To resolve this issue:
in emss_config.xml change…

How To Create new DataSource for LBI in Websphere
Articles, NewsLogin and get to the main menu of websphere
Then go to Resources >> JDBC >> Data sources:
Select New to create a new DataSource:
Type in the name of your DataSource and your database name as so (place the jndi\ in…

PR160 ACH Output Format
Articles, NewsIf you upload the ACH file generated by PR160 to your bank, chances are you will need to fix the formatting after your upgrade to version 10. Some banks require the 94-character fixed width format, rather than the sequential format that is the…
