SAP BW Course in Pune

1. Can you create a data storage area in the SAP BW?

Yes, this is possible and generally, it is called Infocube. There are generally two tables that are present in it and they are called as Dimensional Table and the Fact Table.

2. Can you name a few important tasks which are essential in the data warehousing and management of the same?

• Collection integration, as well as management of the data and the concerned tasks
• Making effective plans and analyzing the situations with the help of data stored
• The next important task is reporting. There are many tools in the SAP BW application that are useful in this matter and enable users to keep up the pace even when the data is present on the browser or in excel.
• The next important module is to assure broadcast publishing 
• Making sure of security is the next big thing as privacy always matters for any business when it comes to dealing with the data whether structured or unstructured

3. What exactly do you know about the term Data Flow in Business Intelligence or Business Warehouse?

It defines the path adopted by the data and how it reaches from one specific location to another in a domain or in a warehouse. There are various rules and regulations that govern the control over the same. Generally, the flow is from a transactional to an analytical system.

4. Name a few transaction codes that can be deployed for the process chain without any restriction?

These are Process Chain Display, Monitor Daily Process, and Process Chain Maintenance

5. What is the Process chain and when you can use the same in the Data Warehouse?

It is basically an approach that is useful when it comes to automating the loading process of the date. Several important processes such as Indices, Data Load, as well as deletion can be automated provided some basic conditions are met and the best thing is the users don’t have a lot of concern with the type of data you generally make use of.

6. Name any two important Transaction codes used for the purpose of providing the information?

These are:

  1.LISTSCHEMA
  2. LISTCUBE

7.Is it possible for the users to convert the package group into a Process Chain? If so, how?

Yes, this can be done easily. For this, the user has to first make double-click on the group defining the info. Next is to open the Process Chain Management option from it. After this, the users have to type the name and the description post and the task is done automatically.

8.While handling some important tasks in the Business Warehouse, what if the Info providers required are not sufficient? What would be your action?

Well, in such a situation, it is possible for the users to simply use the Info-objects as Info-providers.

9. Can you tell me something about the Multi-provider in the SAP and how it is useful for the users?

It is basically an info-provider that consists of data from the info-providers used for other tasks. One of the main aims of this is to make sure that data remain available reliably for reporting purpose. Some of the things that make it useful for the users are:

1.The source of data is from the Info providers that are dedicated to a specific task. 
2. They themselves don’t contain any sort of data present in them
3. There are basic union operators which make sure that the Info-providers remain connected to one another
4. They are useful in assuring effective reporting and making sure they can be run anytime for testing or any other purpose

10.In a transport organizer, how you can unlock an object?

The users need to open the SEO3a Request Task File and from where the restriction can be removed.

11.Name two types of Multi providers and compare them to each other?

These are Homogenous and Heterogeneous. In homogenous, there are info-providers that are similar to one another in terms of all their technical specifications and other technical details. They can also have similar key figures and characteristics.

On the other side, Heterogeneous are the ones which are ones which have only a limited number of identical characters as well as key figures. It can be used for modeling while the homogenous cannot be considered for this task. All the scenarios can easily be divided into sub-categories and have their own dedicated info provider.

12.What exactly do you know about the Business Warehouse statistics?

There are a number of cubes present in the SAP and they are considered for the purpose of measuring the performance of data loading and query handling. All the data in the Warehouse can be shown or can be displayed with the help of this approach. Generally, it keeps an eye on the overall time queries take to accomplish a task or how quickly they are responded to.

13.What is compression in the Data Warehouse?

It is basically a procedure that is considered for the purpose of eliminating the additional IDs. Its main aim is to make sure that the maximum space remains available in the warehouse so that the maximum amount of data can be stored. A compression is basically a useful approach with the help of which the users can make sure that no duplicate or unused IDs exist in the warehouse environment which can sometimes slow down the system performance.

14.What do you mean by the term Rollup in the SAP BW?

Generally, this approach is considered when it comes to packing the new data packages in the Info-cubes. This is generally done because the entire data in the Infocube doesn’t remain available during the reporting processes.

15.What is Dashboard in SAP BW and how it is created?

It is basically a collection of views, groups, as well as reports. It can also be considered as a graphical reporting interface. It is possible to create the same with the help of a Web Application Designer. The entire content can be displayed on a screen quickly.