Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson M3 Business Performance Warehouse
Lawson BPW Base Analytics Installation
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Mark
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5192
People Online:
Visitors:
370
Members:
0
Total:
370
Online Now:
New Topics
Lawson S3 HR/Payroll/Benefits
Canada Tax Calculation (Federal and Provincial) Issue
10/23/2024 5:00 AM
Initially, we had problem with CPP2 calculation is
Lawson S3 HR/Payroll/Benefits
CA Section 125 401k Plan
10/22/2024 10:13 PM
Does anyone have any recommendations on how to fac
S3 Systems Administration
Running AC120 deleted records from ACMASTER table
10/22/2024 3:40 PM
We recently ran the AC120 as normal and somehow it
Lawson S3 Procurement
RQ13 Approval Info
10/17/2024 2:12 PM
When a Requisition is approved on RQ13, what table
S3 Customization/Development
Read and Write CSV file COBOL
10/9/2024 2:53 PM
Does anyone have a quik example of a program that
Infor CloudSuite
Infor OS/Cloudsuite SCIM groups
10/4/2024 2:06 PM
We are in the process of moving to the Cloudsuite
Lawson Landmark
Spreadsheet Designer Error "Unknown state selection"
9/20/2024 3:19 PM
I am looking for assistance, I am trying to upload
Lawson S3 Procurement
Adding Std Comments to all PO's
9/17/2024 7:06 PM
Does anyone know of a way to get trailing comments
Lawson S3 Procurement
Missing po info
9/4/2024 3:34 PM
We are experiencing an issue where freight account
Lawson S3 Procurement
We need to charge multiple items to 1 dept no mattter who orders the items. Our POs are out of company 1000 and cost centers are set up in company 1300. Does anyone else have this issue and have a way around it?
8/16/2024 1:55 PM
We have 3 items that need to be charged to the lab
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1366
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Lawson M3 Business Performance Warehouse
Lawson BPW Base Analytics Installation
Please
login
to post a reply.
1 Replies
1
Subscribed to this topic
4 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Greg Jungels
New Member
Posts: 1
6/7/2012 6:35 PM
I'm implementing Lawson's BPW and LBI Solutions. I have installed the software, and installed the BMM for the Base Analytics(9.0.4.1 I believe). We are using M3 BE 13.1. When I installed the BMM, it added a new 'table' in the Data Sources: LBI1. We followed the instructions to created the dataset in M3. When we try to compile the new object in BPW, it gives us an error that the table BPW_Staging.dbo.O123456 does not exist. There is a LBI1 table in the Staging database. Incidentally, the table we have for the dataset is not O123456, but O001098. I changed it in the categorization in BPW, and now I get an error saying BPW_Staging.dbo.O001098 does not exist. Obviously, when we setup the BPW repository, it created the LBI1 table in the BPW_Staging database. What more do I have to do to get this LBI1 object to compile in BPW?
Thanks in advance for your help.
Will
Veteran Member
Posts: 39
7/24/2012 6:26 AM
Hi Greg,
For an out-of-the-box install, you will need to look under the LBI1 (O123456) object under the Data Sources tab of BPW. You would need to drill down under your data source (M3 BE 13.1) and then the database where your M3 tables are located (e.g.: M3EDBTST).
Then you would need to uncompile LBI1, edit its properties, go to Compilation and Categorization, and put yout sales/budget table name (O001098) under Table/View Name in database.
Compile LBI1 and execute it, you should now have data and BPW should create that dbo.O001098 table that you are lacking.
Drop me a note at hi@lbinote.com if this does not help!
Thanks and happy data warehousing!
Please
login
to post a reply.