Forums
Lawson S3 Financials
Essbase 11
Author
Messages
brooke
Posts: 21
10/15/2013 4:31 PM
We are on 9.0.1.10 and upgrading essbase to 11 - has anyone able to get the lawson api to work with 11 for the IA120 to still work?
Vicki
Basic Member
Posts: 10
10/15/2013 5:24 PM
We did not. Our initial reason for upgrading to Essbase 11 was that the Addins would not work when we upgraded MS Office Excel. Then we found that the minimum version of Essbase supported by Oracle was a later version than the Essbase version supported by the Lawson Essbase API. We ended up using the output of IA120 and creating an ftp to the Essbase server and using MXL code to do the load into Essbase.
brooke
Posts: 21
10/15/2013 5:28 PM
Were you able to create the same datamart? Was it seemless for your end users?
Vicki
Basic Member
Posts: 10
10/15/2013 5:56 PM
Yes. But we used contractors, so I don't know if they were able to upgrade the existing cubes or had to rebuild them.
Terry Wier
Basic Member
Posts: 13
10/16/2013 1:58 PM
Hello, Terry Wier from Dashboard Gear here.
Essbase users might want to know Dashboard Gear offers a fully supported reporting alternative.
In addition to a comprehensive set of pre-joined relational tables for detailed Crystal/SSRS type production reporting our solution includes pre-built OLAP cubes for:
• HR
• PR
• PR Distributions
• BN
• Position Control
• Personnel Actions
• GL Amounts/Budgets
• GL Distributions
• AC Amounts
• AP Vendors/Invoices
• AP Distributions
• Requisitions
• Purchase Orders
• Inventory
• Material Management Distributions
Most of our customers use Excel pivot tables with our cubes.
Terry
Vicki
Basic Member
Posts: 10
10/16/2013 2:22 PM
I would recommend looking into Dashboard Gear. Essbase 11 is much more difficult to support from an IT perspective and the business is having difficulty with the new admin console. I wish we had looked into it before upgrading.
Kwane McNeal
Veteran Member
Posts: 479
10/16/2013 3:03 PM
I'll second that recommendation...
I have worked a few clients who have it, all were pleased and actually relied on it.
Kwane
brooke
Posts: 21
11/25/2013 3:26 PM
I did get Essbase 11.1.2.3 to work with Lawson 9.0.1.10. What I am concerned about now is what happens when it stops working - I know that day is coming! The issue we have is our end users are used to controlling the data refresh using the IA120. Our consultant said the only way the end users can update data is to give them EAS access??
brooke
Posts: 21
4/12/2016 7:22 PM
Vicki
Which consulting company did you use?
thanks!
brooke