Explore topic-wise InterviewSolutions in .

NO, it is not ALWAYS necessary to create the partner profiles in CASE of file to IDOC scenario if you are doing it for testing purposes OTHERWISE you have to configure partner profile to assure XI for receiver client.

NO, it is not always necessary to create the partner profiles in case of file to idoc scenario if you are doing it for testing purposes otherwise you have to configure partner profile to assure XI for receiver client.

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.

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.

CHECK if INFO Provider has values for the same. If yes, then check the formula in CASE of CKFs or check the SELECTION parameters/filters etc in query.

Check if Info Provider has values for the same. If yes, then check the formula in case of CKFs or check the selection parameters/filters etc in query.

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.

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.

The term CELL in the FUNCTION of DEFINING EXCEPTION Cells is the intersection of the two structure elements.

The term CELL in the function of Defining Exception Cells is the intersection of the two structure elements.

They are a combination of CHARACTERISTICS and KEY figures (BASIC Key Figures, Calculated Key Figures (CKF) and RESTRICTED Key Figures(RKF))

They are a combination of characteristics and Key figures (Basic Key Figures, Calculated Key Figures (CKF) and Restricted Key Figures(RKF))

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).

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).

PROCESS chains which are CLUBBED together are called a Meta Chain. Each SUB chain is triggered only when the PREVIOUS Process Chain is SUCCESSFUL.

Process chains which are clubbed together are called a Meta Chain. Each sub chain is triggered only when the previous Process Chain is successful.

Value fields comprises of data which CO-PA GETS from various MODULES in R/3. Whereas KEY figures are derived from these value fields.

Value fields comprises of data which CO-PA gets from various modules in R/3. Whereas key figures are derived from these value fields.

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.

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.

YES, CO-PA is DELTA CAPABLE.

Yes, CO-PA is delta capable.

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.

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.

An organizational structure that combines CONTROLLING AREAS TOGETHER in the same way as controlling areas group COMPANIES together.

An organizational structure that combines controlling areas together in the same way as controlling areas group companies together.

KEB0

KEB0

The CO/PA partitioning is USED to decrease package SIZE (eg: company CODE)

The CO/PA partitioning is used to decrease package size (eg: company code)

No, we cannot, there are no HIERARCHIES in CO/PA.

No, we cannot, there are no hierarchies in 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.

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.

For EASIER PARALLEL SEARCH and LOAD of DATA.

For easier parallel search and load of data.

This is only the EXTRACTION mechanism for LOGISTICS other than LIS and SAP is not RECOMMENDED LIS extraction

This is only the extraction mechanism for logistics other than LIS and SAP is not recommended LIS extraction

It is a METHOD used in DELTA update methods which are based on CHANGE log in LO.

It is a method used in delta update methods which are based on change log in LO.

It ADDS the SELECTION CRITERIA to the LO EXTRACTION.

It adds the Selection Criteria to the LO extraction.

It is a technique to extract LOGISTICS INFORMATION and CONSISTS of a series of a standard extract structures DELIVERED in the business content.

It is a technique to extract logistics information and consists of a series of a standard extract structures delivered in the business content.

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.

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.

Scheduling of data LOAD means to schedule the loading of data for some particular date and time. It can be DONE from the SCHEDULER TAB on CREATE InfoPackage. Data Loads are monitored using transaction RSMON.

Scheduling of data load means to schedule the loading of data for some particular date and time. It can be done from the scheduler tab on Create InfoPackage. Data Loads are monitored using transaction RSMON.

MULTI Provider can combine VARIOUS INFO Providers for reporting PURPOSES. We can extract data from an ODS, Info Cube, Info Set, Info Object, ETC in any combination.

Multi Provider can combine various Info Providers for reporting purposes. We can extract data from an ODS, Info Cube, Info Set, Info Object, etc in any combination.

Tuning is DONE to increase EFFICIENCY. It is done to lower time for:

• LOADING data into Data TARGET
• Accessing a query
• For drilling down in a query, ETC

Tuning is done to increase efficiency. It is done to lower time for:

We can enhance the Business Content by adding FIELDS to the Extract STRUCTURES delivered by SAP BC. We may need to enhance the BC because we need to provide fields which are not already in the BC as per the customers needs. Eg: you have a customer InfoCube (in BC) but your company uses attribute for say APT number. Then instead of constructing the whole InfoCube you can ADD the above field to the existing BC InfoCube.

We can enhance the Business Content by adding fields to the Extract Structures delivered by SAP BC. We may need to enhance the BC because we need to provide fields which are not already in the BC as per the customers needs. Eg: you have a customer InfoCube (in BC) but your company uses attribute for say Apt number. Then instead of constructing the whole InfoCube you can add the above field to the existing BC InfoCube.

When the data in the InfoCube is not going to change ever and if it is occupying a lot of space then we COMPRESS the InfoCube. The data that is compressed cannot be ALTERED or deleted except through selective DELETION, hence we have to make an informed decision on compression. This compression can be done through process CHAIN and also manually.

When the data in the InfoCube is not going to change ever and if it is occupying a lot of space then we compress the InfoCube. The data that is compressed cannot be altered or deleted except through selective deletion, hence we have to make an informed decision on compression. This compression can be done through process chain and also manually.

INDEXING is a process by which the ADDRESS of DATA is stored. It helps EASIER ACCESS to the data.

Indexing is a process by which the address of data is stored. It helps easier access to the data.

DATA Integrity is about eliminating DUPLICATE ENTRIES in the DATABASE and achieve NORMALIZATION.

Data Integrity is about eliminating duplicate entries in the database and achieve normalization.

Yes

Yes

PROFILE GENERATORS.

Profile generators.

After IMAGE

After image

No

No

TWO in R/3 and Two in BW

Two in R/3 and Two in BW

• Basic CUBE,
• Virtual Cube
• REMOTE Cube
• SAP Remote Cube
• Virtual Info Cube with SERVICES

The VOLUME of data one data TARGET HOLDS(in no. of RECORDS)

The volume of data one data target holds(in no. of records)

In PSA table.

In PSA table.

ACCESS, INFORMATICA

Access, Informatica

Yes. For EXAMPLE, for LOADING TEXT and HIERARCHIES we use different DataSources but the same INFOSOURCE.

Yes. For example, for loading text and hierarchies we use different DataSources but the same InfoSource.

Yes.

Yes.

You can DELETE it by the REQUEST ID.

You can delete it by the Request ID.

DISPLAY attribute is one which is used only for display purpose in the report. Were as NAVIGATIONAL attribute is used for drilling down in the report. We don't need to MAINTAIN NAV attribute in the INFO Cube as a CHARACTERISTIC (that is the advantage) to drill down.

Display attribute is one which is used only for display purpose in the report. Were as navigational attribute is used for drilling down in the report. We don't need to maintain NAV attribute in the Info Cube as a characteristic (that is the advantage) to drill down.

InfoCube is structured as per EXTENDED Star Schema with the fact table surrounded by different DIMENSION TABLES which connect to SIDs. And the data can be aggregated in the InfoCubes. ODS is a flat structure and does not use the star schema concept and has DETAILED data in transparent tables.

InfoCube is structured as per Extended Star Schema with the fact table surrounded by different dimension tables which connect to SIDs. And the data can be aggregated in the InfoCubes. ODS is a flat structure and does not use the star schema concept and has detailed data in transparent tables.

In NUMBER of RECORDS

In number of records

Depending on the type of REPORT the data is stored in Info Cube or ODS. BW is used to store high VOLUMES of data and faster reporting. Info Cube is used to store normalized data. Master Data and TRANSACTION data are stored in Info Cube as per the Extended Star Schema USING SIDs. The reporting is fast.

ODS stores data in more detail utilizing its structure of transparent tables. Reporting on this will be SLOW. ODS is better used for RRI.

Depending on the type of report the data is stored in Info Cube or ODS. BW is used to store high volumes of data and faster reporting. Info Cube is used to store normalized data. Master Data and transaction data are stored in Info Cube as per the Extended Star Schema using SIDs. The reporting is fast.

ODS stores data in more detail utilizing its structure of transparent tables. Reporting on this will be slow. ODS is better used for RRI.

Initially we study the business process of client, like what kind of data is flowing in the SYSTEM, the volume, CHANGES TAKING place in it, the analysis done on the data by USERS, what are they expecting in the future, how can we use the BW functionality. Later we have meetings with business analyst and propose the data model, based on the client. Later we give a proof of CONCEPT demo wherein we demo how we are going to build a BW data warehouse for their system. Once we get an approval we start requirement gatherings and building your model and testing follows in QA.

Initially we study the business process of client, like what kind of data is flowing in the system, the volume, changes taking place in it, the analysis done on the data by users, what are they expecting in the future, how can we use the BW functionality. Later we have meetings with business analyst and propose the data model, based on the client. Later we give a proof of concept demo wherein we demo how we are going to build a BW data warehouse for their system. Once we get an approval we start requirement gatherings and building your model and testing follows in QA.

SAP SOLUTION to integrate all relevant BUSINESS processes on the Internet. mySAP.com integrates business processes in SAP and non-SAP SYSTEMS seamlessly and provides a COMPLETE business environment for ELECTRONIC commerce.

SAP solution to integrate all relevant business processes on the Internet. mySAP.com integrates business processes in SAP and non-SAP systems seamlessly and provides a complete business environment for electronic commerce.

It might not be the same. It depends on the EXTRACTION PROGRAMS USED on the source SYSTEM SIDE.

It might not be the same. It depends on the extraction programs used on the source system side.

Depending on work load on BW side and source system side LOADING time VARIES. Typically it takes half an hour to load a MILLION RECORDS.

Depending on work load on BW side and source system side loading time varies. Typically it takes half an hour to load a million records.