SAP - BO(Business Object) Digital Skill (TrendNXT L1)

Note: Kindly prepare yourself to score good marks in SAP BO. This is for TrenDNXT level 1 dumps.

1) SAP BO client run on 64 bit only
A. A.SAP BO server run on both 32 and 64 bit
B. B.SAP BO client/server both run on both 32& 64 bit

Ans: Bo server only 64 bit, client on both

2) How to synchronize the data from two different data sources
Ans: Merge Dimension.

3) APS run on
A. Oracle JVM
B. SAP JVM
C. none of the above

Ans: SAP JVM

4) Which is called as Canned report
A. Canned Report- Financial Analysis
B. other option

Ans: Canned reports are predefined reports.

5) Which is called as Crosstab report
Ans: standard report

6) Use of Derived table
Ans: For Complex calculation and functions
                      Or
 A derived table is defined by an SQL query at the universe level that can be used as a logical table in Designer.

7) Use of OpenDocument in webi
A. To open a document from start command line
B. To open two webi report
C. To save the sessions of the report
D. None of the above

Ans: For linking to Webi docs

8) Rank function is not used for the following
A. Retrieve TOP 10 list of customers
B. Retrieve BOTTOM 10 list of customers
C. Retrieve TOP 20% list of customers
D. none of the above

Ans: Retrieve top 20% list of customers.

9) Risk of overloading server, n/w, Client PC avoided by
A. SQL Aggregate
B. Projection Aggregate
C. Cumulative Aggregate
D. All of the above
Ans: SQL Aggregate.

10) which is true
A. Report filter is used to restricting data from data source
B. Query filter is used to restricting data from data source
C. Report filter and query filter is used to filter the data in the data source
D. none of the above

Ans: Query filter is used to restricting data from data source

11) Input, Output Server File Repository maintenance
A. Output Server File Repository maintain the target file instances
B. Input Server File Repository maintain the target file instances
C. Output Server File Repository maintain the target file instances and  input Server File Repository maintain the source files and reports
D. none of the above

Ans: 3rd option

12) which is not true
A. Input control can be applied to a specific section in a report
B. Input control cannot be applied to a specific section in a report
C. Input control can be applied to a column in a report
D. Input control can be applied as a filter

Ans: Input control cannot be applied to a specific section in in a report.

13) UDT can be used only when
A. Linked universe
B. Stored procedures as data source
C. Web Intelligence 3.x and Live office

Ans: All of the above

14) Folders in IDT in designer is
A. Classes
B. Objects
C. Measures
D. None of the above

Ans: Classes

15) Which can be used as an internal function without reusing the query
A. @select
B. @prompt
C. @where
D. none of the above

Ans: @select

16) Union of 2 queries can be done by
A. SET operator
B. Union clause
C. Combine

Ans: Combine query.

17) Extension Webi document
A. .wid
B. .rep
C. .xls

Ans: .wid

18) IDT can be done on
A. Local
B. shared
C. common
D. both local and shared

Ans: both local and shared.

19) Which is not true about connections

20) What is FAN TRAP?
A. Many to one join
B. one to many join
C. one to one
D. many to many

Ans: The Fan trap occurs when a “one to many” join links a table which is in turn linked by another “one to many” join. (ANS)

21) What is CHASM TRAP?
Ans: Chasm trap occurs when two “many to one” joins converge on a single table.

22) Following option is used synchronize data from two different data sources in webi
Ans: Merge data based on similar dimensions

23) which operation can be used to union of two queries
Ans: union

24) Difference b/w Break and section?

Break: is applied on whole block it gives you row at the bottom of block for subtotal. It breaks a whole report into the smaller groups according to your select column. When you apply a chart on this block it only gives you one chart because it is only single block.

Section: When you apply section on block it divides your report into smaller section and the column which you apply section will come out as a heading out of the block. When you apply chart on this block, every section have an individual chart for its own section.

25) Below tool is not a part of BO 4.0
A. Webi rich client
B. CMC
C. BI Launch pad
D. Desktop intelligence

Ans: remaining option

26) Difference between BO 3.1 & BO 4.0?
Ans:

27) ------------- option is used to eliminate usage SQL in business layer
Ans: Select, where

28) Business Layer query options, provides the facility to select multiple options, such as:
Ans: Query Limits:

a) Limit size of result set to __ rows.
b) Limit execution time to __ minutes
c) Warn if cast estimate exceeds __ minutes

Query Options:
a) Allow use of subqueries
b) Allow use of union, intersect and minus operations
c) Allow complex operands in query panel
d) Multiple SQL statements for each measure

29) UNX file consists of
A. connections
B. data foundation

Ans:all the above

30) What are differences between information design tool (IDT) and universe design tool (UDT)?
Ans:

• IDT is the new tool introduced in BI 4. Concept is same as UDT, but presentation is different.
• IDT (New Universe Designer in Business Objects) = combination of Business View Manager + Universe design tool + Data Federator

Differences:

• IDT is the new tool introduced in BI 4. Concept is same as UDT, but presentation is different.
• In IDT, they have Data foundation layer (instead of structure pane) and Business Layer (instead of Class n object pane). First of all, a project is created, then a relational or OLAP connection, then data foundation and then business layer. Then the universe is published as .unx
• We have structure pane and class n object pane in UDT. 
• UDT it is not possible.
• They have introduced the concept of ‘views’ in Data Foundation Layer. If you have many tables to be used in the universe, it would be difficult to manage joins and structure. So you can create multiple windows.
• For ex., one view or window would be related to client and all the related tables. Another window could be related to product and related tables, and another could be related to FACT and the main dimension tables. The master view would be the union of all these views.
• In UDT, you can add a table any time and then can drag it to object pane to create objects automatically.
• In IDT, automatic classes and objects are created only once when you create the Business Layer for the first time. After that, if you add any table, you have to create objects based on it manually.
• Identifying loops and creating contexts is not as clean in IDT as in UDT.

31) What are differences between UNV & UNX?
Ans:

 UNV 
- Supported by Webi ONLY
- Single Data source
 UNX 
- Supported by Webi, Dashboard, Crystal Enterprise & Explorer
- Connect to multiple data sources within ONE UNX

32) 26. detail object...which of the following is true/false

33) why should we disable LOV's(List Of Values) for attribute
A. as users will rarely use it as selection attribute
B. cannot use it as attribute selection
C. Rarely will user use attribute as condition

Ans: don't know (but you can reject above options)

34) Adaptive Processing servers
Ans: It is used for refreshing a report

35) Operator is not a part of combined query in Web Intelligence 4.0 : Difference
36) Adaptive Job Server - To schedule a report
37) Scope of Analysis: Scope of Analysis determines the additional objects to be included in the query so that the data will be available in drill mode. Before you can drill, you must use Scope of Analysis to select the objects to be retrieved in addition to those that were placed in the Result Objects.

38) Calculation Mode of Rank Functions : Count, Percentage, Cumulative Sum, Cumulative Percentage.

39) What is the prompts order in BO 4.1?
a) As you defined   
b) Ascending to Descending 
c) You can test the order

40) Where are the servers created in BO 4.1?
a) CCM         
B) CMC
c) CMS
d) Both A & B

Ans: Both A & B

41) What is the use of Report Application Servers?
Ans: Viewing in DHTML mode by

42) What is the use of Connection Server?
a) Connect to DB
b) Connect to Wi-Fi 
c) To connect deski Webi 3-Tier

Ans: To connect deski Webi 3-Tier

43) Which Right …???…    Have the high priority?
a) Desired             b) granted     c) not specified

Ans: Desired

44) Where can we create LOV’s in Universe?
Ans: Universe object

45) Use of merged dimensions?
Ans: To merge data from two data providers.
46) Common Dimension Merging

47) Query Scripting  is  used for
Ans: Report Performance

48) Types of filters
Ans: Query filter- Report Filter

49) Where can we enable Query Scripting?
Ans: Query Properties, Report Properties

50) Webi, Deski Reports are running, what will happen when Universe connection is exporting.
Ans: Will not run

51) What is alias?
Ans: Use of a table    b)Use of a view
52) Which can be auto detected in a Universe?
a) Cardinality b) Joins c) All of the above.

Ans: All of the above.

53) Currently Universe is using a DB, if you want to connect to Sybase then what happens?
Ans:  Below could be a checklist for you:

1. Make sure all tables with all used columns (used in report) have been created in new database.
2. Referential Integrity is at place.
3. The database user used to create connection has same privileges which you had in old reporting database.
4. Once new reporting database is ready, refresh universe structure and check if there is any change?
5. You also need to make sure the syntax used in the universe is as per new reporting database. For example: If I am shifting my reporting database from Oracle to Teradata, I will have to replace nvl() function with coalease() function wherever I have used in object definitions.
6. Once done, run integrity check and check if all joins and columns are in place and everything is parsing correctly.
7. You also need to create indexes (if created in old database) as their absence can affect performance issue.
8. Once satisfied with the universe, save it and export to repository.
9. Open any of the associated report and refresh and check if any issues.

54) Which Window Server Management tool is used to move, add, etc?
a) CMC    b) CMS   c) CCM

Ans: CMS

55) What is the Max Context in Universe?
a) 65            b) 150    c) No Restriction          d) 25

Ans: No Restriction

56) Tool to convert BO Deski Reports to Webi Reports?
a) Import Wizard b) Report Conversion Tool c) Report Comparison Tool   d) Business Viewing Tool

Ans: Report Conversion Tool

57) The Input Controls used in WEBI Reports are?
58) What is the Internal Function used in WEBI report ………….?
a) @Select    b) @where    c) @prompt     d) none

59) How can we get the union of two queries?
a) By SET Operator b) By using Combine queries button   c) by using Union of queries d) none

Ans: by using Union of queries

60) Desired   object features?
61) True about Universe object:
a.Designer buids into universe
b.centralised
c.error proof
d. all

62. To limit size of result set to 50000 parameter is used
a.LIMIT
b.SQL
c.CONTROL
d.LINK

63.True about Detail object in BO
a. Detail object attached to dimensions
b. Cannot drill on details nor link on details when linking on multiple data sources.
c.both a&b
d. none

64. Conditions
a. are applied  on query to restrict data from datasource
b.  on report to hide data which is already retrieved from datasource
c. both a&b
d none

65. New SAP BO 4.0 is
a. Parameter & LOV are not connected by default when BO is created
b. Ability to divide one business layer into multiple views
c. One universe access multiple data sources.
d. all

66 what is true
A SAP BO server run on both 32 and 64 bit but SAP BO client run only on 64 bits
b. SAP BO client run on both 32 and 64 bit but SAP BO server run only on 64 bits
c. SAP BO client/server both run on both 32& 64 bit
D. None

Ans: Bo server only 64 bit, client on both