Problems Faced Before ERP Implementation

Problems Faced Before ERP ImplementationSome entropy, memory access from blackjack oak R/3, goes directly into skim NetWeaver BI information marts. plainly the rest, which comes from diverse governances that handle mission, customer relationship management (CRM), mediation, provisioning, and prepaid gross r flushue, goes archetypal to a third-party extr do/transform/load (ETL) system. The ETL system takes the information from on the whole c both(prenominal) in that customers make every payment, every recitationfulness of process call, and to a greater extent and transforms it ground on transmission line sector incurs before storing it in a third-party entropybaseAb bulge out faith Infocomm reliance Infocomm is the outcome of the ripe visionary Dhirubhai Ambanis (1932-2002) dream to herald a digital revolution in India by bringing affordable message of information and communication to the doorsteps of Indias vast population.Make the peckers of Infocomm av ailable to wad at an affordable follow, they allow for overcome the handicaps of illiteracy and lack of mobility, Dhirubhai Ambani charted out the military commission for Reliance Infocomm in late 1999. He saw in the emf of information and communication technology a once-in-a-lifetime opportunity for India to leapfrog over its historical legacy of backwardness and under checkment.Working at breakneck speed, from late 1999 to 2002 Reliance Infocomm built the backb wiz for a digital India 60,000 kilometres of fibre middle backbone, crisscrossing the entire country. The Reliance Infocomm pan off-India meshing was commissioned on December 28, 2002, the s compensatetieth line of descent anniversary of Dhirubhai. This day also marked his first birth anniversary after his demise July 6, 2002.Reliance Infocomm network is a pan India, high capacity, integrated (wireless and wireline) and convergent (voice, data and video) digital network, designed to rear services that drag i n the entire Infocomm value chain infrastructure, services for enterprises and individualists, employments and consulting. The network is designed to deliver services that will foster a stark naked way of life for India. light upclarify CRM is the crossway of clarify Inc. guest Relationship Management is a comprehensive short letter strategy, foc theatrical roled on the process of acquiring, managing, retaining and partnering with selective customers to create superior long-term value for the fellowship and the customers.In a nutshell, CRM strives to identify customers who reserve the greatest re bring out to the company, and to optimise relationships with those customers.CRM features Segmenting customersResponding uniquely to the best customersHaving a 360 degree stack, of a customer amount and driving down the follow of customer acquisitionAttracting customers using the entirety of the experience you provideNeed for CRMCustomers lay down the upper hand in roughly pu rchase transactionsThey atomic enactment 18 inherently less trueheartedThey commit rising expectationsThey no longer tolerate companies that dont get the fundamental principle rightAdvantages of CRMTo gain a better understanding of customers wants and inevitablyAllows companies to cope with and access information about customers buying histories, preferences, complaints, and different data so they sess better anticipate what customers will want.The goal is to instill greater customer loyalty.Used in association with data warehousing, data mining, call centers and other intelligence-based actsFaster retort to customer inquiriesIncreased efficiency through and through automationObtaining information sharable with business partnersDeeper understanding of CustomersIncreased marketing and marketing opportunitiesIdentifying the most profitable customersImproved products and services through customer feedback illuminate Design PhilosophyFlexibleWherever possible rules are held as data in the applicationCustomizableExtremely easy to assortment numerate and functionality of screensCan add rising fields, tables and relationships to the databaseUpgradeableWe want you to be able to tab current easilyHighly scaleableHigh volume with good response timesComprehensive and open data modelMore tractableness than most people expectCan use any SQL-based instrumental roles for stateing, etc commandAbility to deal with multi-currency, variant languages, etcWorkflow orientatedStrong ownership paradigm so nonhing falls through the cracksUse of standardsThe new applications include Clarify Customer Portal which stores customer information and lets customers herald with a company via methods such as E-mail and online chat. Clarify eOrder lets customers surf online then takes orders and manages them through fulfillment it works in conjunction with Clarify eConfigurator which determines customer unavoidably and then helps configure complex products. Clarify eMe rchandising lets businesses recall from customer analysis data and develop personalized marketing campaigns and product offeringsClarify ApplicationsCall totality ClearCallCenterFront end for Contact Center AgentsManages overall customer interactionCan be used as sales application or as a front-end to ClearSupport for hybrid sales/service. Operates in both relationship-based call centers and high-volume, one and done sales environmentsgross revenue Force Automation ClearSalesHandles prospects and leadsSales force back automationProvides management of all aspects of the selling cycle, from lead through completed order. Provides an enterprise-wide view of sales and reenforcement activities in accounts for current relationship management activitiesCustomer Support ClearSupportIs a trouble management systemSingle header of contact for service requests and line of work reportingComprehensive technical support management system, Handles calls that exact service requests, gestures , etceteraDSS is a data warehousing department that caters to the trains of the management by delivering vital information to business users to make incidentally and accurate decisions for business growth leading to effective and efficient trading operations to gain a competitive edge in the marketplace.DSS is a system that Collects data from fivefold root words, Summarizes data as per business needs and creates reports at business operationsDSS modifys business users to centrally supervise and analyse information, monitor various events and enable them to react to those events by providing a superstar view of business information. DSS is a business-centric data warehousing department with an integrated workflow mechanism that supports streamlined business processes. It delivers high performance access to all information and applications on CRM, Billing, Product and Network domains.CRM applications delivered by a DSS enable business user to analyse number of customers, tre nds and usage patterns of individual customers, individual customer records, etc. It also holds information about customer service like Interaction and Cases handled by Call Center, human activity of Interactions, Interaction Category, Number of Cases, Case Status, Case Category, etc.Product applications provide all liable(p) information about the usage and performance of various products like SMS, R-Connect, R-World etc.Billing applications provide all pertinent information about the billing and outstanding of RIM customers. It holds in information of ADC answer Status, Billing Circle, CIOU Code, point Code, Channel Type, City, Customer Type, no.of Invoices, and No. of Payments, OG Barred Status, OTAF Month, Payment Option, Rate Plan, Service wise, Month wise, Zero Payment wise Billing Status.DSS offers three kinds of reports that is to sayOLAP Reports (http//dss.ril.com/) course Intelligence Reports (http//dssbi.ril.com)Ad hoc Reports based on the data pass by the business userETLThe acronym ETL is used to describe the processes used by DSS to obtain data from external sources and make it usable to the DSS applications. ETL stands for Extract, Transform and Load. filiation is the process of selecting and pulling data from the operational and external data sources, in order to prepare it for the warehouse. Also called Data Extraction. A good blood line is based on a Business Rule. Business rules are apply to data using constraints.There are two basic ways that the extract process is performed. Either the system providing information will result the DSS aggroup a feeder file. This file will than be real by DSS and used to load tables. The other option is for the DSS aggroup to create verbally SQL code and in reality perform in place extractions from source systems. In both of these cases, the timing, data volume estimates and source systems impacts need to be considered variety is the process of manipulating data. Any manipulation beyond copyin g is a transformation. form includes cleansing, aggregating, and integrating data from multiple sources.Example Address1, Address2, Address3 could be concatenated as one single field.Transformation is the biggest, most complicated, most resource intensive and most valuable of DSS process. The transformation takes raw, unclean, unformatted, unsynchronized, sparse, and often corrupt data sources and standardizes, cleans and peeres it up plenteous to make it useful for further analysis..BOBusiness Objects is a reporting tool for SQL compliant databases. It allows users to prepare custom reports from a number of databases simultaneously, which in contort facilitates advanced reporting and data analysis.Loading is the last step in the ETL process. Loading is nothing more than taking the outputs from the transformation process and pose it into an Oracle table. The process of moving extracted, transformed into the data warehouse. Generally the data is loaded to the Target table. Targ et table holds the intermediate or terminal results of any part of the ETL process. The target of the entire ETL process is the data warehouse.BWThe tucker Business education Warehouse allows you to see data from operant wear upon applications as swell as all other business applications and external data sources such as databases, online services and the Internet. The Administrator terrace functions are designed for controlling, monitoring and maintaining all data retrieval processes.The SAP Business schooling Warehouse enables Online Analytical Processing (OLAP), which processes information from cock-a-hoop amounts of operative and historical data. OLAP technology enables multi-dimensional analyses from various business perspectives. The Business Information Warehouse Server for core areas and processes, pre-configured with Business Content, ensures you can style at information within the entire enterprise. In selected roles in a company, Business Content offers the info rmation that employees need to carry out their tasks. As well as roles, Business Content contains other pre-configured objects such as InfoCubes, queries, primal figures, characteristics that make BW death penalty easier.With the Business Explorer, the SAP Business Information Warehouse provides flexible reporting and analysis tools for analyses and decision-making support in your enterprise. You try out the dataset of the Business Information Warehouse by defining queries for Infocubes using the BEx interrogative Designer. By selecting and combining InfoObjects (characteristics and fundamental figures) or reusable structures in a query, you determine the way in which you navigate through and evaluate the data in the selected InfoProvider. The layout of the report needs to be pre-de gracefuld before design. Reports are the terminal deliverable to the users.The process of report definition starts with waitment and ends with its development and examen by Business Analysts. Dur ing this process the Business Analysts interacts with report developer closely and fine tunes the outcomes in a back and forth form of process. The developer in turn technically chooses the InfoObjects (characteristics and key figures) already defined in the cube that needs to become part of the report.BenefitsFrom the day we started operating our business, our managers had information about the traffic, how the products we launched into the market were performing, how our customers were using them, how we were acquiring new customers, and our customer interactions, Gupta explains. All these things helped us to provide services with lower costs, which is one of the reasons we were able to win the market.SAP NetWeavers mogul to span incarnate silos and offer a single view of corporate information lets the DSS team deliver solutions quickly and accurately. For instance, approximately 95 percent of the data is loaded from non-SAP systems, with 18 million records processed daily, an d SAP NetWeaver is the key accompanimentor that made Reliance Infocomms triumph possible.An aggregate enhances performance by duplicating the data from an InfoCube and storing it in a summarized form so you can access it quickly for reporting. If you want great performance results with reports and you do use aggregates. development SAP NetWeavers aggregate tool lets you increase flexibility while purpose and can sometimes let you meet more than one business requirement with the same model.SAP Opportunities1. IntegrationIntegration can be the highest benefit of them all. The only real project aim for implementing ERP is reducing data redundancy and redundant data entry. If this is set as a goal, to modify inventory posting to G/L, then it might be a winnerful project. Those companies where integration is not so important or even dangerous consort to stick out a lumbering time with ERP. ERP does not improve the individual efficiency of users, so if they expect it, it will be a big disappointment. ERP improves the cooperation of users.2. EfficiencyGenerally, ERP software focuses on integration and tend to not share about the daily needs of people. I look at individual efficiency can suffer by implementing ERP. the big foreland with ERP is whether the benefit of integration and cooperation can make up for the loss in personal efficiency or not.3. Cost reductionIt reduces cost only if the company took accounting and reporting seriously even before implementation and had put a lot of manual effort in it. If they didnt care about it, if they just did some simple accounting to fill mandate statements and if internal reporting did not exists of has not been fincancially-oriented, then no cost is reduced.4. Less personnelSame as above. Less reporting or accounting personnel, but more sales assistants etc.5. AccuracyNo. People are accurate, not software. What ERP does is makes the lives of inaccurate people or boldness a complete hell and maybe forces them to be accurate (which instrument hiring more people or distributing work better), or it falls.ChallengesEven though the company started its DSS before the sales side launched, it still had to deal with multiple data sources across heterogeneous platforms a common issue for most organizations working with business intelligence (BI), and a challenge perfect for SAP NetWeaver Business Intelligence (SAP NetWeaver BI).Data granularity More granular models require higher data loads and more maintenance. While designing a model, its critical to hold off the principles of star abstract in mind. Star schema is generally considered the simplest data warehouse schema, and its characterized by very large fact tables that contain the primary information in the data warehouse in conjunction with smaller dimension tables that contain information about accompaniment attributes of the data in the larger fact table. With this in mind, your model should progress to data summarization by a fact or of 13 so that youre not working with more than 33 percent of your source data.Dimensions Group your information objects into dimensions so that each dimension has a fit number of records, and put frequently used characteristics into one dimension so you can cut down on the number of table JOINs take for the OLAP processor to churn out the data.Data deletion If you want to scale, you need to have a data-deletion process in place that the application owners have clearly agreed to and understood, and you need to have the deletion process in place at the modeling full point.Navigational attributes By using navigational attributes in SAP NetWeaver, you can maintain data consistency when dimensions change slowly, and you can reduce data-storage requirements, but you have to analyze this during the modeling stage to get the benefits.Problemsthe company would have been forced to have multiple copies and different views of the same data.Implementation Timetable1999 Forms and begins construction of fiber-optic networks Late2002 Launches and creates first Bl application March2003 Has commercial launch Mid2003 DSS starts rolling out Bl application July2003 Gains 1 million new subscribers Late 2003/early 2004 Bl applications roll out to additional locations.Six Critical RecommendationsGuptas initial decision-support team of three people augmented by BI consultants from around the world has now grown to 65 staff members and counting. Gupta and his DSS team offer some critically important recommendations to those be after an SAP NetWeaver BI implementation.1 Plan to scale. One way or another, all BI systems get bigger. Some get bigger because businesses keep generating data they dont really need, but most often products, pricing, and markets become more and more complex, which is true for Reliance Infocomm. In order to compete, the company must span diverse geographies and offer a variety of products and services as business analysts identify shifting customer needs. In addition, the sheer growth in the number of customers presents the most obvious scalability issue. We are expecting the business to grow from 14 million customers to 20 million customers by the end of 2006, Gupta says. Those are the kinds of estimates we have to work with.2 Involve the business. Simple at first glance, this fundamental rule is often overlooked but is critical to a DSS. At Reliance Infocomm, each analytic application has a business sponsor who owns the application, in addition to business analysts who help to translate the business requirements into IT implementation terms. This all affects how the DSS team sets up InfoCubes for the business units.How you model your business requirement with SAP NetWeaver is the most important thing, Gupta notes. If your model is bad, its not going to work and the information is never going to come out. So, mapping all your business objects into a multidimensional cube is the most important step and SAP NetWeavers features are excellent for modeling.When its time to build analytic applications, the DSS team builds only solutions that have clear business owners attached. This is critical for two reasons First, business owners come to the DSS team only with business-driven needs (as opposed to IT offering what it thinks the business might need). Second, the DSS team knows it will get launch support to correct unforeseen problems quickly, as well as see that the users start putting the applications to use. How many unspeakable applications are built each year that fail for lack of use or business alignment? For this DSS team, that just doesnt happen.3 Ensure data curse. some other problem with many BI installations is a lack of user trust of the systems, and it can happen at any level numbers dont match in front of a line-of-business manager or customers on the other end of the phone dispute the information available to your call-center employees. Business analysts, Gupta says, can be invaluable in resolving problems as the DSS team consolidates data from disparate systems into layers for the InfoCubes.Sometimes there can be a problem with the interpretation of the data, adds Arun Dhall, lead architect for Reliance Infocomms DSS team. For example, when you look at the number of customers acquired yesterday, people who just filled out the application form could be new customers, but as weve defined it, when a person actually registers with the network, thats when they become a customer. Its these common definitions used across the business peculiarly when the numbers are both essentially accurate that build ongoing positive momentum for DSS applications.4 Delete Delete Delete At 3.5 terabytes (TB) in SAP NetWeaver and 30TB altogether, Reliance Infocomms DSS system is one of the largest in the world, but that doesnt hateful it has to grow astronomically. To combat data bloat, We have very clear data-retention policies in place that decide how long the data is stored, Gupta s ays. We have 400 million records coming over per day, so if we were going to store all this information, it would be multi-hundred TB by now.This again, Gupta says, comes back to the business owners who understand that theres a cost to keeping information and who must decide how long they really need it. From an IT perspective, this policy not only keeps your data growth under control, it helps force the business managers to focus on what they really need from the DSS to achieve the sought after results.5 Dont skimp on look and feel. Many in-house applications are functional, but they look terrible and are hard to understand, which can adversely affect the success of the application more than IT bugs. You should be able to make a report that is not complicated and is easy to understand, Gupta says. If you bring back users a complex report, they will never use it. At every level, Reliance Infocomm employees are using DSS. Part of every application rollout is end-user education, and the company is now at the point where product managers want their own data marts so they can analyze the information themselves. Also, Gupta says, the information should come out fast. The largest Reliance InfoCube has close to 1 billion rows, and yet it generates consistent response times that let employees act in less than a minute.6 Always chase and never give up. Guptas DSS team lives by this motto, which basically means that IT is empowered to push hard to find or chase down answers to any technical question or goal. The DSS team is very persistent, Gupta says, and it comes down to a culture of accept that anything is possible.If we can think it, we can do it, says Pramod Kejriwal, development lead for the DSS team. Our philosophical system is we dont believe in giving anything up very easily. The philosophy has give the business owners, too. Anything they think they need to help do their business in a better way, they ask they should be thinking about business, not wheth er something is technically possible.Into the FutureFor now, the numbers clearly speak to Reliance Infocomms DSS success More than 1,500 active users across India, 250 concurrently, more than 150 applications, more than three hundred online analytical processing (OLAP) reports, more than 300 SAP NetWeaver BI reports, more than 200 monthly ad hoc reports all working with more than 24TB of data which make Reliance Infocomms DSS, an in-house implementation, one of the largest data warehouses in the world.More fundamentally important, though, is the fact that business users have adopted the DSS implementation as the single and most authentic source of corporate information, Gupta notes, which speaks to the companys ability to scale into the future.On the drawing board, Gupta looks forward to information broadcasting and implementing creative collaboration cortege using a revamped SAP NetWeaver Visual Composer (in SAP NetWeaver 2004s), management cockpit, planning and simulation mode l, data mining (APD), and actively working on even higher-performance analytics by using SAP Business Intelligence Accelerator (SAP BI Accelerator also part of SAP NetWeaver 2004s) as an appliance tool with separate hardware that can index an InfoCube, which you can then use to run very fast queries.Whatever comes next, Reliance Infocomm has used SAP NetWeaver BI to create a DSS capable of handling one of the worlds largest BI workloads both now and in the future.Challenges with SAP1. ExpensiveThis entails software, hardware, implementation, consultants, grooming, etc. Or you can hire a programmer or two as an employee and only buy business consulting from an outside source, do all customization and end-user training inside. That can be cost-effective.2. Not very flexibleIt depends. SAP can be configured to almost anything. In Navision one can develop almost anything in days. Other software may not be flexible.