Tuesday 3 February 2015

ERP Technical Round Sample Interview Questions and Answers Part3

21. What is Bex? –
Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.

22. What are variables? –
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.

23. What is AWB?. What is its purpose? –
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.

24. What is the significance of ODS in BIW? –
An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.

25. What are the different types of source system? –
SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.

26. What is Extractor? –
Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

27. Why implement an ERP system?
ERP software integrates all departments and functions across a company onto a single computer system that can serve all those different departments' particular needs.  ERP combines finance, HR, manufacturing and distribution all together into a single, integrated software program that runs off a single database so that the various departments can more easily share information and communicate with each other.  This integrated approach can have a tremendous payback provided the software is installed and used correctly.

28. How much does it cost to go for ERP?
The cost of ERP project would vary significantly from one instance to other. The actual cost depends on the nature of the industry, the size of the firm, the geographical distribution of the organizational units such as offices, plants, warehouses and distribution points, the number of user licenses and the extent of ERP implementation (the number of functional modules implemented). A typical mid-size Indian company with about Rs 100- 300 crores of annual business will have to invest about five to twenty crores of rupees in the ERP project. This includes ERP software licenses, server cost, communication network cost and the cost of consultants who would do the implementation. Large corporations with Rs 1000+ crores of annual business might invest Rs 100+ crores in ERP project. A number of small companies have managed to implement ERP in about Rs 1 crore. It may be noted here that in a typical installation the cost of ERP software accounts for only about 20% of the overall cost. A major component in ERP project is the cost of the implementation consultant (both internal and external).

29. What is an ERP Project team?
ERP project team would be charged with the responsibility of implementing the ERP for the specific organization. A champion, who is skilled in communication and understands the organization well should head the ERP team. The leader must be well accepted by the most employees of the organization. The leader also must be a person who can keep the motivation level of the implementation team at fairly high levels throughout the several months of implementation. The implementation team would consist of dozens of people. There will be a number of teams for each of the functional area with every team consisting of key users and IT personnel to provide technology support.

30. Is there a benchmarking tool to fine tune ERP performance?
Every ERP vendor provides performance guidelines that can be used by system administrators to fine tune performance. Some of them are very comprehensive and address fine-tuning at the application, database, operating system, processor and even the network level. Other ERP vendors provide tools that can leverage the leading edge database tuning, operating system tuning and network performance tuning tools.
More Questions & Answers :-

No comments:

Post a Comment