Interview Questions.

Question 1. What Are Some Of The Common Bi Report Types?

Answer :

Analytical reports
Operational Reports
Dashboards
Question 2. What Is A Dashboard?

Answer :

A series of summarized reviews is called dashboard. In other words a dashboard is surely an prepared way to observe numerous KPIs immediately.

SAP BI Interview Questions
Question three. What Is A Hierarchy?

Answer :

Group of related dimension objects is called measurement hierarchies. An example of a dimension hierarchy is Geography, that can include City, Region, and Country. (Hierarchy is an ordered collection of related dimensions, which may be used, in multidimensional evaluation) Good examples of hierarchy are geography and time.

Question 4. Pick Five Available Data Sources For Webi Reports?

Answer :

No Data Source
Universe
Accel
Bex
Analysis View
Web Services
SAP BI Tutorial
Question 5. What Are Some Of The Best Practices In Creating Reports?

Answer :

Limit the number of Data Providers Used

Push down operations towards the Database/Universe which means that

Retrieve aggregated data as opposed to aggregation within the record

Do not (by accident) disable the cache mechanism of Web Intelligence

Web Intelligence has a top notch caching mechanism for files that have already been viewed. Using Cache improves the load time of documents; however there are some features within Web Intelligence in an effort to prevent using the Cache. 

These features are:

Current Time ()
Current Date ()
Username ()
Avoid Auto-Fit When viable
Avoid Charts with a excessive quantity of Data Points
Limit use of “Scope of Analysis”
Build lean reports with the aid of having as little calculations as possible.
Use Query filters instead of Report Filters
Ensure Query Stripping is utilized
SAP WM Interview Questions
Question 6. Your Client Has A Weekly Sales Report And Wants To Know Whether There Was A Decrease Or An Increase In The Current Week’s Sales Compared To The Previous Week. Can That Be Done In Webi? If So How?

Answer :

Yes, you will try this by means of permitting Data Tracking.

Question 7. How Does Data Tracking Work?

Answer :

Data monitoring follows the subject of formatting regulations with a distinction, this is, its formatting results are decided with the aid of comparing  unique results.

With statistics tracking, we can analyze changes through the years and are able to track increments and decrements of changes along measures and measurement values.

SAP WM Tutorial SAP BO Interview Questions
Question eight. What Different Operators Available To Combine Queries In Webi?

Answer :

Union, Intersection, Minus.

Question 9. What Is The Purpose Of Scope Of Analysis Panel In Query Panel?

Answer :

It is used to do additional evaluation
It is used to do drill down on information
It is used to analyze detail of facts
SAP BASIS Interview Questions
Question 10. What Is The Difference Between A Sub Query And A Combined Query?

Answer :

A subquery is a only a question inside a query, whereas a combine queries are two or more queries joined collectively to form a end result set.

SAP BO Tutorial
Question 11. What Is A Universe?

Answer :

Universe is a semantic layer that suggests presents customers access to database in a business pleasant manner.

SAP BusinessObjects Cloud Interview Questions
Question 12. Where Is Data Tracking Enabled?

Answer :

By navigating to the Analysis toolbar after which to the Data Tracking tab, we can be able to adjust the data tracking options.

SAP BI Interview Questions
Question 13. What Are The Two Prerequisites Of Passing Parameters Between Reports?

Answer :

We require a not unusual value that the grasp report can skip to the goal document, that's the same as in merged statistics companies. The fee wishes to be inside the equal kind (for example, numeric to numeric item)
In this approach, we require that the goal report may have a set off circumstance as a part of its query filters; this activate features because the touchdown region of the fee being passed from the grasp file.
SAP BASIS Tutorial
Question 14. How Does Web Intelligence Work?

Answer :

Web Intelligence presents commercial enterprise users an smooth to use interactive and bendy user interface for building and studying reports on company information over the internet, on secured intranets and extranets. The Web Intelligence software program is established via your administrator on an internet server for your company community. To use Web Intelligence from you neighborhood pc, you log into the commercial enterprise intelligence portal Info View thru your Internet browser. Then, relying on your protection profile, you may interact with the reviews in corporate files or edit or construct your personal files the usage of a Web Intelligence record panel or question panel.

Question 15. What Are Different Tools Used To Create Or Edit Web Intelligence Reports?

Answer :

You can create or edit Web Intelligence documents the use of one of several equipment:

Java Report Panel
Query – HTML
HTML Report Panel
SAP BPC Interview Questions
Question sixteen. How Is Web Intelligence Java Report Panel Designed?

Answer :

The Java Report Panel is designed for customers who want extra flexibility with designing report format and defining formulas and variables. A graphical Formula Editor allows you to build formulation rapidly using drag-and-drop.

Note: The Web Intelligence Java Report Panel is to be had in case your administrator has deployed Web Intelligence in ASP mode and in case your administrator has deployed Web Intelligence in JSP mode.

SAP BPC Tutorial
Question 17. How Is Web Intelligence Query- Html Designed?

Answer :

Designed for users requiring a natural HTML environment to build records providers, Web Intelligence Query – HTML gives the capability to outline the information content of files on a couple of facts resources. You can use Query – HTML to create new files from scratch or edit the records companies in documents created the usage of any of the other Web Intelligence equipment.
Used together with On-Report Analysis, Query – HTML provides a whole solution for building records providers and designing effective reviews in a natural HTML environment. Once you have got run the facts carriers to generate a standard file, you can leverage Web Intelligence On-Report Analysis capabilities to format multiple reports, add formulation, and create variables.
Note: Web Intelligence Query – HTML and On-Report Analysis in Interactive view format are only available, in case your administrator has deployed Web Intelligence in JSP mode.

SAP BODS Interview Questions
Question 18. How Is Web Intelligence Html Report Panel?

Answer :

Designed for users who want to construct primary reports, the HTML Report Panel presents question and report capabilities in a simple wizard-like interface. Each file is based on a unmarried statistics supply and might incorporate a couple of reports, showing specific subsets of facts. In addition, the HTML Report Panel is 508 compliant and can be custom designed for specialized deployments.

Note: The Web Intelligence HTML Report Panel is most effective available, in case your administrator has deployed Web Intelligence in JSP mode.

SAP WM Interview Questions
Question 19. What Information Do You Need Before Logging Into Info View?

Answer :

Before you could use Info View and Web Intelligence you want the subsequent facts:

A URL to the Info View server.
The Info View server call and port quantity.
Your login and password.
Your authentication, which controls the Info View assets available to you.
SAP BODS Tutorial
Question 20. What Are The Two Ways In Which Data In The Web Intelligence Document Is Edited?

Answer :

There are two approaches to open a Web Intelligence record in edit mode:

View the record first after which switch to edit mode.
Switch to edit mode at once with out viewing the file contents first.
SAP Webi Interview Questions
Question 21. What Are Data Providers?

Answer :

A facts provider contains one or greater queries that return statistics from a database. A query requests facts from the database. If the data is available, then the requested facts is again by way of default inside the shape of a desk which includes rows and columns. When you build a question, you're developing a request for facts from a database. A request may be quite simple, as an example; supply me total sales in California for the first quarter of final yr, or greater complicated, as an instance; provide me an average age of clients who offered sweaters for the duration of the spring tv advertising in Paris.
Queries are despatched to the databases in a language called SQL (Structured Query Language). However, when you operate Web Intelligence you do no longer must recognize any SQL. The Web Intelligence file panel gives the information to be had within the database as objects which have names and meanings acquainted to you. These objects are prepared in a structure referred to as a universe.
You construct records vendors by using combining gadgets in a universe. The universe interprets the objects supplied to your business language to SQL, after which sends the request for facts to the database. Web Intelligence can generate SQL data carriers of limitless duration. When the information is again to the Web Intelligence report panel, it's far presented in a desk shape, with columns which have the identical names as the objects that you used inside the question. The records is organized in rows.
Question 22. What Is Scope Of Analysis?

Answer :

The scope of analysis for a question is greater facts that you could retrieve from the database to give greater information at the statistics back by means of every of the items in a question. This greater facts does not appear inside the preliminary end result record, however it stays available in the information cube, so that you can pull this records in to the document to will let you get right of entry to extra element at any time. This process of refining the records to lower tiers of detail is called drilling down on an item.
In the universe, the scope of evaluation corresponds to the hierarchical stages beneath the item selected for a question. For instance, a scope of evaluation of 1 degree down for the item Year, would encompass the item Quarter, which appears right now beneath Year.
You can set this degree when you build a question. It lets in gadgets lower down the hierarchy to be covered inside the question, without them appearing within the Results Objects pane. The hierarchies in a universe can help you select your scope of analysis, and correspondingly the extent of drill to be had.
You can also create a custom scope of evaluation with the aid of selecting precise dimensions to the Scope of Analysis pane.
Note: You cannot define a scope of analysis while running in Query Drill mode. Query Drill defines the scope robotically in reaction to drill movements.

SAP Webi Tutorial
Question 23. What Is The Functionality Of Cube?

Answer :

The scope of analysis for a question is more records that you could retrieve from the database to provide greater information at the information returned with the aid of each of the objects in a query. This more records does now not appear inside the initial end result record, but it stays available within the statistics dice, so that you can pull this data in to the record to permit you to get admission to greater detail at any time. This procedure of refining the information to lower degrees of element is known as drilling down on an object.

When you run the question, the scale protected within the scope of analysis are back to the cube for that record, however are not projected onto the reviews that the document consists of. They may be added to the reports at any time, without having to run the question again. Values for the size inside the scope of evaluation can also be viewed with the aid of switching a record to Drill mode, and then drilling all the way down to them from the values displayed at the record.

SAP Web Dynpro Interview Questions
Question 24. What Is An Ambiguous Query?

Answer :

An ambiguous query is a question that contains one or extra objects which can doubtlessly return two exclusive types of statistics. In a universe, positive dimensions may have values which are used for two different purposes within the database.

For example, the [Country] measurement inside the question beneath can go back two varieties of information:

Customers and the u . S . A . In which they spent their holiday.
Customers and the us of a for which they've made their reservation.
The function that Country plays in this query is ambiguous. A country cost can be either the u . S . Wherein a vacation become sold, or a country in which a vacation is reserved. One is present records (income), and the alternative is destiny records (reservations). To avoid ambiguities in a question, the universe designer identifies the special ways that items may be used within the universe, and implements restrictions on how these gadgets may be blended. These restrictions are known as contexts.

SAP BO Interview Questions
Question 25. What Is A Context?

Answer :

A context is a described institution of gadgets that percentage a common enterprise reason. This enterprise reason is typically the form of data that these related gadgets represent. For instance, a sales context is a grouping of all the gadgets that may be used to create income information vendors. A reservations context is a grouping of all of the gadgets that can be utilized in reservation records companies. Contexts are defined in a universe with the aid of the universe designer.

You can combine any object within the equal context to create a query. You can also combine objects in distinctive contexts. If you operate an item that is not unusual to each contexts, Web Intelligence will try and determine the context that pleasant suits the other items in the query.

SAP Web Dynpro Tutorial
Question 26. What Are Incompatible Objects?

Answer :

Sometimes it isn't always feasible to use positive mixtures of gadgets in data carriers. This situation arises whilst gadgets undergo no courting to each other. These items are known as incompatible gadgets.

For example, the Island Resorts Marketing universe consists of the [Reservation Year] and [Revenue] items, that are incompatible. This is due to the fact there is no revenue associated with a reservation. Revenue is generated best while the client is invoiced. The underlying database structure displays this; you cannot construct a question that aggregates revenue by way of reservation year because there is no such issue as revenue by means of reservation 12 months. In different phrases, the aggregation context that you special for the [Revenue] object does no longer exist.

When you build a query, Web Intelligence generates SQL backstage. This SQL is administered in opposition to the database to provide a end result that Web Intelligence presentations in a file. For a question to be free of incompatible gadgets, Web Intelligence ought to be able to generate a single SQL query to retrieve the information. If this is not possible, the question consists of incompatible gadgets.

SAP Modules Interview Questions
Question 27. How Can Queries Be Combined And What Is The Use?

Answer :

You can integrate queries in 3 relationships:

Union
Intersection
Minus
In a union combination, Web Intelligence takes the all of the facts from each queries, gets rid of reproduction rows, and builds a combined data set.

In an intersection aggregate, Web Intelligence returns the facts this is common to each queries.

In a minus mixture, Web Intelligence returns the information inside the first query that doesn't appear inside the second.

SAP BASIS Interview Questions
Question 28. What Is Purging?

Answer :

When you purge data from a document you cast off all information from the file, while leaving the report structure intact. If the document consists of more than one records companies, you could purge unique information carriers within the report.

SAP BO Analysis Edition For OLAP Tutorial
Question 29. What Is The Different Table Templates Used In Web Intelligence?

Answer :

The exclusive desk templates you may use to show records on Web Intelligence reports:

Vertical tables: Vertical tables display header cells on the top of the table and the corresponding statistics in columns.
Horizontal tables: Horizontal tables display header cells at the left of the table and the corresponding statistics in rows.
Crosstabs: Crosstabs are beneficial for providing effects that correspond to the intersection of  or greater dimensions.
Forms: Forms are useful in your report in case you need to show targeted facts according to purchaser, product, or partner. For instance, a shape is a beneficial manner of displaying individual purchaser statistics with statistics including the customer account, call, cope with, and so on.
SAP BDC Interview Questions