Sr. ERP Support Analyst will ensure applications and systems are running at peak performance. Will troubleshoot and resolve issues, perform upgrades, maintenance and enhancements. Lead implementations and projects, monitoring, patch management, etc. This is a permanent, full time position with an EXCELLENT global manufacturer in Virginia in the US. Must be a US citizen due to ITAR regulations. Will pay for relocation for those meeting all requirements, if selected. Offers competitive pay, outstanding benefits, and stable growing future.
Hello all - Wanted to share our latest blog post about Infor ERP Enterprise http://www.i-app.com/blog.html and ask a question of the group. How important is the availability of experienced Infor ERP LN and Baan consultants for your decision to upgrade to Infor10?
Online dashboards are frequent user queries / reports with set of all inter-related questions capable of being answered by the dashboard under user control (and not the user under control of dashboard).
Online Multi-dimensional modeling, online slicing & dicing ,charting & graphical analysis (thermostat, speedometer ,charts etc ) , drill-down to details for exceptional item etc are some of the essential features of dashboards.
Here is a sample of an excel based dashboard which gives online trial balance in multi-dimensional format with possibility to drill down to details from any database through ADODB.
Here are the links one can use to study , understand ,develop and use XL based dashboards.
Yet another application to get integrated with MS Excel . Worth noting the importance of integration with MS Excel.
There is plethora of excel integrators. So while choosing excel integrator one must consider which provider/solution / download boosts the analytical capabilities of Excel (which is the core functionality of excel) and encourages free-form exchange and usage of excel . The ones which merely copies existing report in same format in excel may be useful but certainly not useful from analytical point of view . While getting excel integration , boosting the analytical capabilities and freedom of data exchange and usage must be central and focal point (just the way Sage 200 has also done ) . Further ability to use 100 mil rows in new excel 2010 also may be a consideration .
It may be worth noting "Lack of Integration to Microsoft Excel is one of the major reasons why Sage 50 customers upgrading to Sage 200" .
While working on analysis services found certain good Excel add-ins available freely. Though some of the add-ins are not useful to us as we already have long established smart programs to accomplish much more than these add-ins do , I indicate the same here for those who may wish to use such approach for their excel integration with their database ( whatever it be ).
Here is a blog on a reporting strategy for baan complemented with Excel load clients. This blog discusses various approaches to reporting in Excel and ingredients of successful Excel assisted baan reporting.
WHO SHOULD READ THIS
One should read this blog if:
one is very much comfortable with existing authorizations and semantic layer in Baan (Read baan data dictionary ) technically ( table/domain /field codes ) and functionally (descriptions ) and
one wishes to capitalize on existing learning and knowledge of existing semantic layer in Baan (technically as well as functionally ) and do not wish to invest (or waste??) in learning / migrating /adopting / translating / maintaining new semantic layer for reporting
one is very much adept at using Baan reporting and programming for routine documents and
one’s users enjoy the freedom, flexibility and functionality of spreadsheets (which may be freeware also) for analytical purposes.
there are sufficient Office licenses already with company on PCs with high CPU and memory ( far exceeding basic Excel requirements and which have become norm rather than exceptions ) in one’s place and there is high need to optimally utilize these resources and to reduce the load on servers .
WHO SHOULD NOT READ THIS
One whose objectives are different OR who don’t have any objectives only OR who is extremely satisfied with their current reporting already.
Spreadsheets are great number-crunching analytical tools. Knowing it’s analytical capabilities and generating MIS speedily with such spreadsheets, is very critical to success of any manager. And it’s successful usage ensures insights unlimited, ingenuity guaranteed and intelligence free from any shackles. And this in turn leads to lean and mean system architecture least recurring costs while maximizing gains.
Here is a blog to sharpen one's MS Excel analytical skills of Baan and ERPJewels users with lots of training material for MS Excel. Though most training material is specific to Office 2007, it can be useful for earlier (or even later) versions for most compatible features and functions. One can download this MS Excel training resources from this link. The zip file contains following documents.