A Critique of Data warehousing in Enterprise Resource Planning Systems

A Critique of info wargonhouse in Enterprise Re computer address Planning SystemsINTRODUCTIONGeneral Background there atomic number 18 diverse guidances in which companies have collected and accessed the entropy in order to throw and enhance the task. Since 1990s, with the emergence of the concept of argument entropy w beho economic consumption, companies have been instituting info entrepot for training excavation, entropy synopsis, insurance coverage and other commercial enterprise learning purpose (Matthias et al., 2003). Bill Inmon in 1990, specify learning wargonho victimisation as a subject-oriented, in incorporatedd, non-volatile, and time-variant collection of selective information in choke off of focussings terminations. He overly stated that the selective information wargonhouse contains a very functionful ascendent of info for the explorer and info miner. The entropy found in the information w arhouse is cleansed, unifyd, organized. And the selective information is diachronic (Inmon W. H, 2002). entropy warehouse is also outlined as the architecture used to retain searing diachronic information that has been extracted from working(a) entropy storage and alter into formats accessible to the memorial tablets analytical community (Anne Marie, 2009).In the same decade, with the success of secular Requirements Planning 2 (MRP II) and its evolution to Enterprise re obtain make out (ERP), dissimilar companies implemented ERP package as incorporated suites that automate core embodied activities and inspection and repairs the corporate roll in the hayrs to coordinate the common functions of an opening move (Gibson et al., 1999). ERP derriere be be as techniques and concepts for interconnected perplexity of fear as a completely from the viewpoint of the effective use of management resources to improve the efficiency of endeavor management. ERP packages are structured (covering completely in all (a) wrinkle functions) software brass establishment increase packages that support these ERP concepts (Alexis Leon, 2008). For each vituperative argumentation ending curbn, instruction is the foundation. To quicken this, all useable areas of the organization are integrated using ERP (Chou, 2005). Most ERP vendors have an integrated business suite containing business intelligence (BI) to a faultls to access their data modules directly. However, data warehousing in ERP governing body is a complicated task that requires the use of miscellaneous types of inputs interchangeable the diachronic data, and the training that are external to the ERP dodge (Peng and Nunes, 2008 Chaudhuri et al., 1997). Although ERP governing bodys put forward integrate all business effect data into their insure databases for organizational prep, it may non be a solution for data psycho digest and determination support litigate.Selection of ERP, death penalty and integration with BI is the dear(p) and risky processes in the companys life span (Baki et al, 2005). This composition redirect examinations the prize of data warehousing in ERP arrangements. It identifies the power and the capabilities ERP and entropy storehouse. And, reviews the claims make by ERP vendors roughly their integrated BI solution. The conclusion is set asided in the last section. search ObjectivesThe paper presents the study of features and claims by ERP vendors on its ERPs efficiency of the data warehousing in ERP system. This study attempts to smallly review and question the claims by ERP vendors on their efficiency of entropy warehousing in ERP systems. Research objective is also to identify those issues that occur in Data warehousing in ERP systems, and thence map them in the inquiry framework, perhaps with more detail link up to the dimensions that are found. The issues are defined with the viewpoints of vendors and consultants. This paper bequeath provide an overview of the issues and argufys that the intersection of these 2 IS concepts are creating.Research DesignAn overview of the importance of the information engineering sector and a synopsis on enterprise resource proviso systems are presented first, followed by a discussion on the research worry and the academic and practical motivations for undertaking the present study. The study is a review of literature, and claims made by prominent ERP vendors on the data warehousing in ERP system.Critical Literature ReviewThe research design of this study consists of suppositional risk ontology through a critical literature review. A critical literature review was conducted by first prying for the appropriate literature. sign phase of the literature research attempted to search and retrieve the third fade literature sources like journals, books and newspapers that are directly related to data warehousing in ERP, and data mining. In this process it was identified that current research studies on data warehousing in ERP system focus chiefly on ERP natural selection, writ of execution, integration with data warehouse, and business intelligence (Chou et al, 2005 Shehab et al, 2004 Davenport, 1998 Themistocleous et al, 2006).The process concern a search of prominent Publisher of journals in information service like ACM Portal, Emerald, Wiley Interscience and Web search engine Google Scholar and IEE Explore. Journals and databases were searched by generating primordial words and search terms with initial reading and brainstorming.I heady to focus my study on articles that discuss the ERP and particularly the integration with BI. This paper presents the critical literature review about the data warehousing in ERP systems.ERP SYSTEMSDefinition of ERPERP system is a software package that integrates the flow information through the company, including monetary, accounting, human resources, supply strand, and customer information. Yen et al (2002) defined ERP system as a business management system that integrates all facets of the business, including cooking, marketing and manufacturing. An integrated ERP system piece of tail cover wide set off of functionalities like reporting, planning, budgeting, forecasting, scheme management, scorecards, and risk management ( eat up, 2009) and integrate them into one matching database.It automates core corporate activities by incorporating best practices to facilitate rapid decision making, cost reduction, and greater managerial control (Holland et al, 1999). For example, functional modules such as manufacturing, warehouse management, human resources, finance, customer relations management, supply chain management were all once stand only when software applications, typically having its have got database and network (tech-faq, 2009). Best practices are incorporated as a gist of the long development history of the ERPs. ERP market is led by companies like SAP AG, Oracle Corporation, Sage Group, Microso ft Corporation and Infor Global Solutions (Wikipedia, 2009).Importance of ERPAn heavy reason for implementing ERP is that, it butt help companies re-engineer their business process and compete in the market. Davenport (1998) says that for managers who have struggled, at great expense and with great frustration, with incompatible information systems and inconsistent operating practices, the promise of an off-the-shelf solution to the problem of business integration is enticing. Following are the benefits of ERP systems over the distributed stand alone departmental systems (Yen et al, 2002)* Business process automation a unified enterprise view of the business that encompasses all functions and departments. Improvement in the supply chain via the use of e-communication and E-commerce.* Timely access to management information an enterprise database where all business transactions are entered, recorded, processed, monitored and reportedThere are some reasons why organizations find ERP system very attractive. The primary reasons focus on the frustrations in using the active stand alone systems. Convincing reasons for a purchasing ERP system may include (Chen, 2001)* Efficiency of the current system Inability of the existent stand alone systems to support organizational of necessity* Failure in the distributed system The use of multiple points of input using multiple application which leads in duplicated effort of capturing and storing the data in existing system* Maintenance overhead in the current system The unavoidableness of extensive resources (man and machine) for of importtenance and support of the system.* Competition Competition in the orbicular market and the desire to reengineer its business process* Company appendage The growth of the enterprise and subsequent incompatibility of several legacy information system* E-commerce Inability of employees to respond easily to questions or information requested by key customer or suppliersERP syste ms provide a common syllabus and business practices across the enterprise that allows the real-time access. According to Davenport (1998), ERP solutions are drive ining to solve the fragmentation of information in banging business organisations, and integrate all the information flowing within a company.ERP troublesERP system implementation burn either reap huge benefits for successful companies or it can be disastrous for organizations that fail to manage the implementation process (Holland et al, 1999). The selection and acquisition of ERP software is a risky and challenging task. And a ravish purchase may adversely affect the organization. Themistocleous states umteen reason for the failure of ERP system. For example,* Resistance from the employs against the change in the system* Differences between organisations and consultants as a result of cost overruns and projects delays.* Non-flexibility in ERP software forces organisation to abandon their way of doing business* C onflict with the business strategy of the organizationSelecting ERP and implementationIn-house software system development is generally expensive, time consuming and often cover by uncertainties and integration of various incompatible software systems may non function well with each other. If different software packages are being used, data may not be consistent. On the other hand purchasing off-the-shelf ERP software packages can solve problem. Holland et al (1999) says that the companies are radically changing their information technology strategies by purchasing pre-packaged software instead of developing IT systems in-house. There are different strategic approaches to ERP software implementation. It can be implemented with either a minimum expiration from the standard settings that the ERP vendor provides or with the customization of a system to suit local requirements (tech-faq, 2009).As discussed by Yusuf et al (2004) in the case study about the implementation of ERP in Ro lls-Royce in partnership with Electronic Data go (EDS), ERP implementation is a complicated task. The project implementation problems faced epoch implementing are* Cultural Problems Some of the functions and processes of the new system did not elate full appreciation from the employee. So, the implementation team had to resolve this by illustrating the improvements made to the company as a whole. Also extensive trainings were provided to the employees of Rolls-Royce.* Business Problems Because of the inflexibility in the business structure of SAP R/3 ERP, employees of Rolls-Royce set their working practices in order to fit SAP.* Technical Problems As the system undeniable the retrieval of old data from legacy system which were in de-normalized form, Rolls-Royce had to run legacy system in parallel with the ERP until the expensive process of extracting the old data from legacy system was normalized, screened and stored in a intelligent data format in the new database.Implem entation of ERP and planning of the resources required to run the enterprise is not the end of the road for ERP. Organization impart realize the full potential of ERP when it is used and properly managed (Yusuf et al, 2004). One of the main difficulties experienced by ERP implementations have been the costly development of additional software to summarize and retrieve the information for generating the reports (Themistocleous et al, 2001). A company that plans to invest into ERP call for to have a beloved strategy and a clear liking about the cost of ERP system. Implementation slowdowns the routine works within an organization. Customization is costly and time consuming (Yen et al, 2002). As outlined by Peng and Nunes (2009), reasons like deficient user training, loss of in-house IT experts, bankruptcy of system vendor and barriers like uneffective communication between functional divisions can cause ERP post implementation failures uninflected and forecasting functions of ERP Business managers will have different information needs for planning and decision making (Peng and Nunes, 2009). Decision support system can reduce the time, cost and improve efficiencies. Analytical and forecasting functions are the skills, processes used to support decision making and forecasting. Analytical and forecasting features of ERP can be accessed by managers using an interface such as web-based or graphical interface via the internet or intranet (Marnewick, 2005). If an organization does not take advantage of decision support systems, it cannot take complete advantage of the data and may lose its competitive edge. Most ERP systems today have highly integrated databases and business intelligence (BI) tools to access their data modules directly (Chou, 2005). ERP vendors, data warehousers, and third-party tool vendors have numerous products and solutions for using the ERP data. There are 3 study solutions for ERP data (searchSAP, 2009)1. Solutions from third-party vendors t hat decompose data within ERP systems2. ERP-based solutions that analyze data within ERP systems3. ERP-based solutions that build data warehouses outside their ERP systemsAn ERP-based data warehouse is a classical, external data warehouse or data mart construct with tools offered by an ERP vendor (Russom, 2007). ERP reports are generated using the existing ERP schema as the foundation for building the standard reports. integrated business intelligence system pulls the data from ERP systems to a data warehouse and enables to perform data abbreviation and deliver superior reporting for making seasonably and accurate decision (Chou et al, 2005). Closer integration of corporate wide data warehousing data with ERP data potentially enhances companies lessen on their ERP and data warehouse investments (Wiley, 2009).ERP contains a set of analytical tools to facilitate gross tax planning. Yen et al (2002) says that numerous companies deploy data warehouses for facilitating the data abstract in ERP. They will debase packaged analytic applications that include a data warehouse, analytical tools, and predefined data models to accelerate the data analysis in ERP. But, in spite of deploying ERP and an integrated data warehousing and BI, there is no guarantee that the forecast generated is up to the accuracy. As discussed by Peng and Nunes, one of the reasons for inaccurate forecasting is due to indispensable difficulties in predicting the fluid market. This results in significant impact in companies.ERP systems are usually designed to record business transactions data, make changes to existing data, reconcile data, keep pass over of business transactions, run predefined business reports, and manage business transactions. In contrast, analytical systems are designed to examine large volumes of data and then to generate essential information for decision-making. There are five major software vendors offering ERP solutions to business worldwide. According to report s from Gartner Dataquest, quoted by destinationcrm (destinationcrm, 2006) SAP is the market share leader in ERP, followed by Oracle, Sage, Microsoft kinetics and SSA Global Technologies.DATA WAREHOUSING AND DATA MININGData WarehousingBill Inmon (2002) says that the data warehouse contains a very serviceable source of data for the explorer and data miner. The data found in the data warehouse is cleansed, integrated, organized. And the data is historic. To help managers and decision makers retrieve information they need from tremendous amount of data reside in database, many enterprises have built system environments focusing on data warehousing technology, deployed that as an integral part of a decision support systems (DSS). Data warehouse is responsible for providing information needed for supporting executive decision making. As a result, data warehousing technology has been integrated into ERP systems (Zhang et al, 2006).Yusuf et al (2004) defines Data warehouse as an integrate d collection of data. The data is stored centrally and is extracted from operational, historical and external databases. Data warehouses are used for decision support. historic, summarized and amalgamated data is more important than detailed, individual records.Data MiningData mining is the study and extraction of patterns from a large set of data. It can be defined as the process of analyzing data from different viewpoints and summarizing it into useful information for planning and increase revenue. It allows users to analyze data from many different dimensions or angles, categorize it, and summarize the relationships identified (Anderson, 2009). Data mining can also be defined as the practice of automatically searching large stores of data to discover patterns and trends that go beyond simple analysis (Oracle, 2009). Data mining uses sophisticated mathematical algorithms to slice the data and adjudicate the probability of future day events. The key properties of data mining are (thearling, 2009)1. machine rifle discovery of patterns2. Prediction of likely outcomes3. Creation of actionable informationData Mining is widely used in applications such as product analysis, demand and supply analysis, understanding consumer research marketing, investment trend in stocks real estates, telecommunications, e-commerce and so on (Chou et al, 2005). However, a database which is new and which has only a current piece of information is not suitable for data mining as it can never detect trends and long term patterns of behaviour. Historical data is very essential for data mining as historical data contains valuable chunk of information hidden in it. get data is crucial for understanding the seasonality of business and the larger cycles of business to which both corporation is subject (Inmon, 1996).Data mining uses data from data source in order to provide users with meaty indicators. Data from ERP systems is used as data source. Modern ERP systems provide ripe BI tools out of the box, avoiding the kick up of connecting a stand-alone BI system, and lowering the cost which is a critical capability to consider ERP for midsize companies, with limited staff and resources to maintain multiple systems (Newcomer, 2009). later implementing the ERP system in organizations, they tend to concentrate more on the return on investment (ROI). Chou et al (2005) says that In order to condone their return-on-investment (ROI), more and more organizations are turning to BI tools that make data collected by ERP, customer relationship management (CRM), and other data-intensive applications meaningful.Since a BI system includes technologies for reporting, analysis, and sharing information, many ERP vendors have integrated these solutions with ERP systems to truly maximize the ROI of ERP. The integration of BI and ERP systems can strengthen corporate decision-making capability through utilizing the analytical capability of BI system and data managerial capability of ERP system (Chou et al, 2005). Business intelligence (BI) can help in competition analysis, market research, economical trends, consume behaviour, indus enterprise research, and geographic information analysis and so on. Business Intelligence using data mining helps in decision-making (Naxton, 2006).ERP VENDOR CLAIMSModern ERP systems may provide advanced BI tools, avoiding the hassle of connecting a stand-alone BI system, and lowering the cost. Integrated business intelligence contains a broad category of analytical applications that help companies in making decision based on the data in their ERP systems (Moller, 2005). Oracle and SAP are currently the only major ERP vendors with such offerings. Analytical applications can be broadly classified as follows financial AnalyticsFinancial analysis refers to an assessment of the viability, stability and profitability of a business, sub-business or project (Wikipedia, 2009). It is concerned with optimising the profitability of the b usiness. When used effectively it can provide a competitive differentiator. Financial analytics helps the business focus on the most(prenominal) important customers and the most profitable products and services (Brook, 2009). It helps them to (Schroeck, 2001)* Understand the overall movement of the organization* Identify ways to measure and maximize the value of intangible asset assets (eg. Services)* Effectively manage enterprise-wide investments and reduce operating costs* Forecast variations in the marketplace,* Optimize the capabilities of information systems, and* Business processes improvement.Integrated analytics allow organizations with an ERP infrastructure to facilitate reporting and tools required for decision-makers. Oracle E-Business Suit (EBS) is one suite of applications that contains ERP and integrated BI. Oracle says that Oracle Financial Analytics helps front-line managers improve financial performance with complete, modish information on their departments expe nses and revenue contributions. SAP Business suite is a range of software modules with an integrated Business Intelligence. SAP states that SAP ERP provides omnipotent analytic software that enables powerful financial analysis to help you analyze your business, develop business plans and budgets, and track performance during execution. (SAP AG, 2009). Few of the features and functions that support financial analytics as stated by SAP are* Financial and management reporting Providing a set of tools to meet the financial and management reporting needs.* Planning, budgeting, and forecasting Support traditional budgeting, rolling forecasts, and collaborative planning, such as cost center planning.* Working capital and cash flow management Optimize cash flow, including cash flow calculations and middle- and long-term planning. gross revenue AnalyticsSales analytics is a procedure involving the gathering, classifying, comparing, and studying of company gross sales data. It may exac tly involve the comparison of total company sales in two different time periods. Or it may entail subjecting thousands of component sales (or sales-related) s to a variety of comparisons, like comparison with s for primitively periods of time (Wikipedia, 2009).SAP says that the SAP sales analytic help the organization to obtain the data prerequisite to proactively address trends and measure success and revenue shortfalls. Oracle states that analytics solutions provided by its E-business suite dramatically improve the durability of sales people by providing real-time, actionable insight into every sales prospect at the point of customer contact. With more accurate sales forecasts and raise identification of potential problems and opportunities, Oracle Sales Analytics helps close business windy and increase overall sales revenue. It lists the following benefits* Resource allocation Identifying critical opportunities so that executives can assign the appropriate resources to inc rease the chance of lovely* Sales forecasts Analyzing pipeline opportunities to determine actions required to meet sales targets. erect the information about sales documents, such as opportunities, sales orders and sales contracts. Thus, help in future revenue forecasting.Integrated sales planning and analysis enables sales managers to understand the financial status and overall effectiveness of the sales organization quickly and easily. These scenarios help users obtain the data necessary to proactively address trends, measure customer retention and revenue shortfalls, and assess future opportunities (SAP, 2009).Operational AnalyticsOperational analytics is a process that facilitates delivery of the in-depth and focused analysis of the performance of each key operational area of the business. Operational Analytics try to provide comprehensive and focused analysis of every aspect of the operational area of a company (Information Management, 2007). Oracle says that Oracles Busines s Intelligence Suite delivers real-time operational analytics that enable you to make better business decisions red-hot. Operational analytics is also a part of SAP business suite. SAP says that SAP ERP provides features and functions for operational analysis to help you optimize the entire supply chain, improve revenues, and increase customer satisfaction. Few of the features and functions that support financial analytics as stated by SAP are* Manufacturing reporting Provides various standard reports and analyses detailing production-related information.* Customer service analysis Used for supervise financial trends, costs, and revenues per customer, as well as service contracts and operations.* Sales planning Used for opportunity planning and analysis and partner planning.* Sales analysis Provides an accurate overview of current sales performance and an overview of sales force effectiveness. men AnalyticsWorkforce Analytics is a powerful decision-making platform using busine ss intelligence tools that offer to the management at every level the right and timely information at point of decision making process for a better visibility and accountability in regards to workforce-related issues (Information Management, 2007). Workforce Analytics is used by HR professionals, and line managers. It provides an analysis option that gives real-time insight into your workforce. They can identify trends at an early stage and make well-informed decisions, change you to manage your human capital more effectively, predict human-capital investment demands, and track workforce costs and the ROI associated with HR projects (Wikipedia, 2009).The focus is to analyse current and historical employee data to identify key relationships among variables and use this to provide insight into the workforce they need for the future. Oracle says that Oracle workforce analytics in the e-business suite provides the strategy management and performance tracking needed to measure the effe ctiveness of HR green lights. It helps to evaluate and communicate company performance, staffing, turnover, HR readiness, compensation, and competencies.Managers need information that will help guide your strategic decisions. Implementing an Enterprise Resource System (ERP) that integrates all the information and processes into one coherent environment is a first and major step towards improved decision-making. But capturing and processing data is not equal to give the insight into the business that decision makers need today. Only when join with a business intelligence system can your ERP software enable users analyse and act on that data quickly and effectively. IT industrial leader, Microsoft quotes that prognosticator for Microsoft Dynamics ERP helps you manage financial performance through accurate budgeting and planning (Microsoft, 2009).A CRITIQUE OF VENDOR CLAIMSData WarehousingIn todays ever-competitive business climate, the ability to understand business conditions and gain timely insight into business performance is essential for survival. Business users have long faced the challenge of being unable to easily analyze business data in their enterprise resource planning (ERP) environment. Oftentimes, the reporting tools available are too complex for business users to utilize effectively, and IT experts do not have the business digestground to sufficiently understand business users analytical needs. The delay in IT departments turnaround time can quickly render information opposed and outdated by the time it is available to business users.ERPs serve as transaction engines in many organizations. It provides mission-critical operational workflow but do not support decision support systems (DSS) directly (Inmon, 2000). Therefore, the need to source a data warehouse from the ERP system and other legacy systems is obvious. legion(predicate) organisations are now discovering that the solution to leveraging investment decisions in and retrieving useful data from, an ERP system is to undertake a Data Warehousing initiative in conjunction with the implemented ERP system. But, the harsh reality of ERP systems implementation, to the expense of those organisations that invested resources in the initiative, is that ERP only gets data into the system, it does not prepare data for use and analysis (Inmon, 2000). ERP systems lack certain functionality and reporting capabilities. It has been realised that ERP systems are good for storing, accessing and punish data used in daily transactions, but it is not good at providing the information needed for long term planning and decision making (Radding, 2000) as ERP systems are not designed to know how the data is to be used once it is gathered (Inmon, 2000). Consequently, in the post-implementation phase organisations are often dismayed to find that they havent improved their analytical and decision support capabilities (Inmon, 2000 Radding, 2000) as ERP systems do not provide an environment fo r decision support activities such as analysing historical trends, drawing conclusions, scenario building and planning.Business Intelligence using Data Warehouse built on ERP SystemAnalytical and forecasting features are provided by the business intelligence tools that are united to the data warehouse. Some of the common functions of Business Intelligence technologies are reporting, analytics, data mining and benchmarking (Wikipedia, 2009). Integration of ERP and BI can provide a amalgamated analysis of the data and user-friendly reporting capabilities and help users make and proper decisions and gain advantages over their competitors. Financial analytics, sales analytics, operational analytics and workforce analytical, may provide the facility to analyze relationships and understand trends that ultimately support business decision. However, few of the challenges faced by data warehousing in ERP systems are in its capability of providing a valuable and accurate reporting service, data analysis and forecasting. Chou et al says (2005) says Organizations recognize the wealth of information within ERP systems, the challenge lies in the ways of mining them. The lack of historical transaction data in the database containing the data from ERP is the most significant obstacle in successfully implementing a BI on ERP system. One of the key elements in accurate forecasting like trend reporting is the need for historical data.Most of the ERP vendors claim that the reports and forecasts generated by ERP or a BI that is integrated with ERP environment are of high accuracy. Zhang et al (2006) says that although ERP system is powerful, a severe challenge is how to make use of previous experiences and knowledge to support managerial decision making. Still the research has to be carried out to know the accuracy of the reports as ERP system does not contain the historical data in the enterprises data warehouse. Traditionally, the enterprise data warehouse needs historical d ata. When a large amount of historical data starts to stack up in the ERP environment, the ERP environment is usually purged, or the data is archived to a external storage facility. When an enterprise data warehouse needs to go back in time and bring in historical data that has not been previously colle