Fan trap in bo LEARNOVITA

Get [LATEST] Boxi Interview Questions and Answers

Last updated on 26th Sep 2022, Blog, Interview Question

About author

Sanjay (Sr Big Data DevOps Engineer )

Highly Expertise in Respective Industry Domain with 7+ Years of Experience Also, He is a Technical Blog Writer for Past 4 Years to Renders A Kind Of Informative Knowledge for JOB Seeker

(5.0) | 13265 Ratings 1539

1. What square measure SAP Business Objects?

Ans:

Business objects will be thought-about as integrated analysis, coverage and questions for the aim of finding an answer to some business professionals which will be useful for them to retrieve information from the company databases in an exceedingly direct manner from the desktop. This retrieved data will be bestowed and analyzed among a document of business objects.

2. Justify the execs of victimization business objects?

Ans:

There square measure several blessings in creating use of business objects, and that they are:

  • User friendliness.
  • Familiar business terms.
  • Graphical interface.
  • Deployment of documents on associate degree enterprise basis by creating use of WebI.
  • Dragging and dropping.
  • Powerful reports for a lesser quantity of your time.

3. List out the various products associated with Business Objects?

Ans:

There square measure numerous sorts of product associated with business objects, and that they are:

  • User module.
  • Designer.
  • Supervisor.
  • Auditor.
  • Set analyser.
  • Info View.
  • Business Objects – package Development – Kit.
  • Broadcast Agent.

4. Outline Designer?

Ans:

The designer could be a module associated with Business Objects that is employed by the designers for making and maintaining universes. Universes will be thought-about as a linguistics layer which will isolate the top users from the assorted problems that square measure technical and associated with the structure of the information. Universe designers have the chance for distributing the universes to the top users when moving these as a file through the system of files or will be done by commerce the files to the repository.

5. What square measures the sorts of modes related to designer and business objects?

Ans:

There square measure particularly 2 totally different sorts of modes related to these platforms, they are:

  • Enterprise mode.
  • Workgroup mode.

6. List out the assorted sorts of strategies associated with two-dimensional analysis that square measure within business objects?

Ans:

There square measure 2 totally different strategies associated with two-dimensional analysis on the market within BO and these strategies are:

  • Slice & Dice
  • Drill down

7. List out the sorts of users related to business objects?

Ans:

Different sorts of users related to the business object are:

  • General supervisor.
  • Supervisor.
  • Graphical Interface.
  • Designer.
  • Supervisor Designer.
  • End User.
  • Versatile User.

8. What square measures the assorted information sources available?

Ans:

Business objects assist you in accessing the info from a range of sources. you’ve got the chance of getting information from RDBMS like Oracle, MS SQL server and IBM DB2.

9. Outline the sorts of information providers?

Ans:

There square measure numerous sorts of information suppliers on the market for the business objects, and that they are:

  • Stored procedures.
  • Queries over universe.
  • Freehand – SQL.
  • VBA procedures.
  • SAP.
  • OLAP servers.
  • Personal information files.

10. Outline Boxi architecture?

Ans:

11. Outline the drill mode?

Ans:

Drill could be a reasonable analysis mode related to business objects and helps in breaking down information moreover as in viewing information from all the doable angles and also the levels of detail for locating the issue that has caused a decent or a nasty result.

12. What’s a secured connection?

Ans:

Secured association could be a reasonable association which will be useful in overcoming the assorted limitations related to the previous connections. The rights associated with this type of association will be set over documents moreover as objects. Universes will be brought within the central repository solely by creating use of the secured association. The parameters relating to these associations are sometimes saved within CMS.

13. Outline an opening Trap?

Ans:

Chasm entice could be a condition that arises once the values within truth|the very fact|The actual fact} table gets inflated at the time of measuring the values from 2 totally different fact tables by considering the size within the dimension table.

14. However, will the opening entice be solved?

Ans:

Chasm entices ought to be solved by creating use of 2 totally different strategies. In the case of SQL parameters within the universe, the choice generates varied queries for each and each life that has to be chosen. This helps in generating a SQL statement for each live and provides the right results.

15. What’s a private and shared connection?

Ans:

    Personal associationShared association
    A personal association will be created solely by one user, and it can’t be created by others. This can be a sort of association that’s sometimes employed by another user via a server that could be a shared one.

16. What square measures the utilities of Derived tables?

Ans:

Using SQL queries from the information level, Derived tables square measure created within the universe. The columns of the derived table are the columns selected within the question. Derived tables will be utilized in the complicated calculations that square measure troublesome to attain within the report levels. employing a db link, tables will be accessed from a special schema, is another use of derived tables.

17. Outline User Objects?

Ans:

User objects square measure a universe of categories and objects that square measure created by the universe designer. Once the objects consisting of the universe don’t match your requirements, then the user will produce his own objects referred to as User objects.

18. List out the @functions?

Ans:

The @functions are:

  • @Aggregate_Aware.
  • @Script.
  • @Select.
  • @Variable.
  • @where.
  • @Prompt.

19. What’s the employment of @functions?

Ans:

The @prompt operator asks the top user to enter any specific values. The Visual Basics for applications macro’s results are recovered by victimization @Script operate. associate degree existing choice statement will be re-used by victimization the @Select operate. For a reputation or variable, the worth allotted thereto are documented victimization @Variable. associate degree existing object’s wherever clause will be re-used by @Where functions.

20. What’s a Boxi business object?

Ans:

21. What number of Domains are there in Business Objects? What area unit do they?

Ans:

There area unit 3 Domains in Business Objects and that they are:

  • Security.
  • Document.
  • Universe.

22. The way to access one derived table from another?

Ans:

Using @Derived_table operate, we are able to access one derived table from another. The syntax is:

  • @derived_table(the derived table name).

23. Outline Slice in Business Objects.

Ans:

Slice works with the master or detail reports and it’s wont to rename, reset and delete the blocks.

24. Outline custom hierarchies and build them?

Ans:

    Custom hierarchiesHierarchies created
    The custom hierarchy is used for outlining the universe for facilitating drill down that’s bespoken and might happen between objects from completely different or same categories considering the user necessities. The custom hierarchies are created by following the trail tools ->hierarchies in BO designer.

25. What’s a master/detailed report?

Ans:

Large blocks of knowledge are split into sections by mistreatment master/detail reports. continuation values are avoided by mistreatment of this and conjointly the subtotals are displayed.

26. Outline a category?

Ans:

The class is outlined as a group of objects in an exceedingly large universe. Subclasses are derived from categories and mistreat these categories and therefore the subclasses, we are able to produce a hierarchy.

27. What number approaches the area unit there for linking universes?

Ans:

There area unit 3 approaches obtainable for linking the universes and that they are:

  • The Kernel approach.
  • The Master approach.
  • The part approach.

28. What’s information mining?

Ans:

Data mining is the method through which you’ll extract the desired details from the information, which might be used for creating conclusions.

29. List out the obtainable Drill modes?

Ans:

Drill mode helps to investigate information from {different|totally completely different|completely different} angles and different states of details. The obtainable Drill modes are:

  • Drill up.
  • Drill down.
  • Drill by.
  • Drill through.

30. What’s the tutorial for Boxi?

Ans:

31. Outline aggregate_awarness?

Ans:

When we have an equivalent truth table in numerous grains, we tend to use the aggregate_awarness operation to outline one object for measures in truth tables. The syntax is as:

  • @aggregate_aware(highest_level.lower level)

32. Outline the term fan trap?

Ans:

A one to several be a part of, links to a table that respond with another one to several be a part of links is named fan entice.

33. Outline information supplier?

Ans:

The question or {the information|the info|The information} supply is named because the data supplier.

34. Once will we use context?

Ans:

Context is made once the dimension objects are a unit gift in one or each truth table.

35. Outline a context within the universe and build it?

Ans:

    Context universeContext created
    Context is outlined because the explicit path of the be a part of between a particular cluster of joins or the tables for the aim of a specific question. Context is created by creating use of options related to context or by manual procedures.
    A particular object that may be found within the column of a table, happiness to a specific context, is meant to be compatible with all the assorted types of objects happiness to an equivalent context. The context is sometimes created by creating use of logical calculation or supporting the business necessities. The notice context might not be a lot helpful during this case then it ought to be done by creating use of the manual procedure.

36. What’s the quality mode?

Ans:

Only the users among the cluster are accessed during this mode.

37. What are the schemas supported by Business Objects Designer?

Ans:

There area unit 5 completely different schemas supported by Business Objects designer and that they are:

  • star schema.
  • Snowflake Schema.
  • Multistar Schema.
  • Normalized production schema.
  • Data warehouse with aggregates.

38. What’s a Channel?

Ans:

Channel could be a web site with ‘push’ technology. it’s to create the users understand up-to-date info. Each and every Business Objects channel is going to be related to a broadcast agent. The United Nations agency will have many channels.

39. What area unit the restrictions over user objects?

Ans:

User objects aren’t shared with different finish users. it’s held in an exceedingly specific user object definition file. Therefore, if any end-user tries to refresh or edit the question containing another user’s user object, it’ll be mechanically cleansed and removed.

40. Outline ESRI maps for Boxi?

Ans:

41. Describe the tasks of a universe designer?

Ans:

The tasks consist of:

  • Designing the universe.
  • Creating the universe.
  • Maintaining the universe.
  • Distributing the universe.

42. List out the most parts of the designer interface?

Ans:

The main parts it consists of are:

  • The table browser.
  • The structure pane.
  • The universe pane.

43. What does one mean by report bursting?

Ans:

To maintain the version documents in keeping with the user profiles, we tend to use report explosives.

44. Outline WEBI?

Ans:

Web intelligence could be an answer that’s specialized in supporting selections associated with queries, reports, and analysis.

45. Differentiate Dice and Slice?

Ans:

    DiceSlice
    It renames, reset and delete the blocks. It works with the master/detail report. It displays the info and removes the info. It turns the crosstabs and tables into charts and contrariwise.

46. What’s the Abbreviation of DSS?

Ans:

Decision Support Systems.

47. Outline strategies?

Ans:

To mechanically extract structural data from an info or from a file we tend to use a script referred to as strategy.

48. Outline the universe?

Ans:

It is a collection of objects and categories. These objects Associate in Nursing categories are supposed for an application or a gaggle of users.

49. Outline secured mode?

Ans:

The IETF ChaCha20 stream cypher (256-bit key) is used to encrypt traffic, while the IETF Poly1305 authenticator is used to authenticate it. Outline is free and open-source software licenced under the Apache License 2.0, has been audited by Radically Open Security, and does not monitor users’ online activity.

50. Describe Boxi coverage tools architecture?

Ans:

box technique that enables testers to examine and validate a software system’s internal operations, including its code, infrastructure, and integrations with external systems.

51. What’s Drill by?

Ans:

Using drill we will move to an alternative hierarchy and analyze the opposite information that belongs to a different hierarchy.

52. What’s a listing of values?

Ans:

It is a file that contains the info values related to the Associate in Nursing object.

53. Will crystal reports be designed on high UDT?

Ans:

No, tools like crystal report for Enterprises, Dashboards, BO person don’t support the UNV universe (designed by UDT). It supports solely the UNX universe (designed by IDT). net Intelligence is the sole tool that supports each of the universes – UNV and UNX.

54. What are completely different information sources for BO reports?

Ans:

The different information sources are SAP bioattack, OLAP, application info, client info, Text file, XML file and net service.

55. We’ve loads of tools offered beneath the business objects platform. can a corporation have to be compelled to purchase the complete suite or will SAP offer how for organizations to shop for solely the tools that are needed?

Ans:

No, it’s not necessary for a corporation to shop for all the tools that come back beneath the SAP BO platform. The SAP provides the customization packages beneath that the corporate can purchase solely the tools that are required.

56. We tend to have a ‘dashboard builder’. what’s the word for an equivalent in BO atomic number 83 four.0?

Ans:

It is known as ‘BI workspaces’ in BO atomic number 83 four.0 platform.

57. If you would like to seek out immediate answers to business queries, that tool would you go with?

Ans:

We will escort a business object person during this case. It acts sort of like a business object’s computer program. we will explore for something through a keyword search held in the person and every one the data areas seem within the result wherever that individual keyword exists.

58. However the universes created in IDT are offered in BO?

Ans:

Once the universe is made, we tend to publish the universe employing a secured affiliation so import the universe in BO to form a report on it.

59. Explain about the extension of the universes created in IDT?

Ans:

it’s held within the style of a file.

60. What’s the architecture of the sap bodys supply layer?

Ans:

61. What’s the repository?

Ans:

The repository is that the info within which {the information|the knowledge|The information} concerning the users and data is a gift. it’s created and maintained by the final supervisor. It wants to share resources of business objects. It contains 3 domains. Universe domain – It holds all the exported universes and there is also over one universe domain within the repository.

62. What’s a Combined Query?

Ans:

Business Objects allows you to mix the info came by up to Eight Queries in a concert set of results. These combined queries change you to :

  • Obtain one column name from a multiple objects (Union)
  • Obtain information common to 2 sets of results (Intersect)
  • Exclude the results of 1 question from the results of another (Minus)

63. Why is the web known as a business user tool additionally as a designer tool at an equivalent time?

Ans:

The reason behind {this is|this is often|This will be} that a business user can log into net intelligence and think about reports associated with Nursing if they need to form easy reports on an ad-hoc basis then that’s conjointly doable.

64. What tool is required for making extremely formatted reports in SAP BO?

Ans:

Web Intelligence (Webi), that may be a browser tool that enables users to perform analysis, manufacture formatted reports and distribute the reports on SAP BO or export them to PDF or surpass. Crystal Reports, which may be an information analytics and coverage tool aimed toward individual users or little and medium-sized businesses (SMBs).

65. What’s the report detonating in SAP BO?

Ans:

During business enterprise, information in documents is fresh against information sources and personalized before a publication is delivered to recipients. This method is understood as reporting detonation.

66. Justify your plan of a universe in bo and its relevance with the assignments you’ve got worked upon

Ans:

A universe may be a logical layer between backend and a front of the coverage. It’s an information layer that isolates the technical complexities of the supply system from business user/report developers.

67. What’s the distinction between UDT and IDT?

Ans:

UDT IDT The universes that are designed in UDT are UNV universes whereas the universes. IDT is increased and a lot more organized as compared to UDT.

68. If a business wants extremely formatted reports, that tool would you choose?

Ans:

We would escort ‘SAP crystal reports for enterprise’ during this case because it provides terribly powerful info choices.

69. What’s the results of a query?

Ans:

The results of the question is the final report. A report may be a business illustration of the info.

70. What’s Boxi facilitated portal?

Ans:

71. What’s The distinction Between operation (), Lookup_ext () And Lookup_seq ()?

Ans:

lookup() : in brief, It returns single price supported single condition.

lookup_ext(): It returns multiple values supported single/multiple condition(s).

lookup_seq(): It returns multiple values supported sequence range.

72. What’s the employment Of Array Fetch Size?

Ans:

Array fetch size indicates the quantity of rows retrieved in a very single request to a supply info. The default price is a thousand. Higher numbers scale back requests, lowering network traffic, and probably improve performance. the utmost price is 5000.

73. What’s the employment Of motor vehicle Correct Load?

Ans:

It doesn’t permit duplicate information moving into the target table.It works like kind one Insert else Update the rows supported Non-matching and matching information severally.

74. Provide 2 samples of however the info Cleanse rework will Enhance (append) Data?

Ans:

The Data Cleanse rework will generate name match standards and greetings. It may assign gender codes and prenames like adult male. and Mrs.

75. What are Adapters?

Ans:

Adapters are extra Java-based programs that may be put in on the task server to supply property to different systems like Salesforce.com or the JavaMessagingQueue. There’s a SoftwareDevelopment Kit (SDK) to permit customers to make adapters for custom applications.

76. List Factors you concentrate on once determinative whether or not To Run Workflows Or information Flows Serially Or In Parallel>?

Whether or not the flows ar freelance of every different Whether or not the server will handle the process necessities of flows running at constant time (in parallel)

77. What’s a Substitution Parameter?

Ans:

The Value that’s constant in one atmosphere, however might modify once employment is migrated to a different atmosphere.

78. What will an operation do? however Do the various Variations Of The operation operate Differ?

Ans:

All operation functions come one row for every row within the supply. They dissent however they opt for that of many matching rows to come.

79. What are Name Match Standards and the way they are They Used?

Ans:

Name match standards illustrate the multiple ways that a reputation may be drawn. they’re employed in the match method to greatly increase match results.

80. What’s Boxi Administration architecture?

Ans:

81. What’s the utilization Of Map-operation remodel?

Ans:

The Map-Operation remodel permits you to vary operation codes on knowledge sets to supply the required output. Operation codes: INSERT, UPDATE, DELETE, traditional or DISCARD.

82. What’s the utilization Of Case Transform?

Ans:

Use of the Case remodel is to change branch logic in knowledge flows by consolidating case or decision-making logic into one remodel. The remodel permits you to separate an information set into smaller sets supported logical branches.

83. What are the bunch of tools out there beneath business objects four.0 platform?

Ans:

We have the subsequent style of tools beneath SAP BO atomic number 83 four.0:

  • Administrator tools.
  • Business User tools Business user tools are those supposed for a business user (example –HR manager or a monetary manager of any organization) that facilitate them to look at and manage business reports to help them in an exceedingly decision-making method.
  • Data manager tools they’re wont to style a linguistics layer between the designer tool and its supply of knowledge.
  • Designer tools It provides the ability to style a question supported your reportage demand.

84. What are the various versions of Business Objects that you just have worked on?

Ans:

  • BO XI R1.
  • BO XI R2.
  • BO XI R3.
  • BO XI R3.1.
  • BO XI R3.2.
  • In 2011, BO XI 4.0 was introduced and the latest version of the tool is SAP BO four.2.

85. What are the key variations between Boxi R3 and SAP BO four.x?

Ans:

    Boxi r3SAP Bo
    Bo 4.x is half-dozen stratified designs as compared to BOXI R3 five layer design. IDT is introduced to support multiple knowledge sources. Import Wizard isn’t any longer out there in BO four.x.

86. What are the benefits of exploiting Business Objects?

Ans:

Arrays of benefits are there in creating use of Business Objects. These are as follows:

  • Graphical Interface.
  • Dragging and Dropping.
  • Terms those ar acquainted in business.
  • User friendliness.
  • Powerful reports for brief span of your time.
  • Use of documents on basis of associate enterprise exploitation Webl.

87. List out the assorted out there knowledge resources?

Ans:

You can access the info from a large variety of sources exploitation Business Objects. These are:

  • Oracle
  • MS SQL Serve
  • IBM DB

88. Make a case for the role of Slice in Business Objects?

Ans:

Slice works with the detail or master reports. Also, it’s used for renaming, resetting and deleting the blocks.

89. What are calculation contexts?

Ans:

By default, BUSINESSOBJECTS determines the results of a live supported the dimension or dimensions within the a part of the report within which the live is inserted. These sets of dimensions are referred to as calculation contexts. Calculation contexts are dynamic in BUSINESSOBJECTS.

90. Describe an atomic number 83 design process tier?

Ans:

91. What information sources are available?

Ans:

BUSINESS OBJECTS allow you to access information from a good variety of sources. you’ll be able to access information from relative databases (RDBMS), like ORACLE, Microsoft SQL Server, Informix and IBM DB2. two-dimensional (OLAP) databases, like Microsoft OLAP Services, Hyperion Essbase, and ORACLE specific.Virtually any information supplies victimization Microsoft Visual Basic for Applications (VBA) procedures.

92. What is new in BO five.1?

Ans:

  • Save business objects documents in Adobe transportable Document Format (PDF).
  • Add hyperlinks to reports like mail addresses and computing machine addresses.
  • These hyperlinks ar maintained once you save the report in HTML or PDF.
  • Zero Administration – solely the business objects shopper package put in on the windows pc; all middleware is keep and administered on internet|the online|the net} intelligence web server and also the server aspect process is handled by the net intelligence system.

93. However does one publish a BO report?

Ans:

There are 2 ways that of publication BO reports on website:

  • Users WHO have publication rights for a document will publish that document for different users.
  • Documents may be printed via a hardware for Business Object called BCA or Broadcast Agent.

94. What are User Objects? What are the restrictions?

Ans:

User objects are end-user personal objects that don’t seem to be shared with different end-users. This can be as a result of the user objects being kept domestically in a very specific user object definition file. If an Associate in Nursing end-user tries to refresh or edit a question that contains another user’s user object, the user object is mechanically faraway from the question and report. A user object is kept within the Universe folder.

95. Did you do data reportage in BO?

Ans:

Metadata reportage of BO is feasible. BO provides a separate universe that truly contains repository tables, objects etc. victimization this Universe one will do data reportage in BO.

Are you looking training with Right Jobs?

Contact Us

Popular Courses