SAP BO Interview Questions and Answers
Question.1 What is a filter?
Answer: A filter, as the name suggests, is used to apply a condition to get specific or “filtered” data in the report.
A filter can be applied either at the universe level or at the report level.
Filter at the report, the level is nothing but “hiding the data”.
Filter at Query panel is nothing but ” filtering the data at DB/DW level”.
Question.2 When any new universe changes are deployed how does the end user get the view of the new classes/objects added(apart from specs doc)?
Answer: When universe gets changed, we do export the changed universe to the enterprise server, user gets the view of changed classes objects whatever we done at universe and already existed objects which are not changed are viewed as same like before.
Question.3 When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
Answer: There is an option in business object scheduler in which we need to give the email id’s of the user who wants the reminder when the report has been refreshed…This is the way the BCA will get to know about which users wants which report.
Question.4 what is import wizard and its purpose ?what is publishing wizard and its purpose?
Answer: Import wizard is a tool that helps in migrating the reports from elder version of BO to a newer one. Generally, BO G.5 reports are migrated to Deskl or BO XI R2. Though migration of reports could be done manually. Publishing wizard is used to publish or export a report into the desired repository.
Import wizard has many uses For converting older version reports to new version For creating the BIAR file For sending or exploiting the reports within the organization by using the ems name ,user, password
Publishing wizard is used to publish or export the agnostic documents like pdf, ppts to the info view.
Import wizard used to move one environment another environment i.e., development to production
suppose you have developed universe, report then u have compressed this BIAR file after the BIAR file sent production users then can convert to BIAR to actual files (universe, reports) so that we can also use import wizard method.
Publishing wizard we can export locally reports to public folders in CMC.
Question.5 How can i schedule the reports in BOXIR2?
Answer: They can change the connection for the report rl. For webi reports in query panel on left side we have query properties there we can change the connection of the universe to u2.then it will map to the u2.
Suppose you have development universe(Ul) and production universe(U2) then u have develop first sample report based on Ul universe after you have move this report in production system using import wizard then change universe connection U2 after it works fine, if any changes objects in any of universe then you get error.
2.suppose you have admin right then u can schedule in cmc other wise u have schedule right then schedule the reports.
we can change the connection of a particular report in the report level option tools- >view data->Browse of universe option, here we can change the connection of the report and we connect to any valid universe.
Question.6 I have a column contains a data like A,A + ,A+ + ,B,B+ + how u going to sort their data?
Answer: using custom sort in report, where one can define the sort sequence.
Question.7 Who r the users in B.O.XIR2?
Answer: In BoXIr2 there are no standard or specific users. Once you install the product you will get two default groups ie; every one and administrator. And one default user as administrator. We can create our own users and groups. But all the users we create should be in the everyone group including the administrator.
Question.8 What is meant by ZABO and FC(full-client)?
Answer: This module of the application is hybrid of the thin client and the Full Client Modules of Business Objects Reporting Module. ZABO stands for Zero Administration BusinessObjects. This application uses the hardware resources of the client machine for application level processing and communicates through the protocol defined for the browser to use the server resources for processing External requests (like running a database Query, creating a data provider to access data.)
ZABO means Zero Administration Business Objects and this is 3-tier level architecture.
No need to install any BO software.
Full Client means 2 -tier level architecture we can directly connect to repository only we defines key file and this Fullclient we need BO tools our local system also.
Question.9 What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
Answer: The main difference between them is if the loop is formed between 1 fact table and 2(0r more dimensions tables, then create an alias for existing dimension tables, if loop constitutes more than one fact table then, in this case, go for contexting.
Contexts and Aliases are means to resolve loops/traps in universe designs. Contexts are used to specify which of the paths should be used when more than one path is possible from one table to another in a loop. Contexts are used in the scenarios where two or more many-to-one joins converge on a single table. Whereas Aliases are used to resolve the loops by duplicating the table and defining separate paths when one-to-many join links to a table which is again linked to another one-to-many join.
Question.10 What is crystal reports? how to migrate them?
Answer: Mainly the source of crystal report is Business view. It generates the reports daily basis.
Question.11 What happens if cardinalities are not resolved?
Answer: If Cardinalities are not specified between the tables i.e. the relationship between the tables ( 1-1,1-MANY,MANY-MANY) We get more results at report level more than the actual result, like a Cartesian product.
We can’t detect the Loops & Traps (Chasam & Fan) Which are mainly detected by the CARDINALITIES option so it should be Identified.
Cardinalities are called relationship, you given the tables relationship 1-1, 1-many, many-1, many-many relationship (which is suitable for that area) give the correct once check the check integrity button.
Question.12 What is the difference between Thin client & thick client?
Answer: Thin client we can also called as Web Intelligence where as thick client also called as desktop intelligence. The main cliff b/w thin & thick client, in webl, we can create reports using only universe but using Deski we can create reports by using data providers are XML data provider, VB application, universe, stored procedure, database, sap r/3 etc
Thin Client is a browser based version, whereas thick client is a desktop based version. In thick client, you have lot of functions and formatting options.
Question.13 How a report will burst into .pdf files?
Answer: Give File -> Save-As in PDF format.
Question.14 Is import wizard, report conversion tool, report comparison tool, security viewer all r migrating tools. whether all the tools are available in BOXIR2? In BOXIR2
Answer: We have below tools only
Import Wizard Report Conversion Tool Repository Migration Wizard
Import Wizard used to migrate the reports/ users/ universe connection etc.
Report Conversion Tool(RCT) is used to convert the Deski reports to Webl Reports
there is no Report Comparison tool, n Security Viewer present in XIR2.
Question.15 What is the difference B/W Variable ft Formula what is meant by incompatible object error in the report level?
Answer: Whenever we execute the formula, the result will be stored in the variable.
When the contexts are not properly defined we will get the error as incompatible combination of objects.
Question.16 In a report i want to fetch the data from 2 data Providers, which condition will satisfy to link the 2 data providers.
ex: Q1 have columns A,B,C
Q2 has a X,Y,Z columns.
requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.
Answer: In BOxir2 wise it is possible, would you have base uni ft dervied uni’s, i think your requirement is solve by go for deski, select “datamanager” –> click “link to”
Option it is possible. After use using “combining query” option ft just select “union” operator wise your query is solve.
another wise you go for webi, select “MERGE” option it is possible.
otherwise, your requirement is not possible, because your columns names are not matching.
in BOxir2 wise it is possible, would u have base uni ft derived uni’s, i think your requirement is solve by using “combining query” option & just select “union” operator wise your query is solve.
another wise you go for webi, select “MERGE” option it is possible.
otherwise, your requirement is not possible, because your columns names are not matching. You go for deski, select “datamanager” –> click “link to” Option it is possible.
You can do a trick. Suppose you have different objects in two data providers (lets say dpA and dpB),dpA have product related objects for example product code, product name etc and dpB have customer related objects. You drag a object from a dp, let’s take dpA. Now when you try to drag a object from dpB you will not be able to do that. For this , go to the tool bar->view data->definitions-> link the object you want to drag(say customer name from dpB) with any object from dpA ->select Ok. Now you will be able to drag the customer name from dpB. You will see that data displayed in the report is not correct .
To view data and unlink the objects->select Ok. Now you will get the correct data in the report.
Question.17 What is meant by For each For all function. In which case we use the option in BO?
Answer: For each-add all objects to the context for all-delete all objects from the context we use for all for summary purpose and for each for detail purpose
for all: — while using measure objects will inserted(o/pcontext) for each: – while using dimension object will inserted (I/pcontext)
these above 2 conditions are using in calculation context.
= sum(<revenue> foreach(<year>,<city>)) forall(<year>)
Question.18 If we want to take a report 10 records per page. How to take it? is there any paging option in BO?
Answer: go for “format tables” option.
Question.19 In xir? how to send reports to end user?
Answer: You can send reports to any user via the scheduling options for a report. The report will then run as per the scheduled options and when successful!, it will send a copy to the user’s email address or inbox (in BO), depending on the options selected.