Thursday, November 11, 2010

Extraction, Process Chains, ASAP Methodology

LO Extraction
203. What is the specific advantage of LO extraction over LIS extraction?
a. The load performance of LO extraction is better than that of LIS. In LIS two tables are used for delta management that is cumbersome. In LO only one delta queue is used for delta management.
204. What is Logistic Cockpit (LC)?
a. It is a technique to extract logistics information and consists of a series of a standard extract structures delivered in the business content.
205. What is the significance of setup tables in LO extractions?
· It adds the Selection Criteria to the LO extraction.
206. What is Delta Management in LO?
a. It is a method used in delta update methods which are based on change log in LO.
207. Suppose we performed a LO extraction using v3 update. This update method has problems after replication. Can you change the alternative methods?
a. This is only the extraction mechanism for logistics other than LIS and SAP is not recommended LIS extraction
CO-PA
208. What is partitioning characteristic in CO-PA used for?
· For easier parallel search and load of data.
209. What is the advantage of BW reporting on CO-PA data compared with directly running the queries on CO-PA?
· BW has a better performance advantage over reporting in R/3. For a huge amount of data, the R/3 reporting tool is at a serious disadvantage because R/3 is modeled as an OLTP system and is good for transaction processing rather than analytical processing.
210. Can we extract hierarchies from R/3 for CO-PA?
· No, we cannot, there are no hierarchies in CO/PA.
211. Explain the field name for partitioning in CO-PA.
· The CO/PA partitioning is used to decrease package size (eg: company code)
212. What is t-code for CO-PA?
· KEB0
213. What is operating concern in CO-PA?
· An organizational structure that combines controlling areas together in the same way as controlling areas group companies together.
214. What is field partitioning in CO-PA?
· Internally allocates space in database. If needed table resides in one or few partitions, then only these partitions will be selected and examined by SQL statement, thereby significantly reducing I/O volume.
215. Is CO-PA delta capable?
· Yes, CO-PA is delta capable.
216. What is operating concern and partitioning in CO-PA.
· Operating concern is set of characteristics based on which we want to analyze the performance of company. Partitioning is dividing the data into different datasets depending on a certain characteristics. Partitioning enables parallel access of data.
217. What is the difference between value fields and key figures in CO-PA?
· Value fields comprises of data which CO-PA gets from various modules in R/3. Whereas key figures are derived from these value fields.
GENERIC EXTRACTIONS
218. What are the steps in Generic extraction?
· RSO2 à
o Select the DataSource type and create
o On create DataSource screen:
§ Choose an application Component to which the DataSource is to be assigned.
§ Enter the descriptive texts. You can choose these freely.
§ Choose Generic Delta.
Process Chains
219. What are the load process and post processing?
a. InfoPackage
b. Read PSA and update data target
c. Save hierarchy
d. Update ODS data object
e. Data Export (Open Hub)
f. Delete overlapping requests
220. What are the data target administration tasks?
a. Delete Index
b. Generate Index
c. Construct database statistics
d. Initial fill of new aggregates
e. Roll up of filled aggregates
f. Compression of InfoCube
g. Activate ODS
221. What are the parallel processes that could have locking problems?
a. Hierarchy attribute change run
b. Loading master data for same InfoObject
c. Rolling up for same InfoCube
d. Selecting deletion of InfoCube / ODS and parallel loading
e. Activation or deletion of ODS object when loading parallel
222. How would you convert an InfoPackage group into a process chain?
a. Double click on the InfoPackage group
b. Click on the “Process Chain Maintenance” button
c. Type in the name and description. Individual InfoPackages are inserted automatically
223. What is a process chain and how you use it?
a. A process chain is a sequence of processes that are scheduled to wait in the background for an event. Some of these processes trigger a separate event that can, in turn, start other processes.
b. In one of our scenario we wanted to upload wholesale price InfoObject which will have wholesale price for all the material. Then we wanted to load transaction data. While loading transaction data to populate wholesale price, there was a look up in the update rule on this InfoObject Master Data table. This dependency of first uploading Master Data and then uploading transaction data was done through the process chain.
224. What is a Meta Chain?
a. Process chains which are clubbed together are called a Meta Chain. Each sub chain is triggered only when the previous Process Chain is successful.
225. What is process chain? How many types are there? How many we use in real time scenario?
· Process Chains can define interdependent processes with tasks like data loading, InfoCube compression, index maintenance, Master Data & ODS activation in the best possible performance & data integrity. Process Chains exist in administrator work bench. Using these we can automate ETTL processes. They help to schedule all activities and monitor (T-Code: RSPC).
226. Process chains: How to schedule data daily?
ASAP
227. What are the project phases in ASAP?
a. Project Preparation: We do a conceptual review at this initial phase.
b. Business Blue Print: We Collect Functional Specs and conduct a design review.
c. Realization: All the Developmental activities are done during this phase and we have a configuration review.
d. Final Presentation: All the QA and other final activities are done before moving to production. We do a performance review.
e. Go-Live and Support: To production and support
228. What is ASAP methodology
a. ASAP is a standard methodology for efficiently implementing and continually optimizing the SAP software. ASAP supports the implementation of the R/3 System and of mySAP.com Components, and can also be used for upgrade projects. It provides a wide range of tools that helps in all stages of implementation project - from project planning to the continual improvement of the SAP System. The two key tools in ASAP are: The Implementation Assistant, which contains the ASAP Roadmap, and provides a structured framework for your implementation, optimization or upgrade project. The Question & Answer database (Q&Adb), allows you to set your project scope and generate your Business Blueprint using the SAP Reference Structure as a basis.
FI-SL
229. 4 Functions to Update data in the FI-SL Special Purpose Ledger:
a. Validation
b. Substitution
c. Ledger Selection
d. Transfer of Fields
230. 4 Operations for FI-SL Data:
a. Currency Translation
b. Balance Carryforward
c. Allocation
d. Roll Up Ledgers
231. 5 tables that are created when an FI-SL table group is created:
a. Summary Table (...T)
b. Actual Line Item Tables (…A)
c. Plan Line Item Tables (…P)
d. ObjectTable_1 (Object / Partner) (…O)
e. Optional ObjectTable_2 (Movement Attribute) (…C)
BW - V3 Update... which function domain
RMBWV302 Purchasing
RMBWV303 Inventory
RMBWV304 Shopfloor controlling
RMBWV305 Quality
RMBWV308 Shipment
RMBWV311 Sales
RMBWV312 Shipping
RMBWV313 Billing
RMBWV317 Notifications
RMBWV318 Notifications
RMBWV340 Retailing
RMBWV343 POS - cashier
RMBWV344 POS - Sales Receipt
RMBWV345 Agency business
RMBWV346 GTM
BEx Reporting
232. What are Structures?
a. They are a combination of characteristics and Key figures (Basic Key Figures, Calculated Key Figures (CKF) and Restricted Key Figures(RKF))
233. What does the term CELL mean?
a. The term CELL in the function of Defining Exception Cells is the intersection of the two structure elements.
234. 4 Different types of Variables:
a. Text
b. Formula
c. Hierarchy
d. Hierarchy Node Variables
o Variable Hierarchy Node with a fixed Hierarchy
o Variable Hierarchy Node with a variable Hierarchy
235. 5 Variable processing types:
a. User Entry / Default Value
b. Replacement Path
c. Authorization
d. Customer Exit
e. SAP Exit
236. When we run the query at query run time the wrong data has come for one key figure, what might be the problem?
a. If the Key figure is Calculated Key Figures (CKF), check the formula. If it is a regular key figure, check the respective values in the InfoProvider. If the values are incorrect, need to check the update rules & transfer rules. If they are correct in the InfoProvider, then do check the source system table, maybe they are captured in correctly in the Source System level itself.
237. When we run query at run time it is not displaying one key figure values what could be the problem?
· Check if InfoProvider has values for the same. If yes, then check the formula incase of CKFs or check the selection parameters/filters etc in query.
238. Suppress the unit from displaying on the BEX Report
· Go into the query where your key figure is.
· Right click on key figures in the column section.
· Select New Formula
· Name the New Formula, Actual Qty
· In the function column expand Data Functions & select value w/o dimension.
· NODIM() will appear in the formula. Click on your key figure actual qty from the operand list.
· Hide your key figure in the query and display this new one (unit free)
239. I have a requirement where in, in the BEx Report I have to display the date when the report was run i.e. the Current date. Do I have to make use of VB code for that or is there a simple solution for that. Any Suggestions?
· You can use Variable (type: SAP exit) for the same i.e., 0DAT (current calendar day- which will be picked up from System date)
· I'm not sure if u have to do something in BW for that, but I have on my reports after they have been run, gone to the File Menu, then chosen Page Setup, then Header/Footer, click the Custom Footer button, then I'd select my date and time to appear on the Right section of the page at the bottom. I've also then saved the workbook as such and that date remained there.
· Have you tried using Text elements in the report? If you click on the "Layout" button, you can then select "Display text elements" and then "General". This puts in a number of elements into the report (workbook) The one you're looking for is a text element called "Last refreshed". It records the last time the report was refreshed (i.e. the last time it was run).
240. Assume that there is 5 years of data to be loaded as per the client requirement we need a key figure in the reporting. How to get historical data to that key figure? Is it possible to load only the current data instead of loading historical data for a key figure?
· When you load, just load it for 5 years. If you want to see just a current data in the Key Figure just create a Restricted Key Figure (RKF) with fiscal year (current) or posting period with your current value.
241. When to report from R/3 and when from BW?
· We can Report from R/3 for all operational needs that are based on the transaction data. The optimum use of BW is to analyze the data from tactical and strategic point of view.

3 comments:

  1. Hi Puru,
    I do have couple of questions:
    a) If we are creating the InfoCube(IC), then is the data getting stored in the relational tables ?
    I've a point in that case, if it's getting stored in the relational tables, then what will happen if the cube is already aggregated based on quarterly and yearly and if the data for Jan and feb'2011 is already present then how the loading of March's data affects Quarterly and yearly Aggreagtes and should not affect 2010 year.

    and what happens in the case of DSOs in that case ?


    b) If we manually update the Data in the Fact table, then will it get reflected in the IC ?

    ReplyDelete