Overview of sap bw Problems

1. After several years of work, how many complete projects have you done?

A: "I have worked on a complete project and now I am working as an internal consultant or external consultant in this company.

 

2. Which one do you mainly take charge?

A: I am mainly responsible for the FI and HR modules above BW and have some knowledge about other modules.

 

3. What is the Delta mechanism?

A: After the first data load, Delta allows you to load only the data that has not been loaded next time.

 

4. is the process of loading transaction data delta in different modules the same?

A: The difference is that MM has a Delta device and FI has a fi device.

 

5. What is data source enhancement?

A: The enhancement of merge se is actually to modify the structure of the standard merge se, and then write the ABAP command to get the data you want from the extract data and put it in merge se.

 

6. What is the biggest difference between cube and ODS?

A: The biggest difference is that the Cube's keyfigure is cumulative, but ODS can overwrite. ODS is generally used to store item-level data.

 

7. How do you understand Performance Tuning?

A: Cube optimization includes compression, partitioning, clustering, and query optimization.

 

8. What is a cleansing table? Where can I use it?

A: A self-built table contains key fields and data fields. Then, this table is used in the routine to clean data.

There are many examples of conversion. The advantage of using this table is that the content in the table can be changed at any time as the business changes, without changing the program.

 

9. Is infopackage automatically added after BI contents is activated?

A: Under datasource, install all the items first, and then manually create the infopackage. infopackage must be manually created by yourself.

 

10. Do you know what real-time can do?

A: bw is generally used for historical data analysis. This technology is required if real-time data is required in the model, but the system efficiency is very low and is rarely used.

 

11. What are the common data extraction methods for R3?

A: Lo extraction, General extraction, CO-PA extraction.

 

12. Which types of data sources can be extracted by Delta?

A: Table/view, infoset, and function module can be loaded using delta.

 

13. What update modes does Lo extract?

A: Direct delta; unserilized V3 update, queued delta.

 

14. What does rsa5, RSA 6, and RSA 7 mean?

Answer: RSA 5: display the Bi content of the delivery version. You can activate Bi content.

RSA 6: displays active Bi content.

RSA 7: used to view the content in Delta queque.

 

15. What are the differences between bi3.5 and bi7.0 data loading steps?

A: bi3.5. Copy eclipse3.x, create infosource, create transfer rule between eclipse3.x and infosource, create infocube/ODS, create update Rule Between infosource and infocube/ODS, and create inpackage to load data.

Bi7.0. copy datasourse, create infocube/DSO, create information between datasourse and infocube/DSO, create infopackage for datasourse, load data to PSA, and create DTP, load data from PSA to infocube/DSO.

 

16. What are the lo extraction steps?

A:

1. Transmit transmit se

Ii. Maintain the extraction Structure

3. Maintain and generate the response se

4. Copy and activate the merge Se in SAP bi

5. Maintain the data target (infocube)

6. Maintain the conversion between the datasourse and the data target

7. Create a data transmission process

8. Activate the extraction Structure

9. Delete the set table/execute the set Extraction

10. Select an update Method

11. incremental initialized infopackage

12. Plan V3 to run in a centralized manner if necessary

13. incremental upload infopackage

 

17. How to enhance the data source?

A:

1. fields required for structure definition appended to the extract se extraction Structure

2. Write your function exit to call the relevant data source of datasourse

3. Copy this sort Se IN Bi

4. extract data for enhanced sort se

 

18. What is incremental queue?

A: The incremental queue is a new or changed data storage format (data records that have occurred since the last data request ). When receiving a Data Request from the system, the system will use the update process in the source system or enter the automatic write to the incremental queue.

19. How many update modes are used for infopackage?

Answer: 1. Full update. 2. initialize the incremental process. 3. incremental update.

20. What is incremental update?

A: incremental update is only a data record that has been created or changed (or deleted) since the last request was loaded in the source system.

 

21. What types of records does each incremental process support?

A: The front image of the background image is a new image.

 

22. What is the principle of the incremental process of flat files?

A: If the incremental process uses a flat file, the data is not transmitted to Bi through the incremental queue, but directly

Load from the merge se to PSA.

 

23. What types of DSO categories are there?

A: Standard DSO, optimized DSO, and directly written to DSO.

 

24. What are the different types of DSO objects?

A:

1. Standard DSO object, with known table activity data, change log and activation queue.

2. The optimized object has only one active data table for a large amount of data.

3. Directly written objects only have an active data table that can be used to analyze the program (analytic program designer. This DSO object replaces transactional objects in earlier versions.

 

25. What is a multi-factor provisioner?

A: Yes. It combines multiple pieces of data for reporting. The donor itself does not contain any data. The data is merged by the combined data.

 

26. What is an information set?

A: Information sets are usually defined as data, standard information blocks, and information objects are time-related features. The intersection is time-related or temporary intersection, which is the syntax layer on the data source. And a typical set is a specific data view.

 

27. Non-clustered key figure, principle?

A: The non-clustered key figure is similar to the calculated field. It is calculated from another field.

 

28. What is process chain?

A: process chain is a series of processes planned to wait in the event background. Some of these processes trigger a separate event, which can start other processes in sequence. Each process in the process chain is equivalent to the jobs that have been approved in the event-related basic system.

 

29. Process Chain-maintenance?

A:

* Process chain maintenance by calling the transaction code

* In the management function area, select the process chain in the Navigation Pane to call the process chain maintenance.

* In the modeling function area, you can call the process chain maintenance by selecting the process chain icon on the toolbar (or selecting Edit> process chain from the menu.

* Select the process chain maintenance button in the toolbar to access the process chain maintenance from the maintenance dialog of the supported processes

30. R/3 does the system need to establish a logical system in R/3 and specify the data to be extracted to the BW system?

A: To extract data from the R/3 system to the BW system, you must create a logical system in R/3 and specify it. You can create an internal Se by yourself, or use rsa5 to activate the \ internal Se (under R/3) that comes with the system ). The procedure is probably R/3 to create a logical system, BW to create a logical system, and then create two background users, one R/3 and one bw for communication. Create a source system in BW, transfer R/3 global setting (change rate also needs to be transmitted), and then copy data
Source.

 

31. What is the specific meaning of the navigation attribute when a model is created?

A: It is used for query. The process is as follows. First, select a field in the navigation attribute of the master data, for example, if the item Group of the item master data is set as a navigation attribute, there is a place in infocube to set the navigation attribute, here is the sum of the navigation attributes of all features in the infocube (if the navigation attribute is not selected in the feature, it cannot be found in the infocube ), after you select this attribute as the navigation attribute in infocube, the item group can exist as a navigation attribute of the item. During the query, the item group (which appears in the drop-down menu of the item in the feature) can be a query condition or other restrictions.

 

32. publishing the BW report to excel has a variable calendar year and month. When you open a window every day, the variable values are arranged in order, because there is a large amount of data in the cube, I have to flip several pages each time. How can I arrange the information in the pop-up window in reverse order?

Answer: method 1. In the variable input window, select "single value" and click "calendar year/month" to switch the sorting mode (ascending or descending ).

Method 2: replace the "calendar year" with the "calendar month" variable with the "calendar year/month" variable, and set the default query value to reduce the number of items.

 

33. How do I display data in the query center?

A:

1. Select the region to be modified

2. Click layout in the Bex menu and select alignment.

3. Set horizontal to center

4. Save the workbook to query properties in query designer. You can select results position in Number Format for the display tab, but only bottom left/right and top left/right.

 

34. When displaying data in infocube, a key value a is found in a record, and its value is 23.3.

At the same time, when the corresponding mulitprovider displays data, it finds that the key value A of this record is 0. when the report is displayed through a query, the key value of this record is also 0?

A: kf in infocube is added to mulitprovider, but it is not specified from which infocube to obtain it;

In the upper-left corner of the mulitprovider editing page, click Select key figures. Click it to check the kf of the infocube.

 

 

35. The following error is prompted when the Bi data source system is activated. No metadata upload since upgrade rsar 672 how can this problem be solved?

A: Perform step-by-step checks to narrow down the scope:

1. Confirm that BW source system connection is valid: BW system rsa1-> Source System-> select the source system you need and right-click check.

2. If there is a problem with the source system, you can use sm59 to test whether the RFC connection is correct.

3. If there is no problem with the source system, you can copy the data source again.

4. The data source copied after this step is normal.

 

36. bw purchasing standard cube problem, the fields displayed in the report are:

"Materials, suppliers, Procurement Order No., material document No., delivery Ticket No., work order, delivery stock location, reference, quantity, unit, the data of these fields. However, the two fields of reference and delivery are in the purchased Data source:

2lis_02_cgr

2lis_02_hdr

2lis_02_itm

2lis_02_s011

2lis_02_s012

2lis_02_scl

2lis_02_scn

2lis_02_sgr

2lis_03_bf

2lis_03_bx

Not found in the extraction structure.

The delivery order is found in 2lis_02_acc and there is no record, so it is not considered in this data source.

2lis_06_inv has the reference field, but the content value is not correct.

The standard data source and CuBE are used for this purpose.

The mkpf table contains the material document number and delivery order number. The delivery order field is not displayed in the structure of the procurement part in rsa3/lbwe.

A: You need to perform enhancement or custom data source extraction.

 

37. If you want to extract a table but the data sources cannot be the same, where is the design?

A: set it in the information package.

 

38. What is infocube?

A: infocube is an information cube. It uses a star structure to store and analyze data. It is used for multidimensional data analysis and statistics.

 

39. Create a calculated key figure in query designer. Because I want his formula structure, I can automatically export all ckf formulas in the future. But in modeling, only the general key figure is displayed, and there is no ckf?

A: In the BW transfer under the modeling tree-> transfer type-> query-> formula, the hierarchy is the link. You can see it.

 

40. If the information object is modified, what is the error message returned when the information package uploads data? How can this problem be solved?

A: copy the data source again.