SAP Bo - Objective 2

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Amehta
A
Amehta
Community Contributor
Quizzes Created: 3 | Total Attempts: 2,884
| Attempts: 145
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/36 Questions

    Custom Hierarchies are defined in a universe in order :-

    • To facilitate custom drill down between objects from same or different classes
    • They can be created from Tools -> Hierarchies in the BO Designer
    • To prevent Fan Trap
    • None of the Above
Please wait...
About This Quiz

Explore key concepts of SAP BusinessObjects through this quiz. Master custom hierarchies, contexts, chasm and fan traps, and aggregate awareness functions. Essential for learners aiming to enhance their skills in effective data handling and reporting in SAP environments.

SAP Bo - Objective 2 - Quiz

Quiz Preview

  • 2. 

    What all statements below are true about contexts ?

    • Contexts may be created using detect contexts feature or manually

    • For a universe contexts should be created in a way that all joins(except shortcut joins) do not fall in the same context

    • When objects from two or more contexts are used, separate SQL is generated and results are then merged in a micro cube.

    • Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.

    Correct Answer(s)
    A. Contexts may be created using detect contexts feature or manually
    A. When objects from two or more contexts are used, separate SQL is generated and results are then merged in a micro cube.
    A. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.
    Explanation
    Contexts can be created either using the detect contexts feature or manually. When objects from multiple contexts are used, separate SQL is generated and the results are merged in a micro cube. Objects created on a table column that belong to specific contexts are naturally compatible with all other objects from the same contexts.

    Rate this question:

  • 3. 

    A chasm trap can be solved using 2 methods , they are :-

    • In the universe SQL parameters, the option, generate multiple queries for each measure needs to be selected. This will generate separate SQL statement for each measure and give the correct results.

    • A better approach is to put the two joins in two different contexts. This will generate two synchronized queries, thus solving the problem

    • Linked Universe

    • None of the Above

    Correct Answer(s)
    A. In the universe SQL parameters, the option, generate multiple queries for each measure needs to be selected. This will generate separate SQL statement for each measure and give the correct results.
    A. A better approach is to put the two joins in two different contexts. This will generate two synchronized queries, thus solving the problem
    Explanation
    The correct answer explains that a chasm trap can be solved using two methods. The first method is to select the option "generate multiple queries for each measure" in the universe SQL parameters. This will generate separate SQL statements for each measure and provide accurate results. The second method suggests putting the two joins in two different contexts. This will generate two synchronized queries, effectively resolving the problem.

    Rate this question:

  • 4. 

    A fan trap is solved by creating an alias of the 2nd table and defining contexts such that, the normal table is joined only with the first table, while the alias is joined with both the 1st and the 3rd table. We would take 2nd table’s measure only from the normal table and other dimensions of the 2nd table from the alias table

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In order to solve a fan trap, an alias of the 2nd table is created and contexts are defined. This means that the normal table is only joined with the first table, while the alias is joined with both the 1st and the 3rd table. By doing this, the measures of the 2nd table are taken only from the normal table, while the other dimensions of the 2nd table are taken from the alias table. This approach helps to resolve the fan trap issue and ensures accurate data analysis.

    Rate this question:

  • 5. 

    Aggregate awareness function is used in scenarios :-

    • Where we have same fact tables in different grains

    • Where we have same fact tables in same grains

    • Where we have different fact tables in same grains

    • Where we have different fact tables in different grains

    Correct Answer
    A. Where we have same fact tables in different grains
    Explanation
    Aggregate awareness function is used in scenarios where we have the same fact tables in different grains. This means that the fact tables contain data at different levels of detail or granularity. The aggregate awareness function allows the query to intelligently choose the appropriate aggregate table based on the level of detail required in the query. By using the aggregate tables, the query can be optimized and improved performance can be achieved.

    Rate this question:

  • 6. 

    Using Aggregate awareness function we can define only one object for the measures in the fact tables as @aggregate_aware(highest_level,lower level)

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The given correct answer is true. The aggregate awareness function allows us to define only one object for the measures in the fact tables. This function helps in optimizing the performance of queries by selecting the appropriate level of aggregation based on the query conditions. By specifying the highest level and lower level in the aggregate awareness function, we can ensure that the query retrieves the necessary data at the desired level of detail.

    Rate this question:

  • 7. 

    A derived table is a table :-

    • Created in the universe using an SQL Query from database level

    • Created in the database using an SQL Query from database level

    • Created in the universe using an SQL Query from table level

    • Created in the universe using an SQL Query from report level

    Correct Answer
    A. Created in the universe using an SQL Query from database level
    Explanation
    A derived table is created in the universe using an SQL Query from the database level. This means that the table is not physically stored in the database, but rather it is created on the fly using a query that is executed at the database level. The result of this query is then used as a temporary table within the universe. This allows for more flexibility and efficiency in data retrieval and analysis, as the derived table can be customized based on the specific needs of the report or analysis being performed.

    Rate this question:

  • 8. 

    A derived table cannot be used for complex calculations, which are difficult to achieve in report level.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is incorrect. A derived table can be used for complex calculations in a report. Derived tables are created by combining data from multiple tables or applying complex calculations on existing tables. They are a useful tool for performing advanced calculations and aggregations in a report. Therefore, the correct answer is False.

    Rate this question:

  • 9. 

    Index awareness is a property of the :-

    • Universe

    • Database

    • Table

    • None of the Above

    Correct Answer
    A. Universe
    Explanation
    Index awareness is a property of the universe in the context of data modeling and business intelligence. It refers to the ability of the universe to utilize indexes, which are data structures that improve the performance of querying and retrieving data from databases. By being index aware, the universe can optimize its queries by leveraging the indexes present in the underlying database, resulting in faster and more efficient data retrieval.

    Rate this question:

  • 10. 

    Index awareness is a property , by means of which values in the filter conditions of the queries/data providers , are substituted by their corresponding indexes or surrogate keys.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Index awareness is a property that allows filter conditions in queries or data providers to be replaced with their corresponding indexes or surrogate keys. This means that instead of using the actual values in the filter conditions, the indexes or surrogate keys are used. This can improve the performance of the queries or data providers as it can utilize the indexes more efficiently. Therefore, the statement "Index awareness is a property, by means of which values in the filter conditions of the queries/data providers, are substituted by their corresponding indexes or surrogate keys" is true.

    Rate this question:

  • 11. 

    A condition object is a filter condition created in the :-

    • Universe Level

    • Database Level

    • Report

    • Table

    Correct Answer
    A. Universe Level
    Explanation
    A condition object is created at the Universe Level. The Universe Level refers to the semantic layer of a business intelligence tool where the data is modeled and organized. Conditions are created in the Universe Level to define filters or restrictions on the data that will be retrieved from the underlying database. These conditions help in narrowing down the data set to meet specific criteria and improve the efficiency of reporting and analysis.

    Rate this question:

  • 12. 

    When condition object is dragged in the Query Panel, the filter condition appears in the query SQL.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When a condition object is dragged in the Query Panel, it means that a filter condition is being applied to the query. This filter condition is then reflected in the query SQL, which is the language used to retrieve data from a database. Therefore, the statement that the filter condition appears in the query SQL when a condition object is dragged in the Query Panel is true.

    Rate this question:

  • 13. 

    A query filter exists in the __________ only

    • Universe

    • Database

    • Report

    • Table

    Correct Answer
    A. Report
    Explanation
    A query filter exists in the report only. This means that when using a report, you have the ability to apply a filter to the data being displayed. This filter allows you to narrow down the results based on specific criteria, such as a date range or specific values. In contrast, a universe, database, or table does not have this built-in functionality for applying filters to the data.

    Rate this question:

  • 14. 

    A query filter is added during building a query. This does not appear in the query SQL

    • True

    • False

    Correct Answer
    A. False
    Explanation
    During the process of building a query, a query filter is added to specify certain conditions or criteria that the query results must meet. This filter is an integral part of the query and is included in the query SQL. Therefore, the statement that a query filter does not appear in the query SQL is incorrect. Hence, the correct answer is False.

    Rate this question:

  • 15. 

    Linked universe are universes which share common component such as :-

    • Objects

    • Classes

    • Joins

    • None of the above

    Correct Answer(s)
    A. Objects
    A. Classes
    A. Joins
    Explanation
    Linked universes are universes that share common components such as objects, classes, and joins. This means that these universes have interconnected elements, allowing for data integration and analysis across different universes. By sharing objects, classes, and joins, users can access and combine data from multiple universes, enabling them to gain a comprehensive view of the data and make more informed decisions.

    Rate this question:

  • 16. 

    When two universes are linked, the source universe is called core universe while the destination is called derived universe.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In this statement, it is mentioned that when two universes are linked, the source universe is referred to as the core universe, while the destination universe is called the derived universe. This implies that the statement is true.

    Rate this question:

  • 17. 

    Input Control

    • Allows filtering of data based on a dimension in the report.

    • Allows filtering of data based on a column in the report.

    • Allows filtering of data based on a row in the report.

    • None of the Above

    Correct Answer
    A. Allows filtering of data based on a dimension in the report.
    Explanation
    The correct answer is "allows filtering of data based on a dimension in the report." This means that an input control provides the functionality to filter data in a report based on a specific dimension, such as a category or attribute. It allows users to select a dimension value and filter the report to show only the data related to that value.

    Rate this question:

  • 18. 

    Input control does not allow multiselection of values which a report filter does support

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because input controls do support multiselection of values. Input controls allow users to select multiple values from a list, which can be used to filter data in a report. This feature is commonly used in reporting tools to provide users with more flexibility in analyzing and viewing data. Therefore, the given statement is incorrect.

    Rate this question:

  • 19. 

    Suppose we have a hierarchy defined in 3 levels, but if we set the scope of analysis is set to 2 levels, the report will be able to drill down to the 3rd level overriding the scope of analysis.

    • False

    • True

    Correct Answer
    A. False
    Explanation
    If the scope of analysis is set to 2 levels, it means that the report will only show data up to the second level of the hierarchy. Therefore, it will not be able to drill down to the third level, as the scope of analysis overrides any deeper levels in the hierarchy. Hence, the statement is False.

    Rate this question:

  • 20. 

    If the analysis level is set to custom, the objects from existing hierarchies can be dragged in the scope of analysis panel to set the scope for drilldown in the report.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When the analysis level is set to custom, it allows the user to manually select specific objects from existing hierarchies and drag them into the scope of the analysis panel. This means that the user can choose which objects they want to include in the drilldown scope for the report. Therefore, the statement "If the analysis level is set to custom, the objects from existing hierarchies can be dragged in the scope of analysis panel to set the scope for drilldown in the report" is true.

    Rate this question:

  • 21. 

    Query Filter should be used

    • In report having multiple tabs having different objects requiring same or different filter conditions

    • In report having single tab having different objects requiring same or different filter conditions

    • In report having multiple tabs having same object requiring same or different filter conditions

    • None of the Above

    Correct Answer
    A. In report having multiple tabs having different objects requiring same or different filter conditions
    Explanation
    In a report with multiple tabs and different objects requiring the same or different filter conditions, the query filter should be used. This allows for the application of specific filter conditions to each tab and object, ensuring accurate and relevant data is displayed in the report. By using the query filter, the report can effectively handle the varying filter requirements of different objects within the report.

    Rate this question:

  • 22. 

    In case where there are multiple tabs having same objects, but with slightly differing filter conditions, it is advisable to fetch the whole data in the query and then apply report filters to the various tabs to get the desired data instead of using separate queries for each tab.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When there are multiple tabs with similar objects but different filter conditions, it is more efficient to fetch all the data in one query and then apply report filters to each tab. This approach avoids the need to make separate queries for each tab, which can be time-consuming and resource-intensive. By fetching the whole data and applying filters, it ensures that the desired data is obtained for each tab without unnecessary duplication of queries. Therefore, it is advisable to follow this approach to optimize performance and resource utilization.

    Rate this question:

  • 23. 

    Input context consists of

    • Any dimension objects that need to be included directly in the calculation itself.

    • Any dimension objects that need to be included indirectly in the calculation itself.

    • Any table objects that need to be included directly in the calculation itself.

    • None of the Above

    Correct Answer
    A. Any dimension objects that need to be included directly in the calculation itself.
    Explanation
    The correct answer is "any dimension objects that need to be included directly in the calculation itself." This means that the input context should include dimension objects that are directly involved in the calculation process. These dimension objects are necessary for performing the calculation accurately and should be included in the input context.

    Rate this question:

  • 24. 

    Output context consists of one or more table objects that determine the aggregation level at which the calculation is displayed

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because the output context does not consist of table objects. The output context refers to the filters or conditions applied to the data before performing calculations or aggregations. It determines the subset of data that is used for the calculation, not the display format or structure. Table objects, on the other hand, are used to organize and present the data in a tabular format for better understanding and analysis.

    Rate this question:

  • 25. 

    To display the total sum of a measure in row level of the report block , we have to use the expression

    • Add(Measure In Report)

    • Total(Measure In Report)

    • Sum(Measure In Report)

    • TotalSum(Measure In Report)

    Correct Answer
    A. Sum(Measure In Report)
    Explanation
    The correct answer is "Sum(Measure In Report)". This expression is used to calculate the total sum of a measure in the row level of a report block. It adds up all the values of the measure in each row and displays the total sum.

    Rate this question:

  • 26. 

    Which selector gives the option of multiple selection in Xcelcius Dashboard? How do we make the multiple selection?

    • DropDown List Builder

    • List Builder

    • Multiple selector

    • None of the Above

    Correct Answer
    A. List Builder
    Explanation
    The correct answer is List Builder. The List Builder selector in Xcelcius Dashboard allows for multiple selection. To make multiple selections, the user can simply hold down the Ctrl key while clicking on the desired options in the list.

    Rate this question:

  • 27. 

    Which Xcelcius components can we use for linking multiple dashboard flash outputs(swf files)?

    • Swf Loader

    • Slideshow

    • Swf displayer

    • Swf Link

    Correct Answer(s)
    A. Swf Loader
    A. Slideshow
    Explanation
    The correct answer is Swf Loader and Slideshow. These components can be used to link multiple dashboard flash outputs (swf files). The Swf Loader component allows loading and displaying external swf files within the dashboard, while the Slideshow component enables the creation of a slideshow by displaying multiple swf files in a sequential manner. These components provide the functionality to connect and present multiple dashboard flash outputs effectively.

    Rate this question:

  • 28. 

    The  Xcelcius component ‘Slideshow’ is the only feasible option for a complete presentation

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The Xcelcius component 'Slideshow' is the only feasible option for a complete presentation because it allows users to create dynamic and interactive presentations with the ability to incorporate various data visualizations, charts, and graphs. It offers a wide range of customization options and interactive features that make it an ideal choice for presenting complex data in a visually appealing and engaging manner. Other components may have limitations or lack the necessary features to create a comprehensive presentation, making the Slideshow component the most suitable option.

    Rate this question:

  • 29. 

    What are the ways in which an Xcelcius dashboard can access data from a BO universe

    • Query as a Web Service

    • Business Intelligence Web Service

    • LiveOffice

    • None of the Above

    Correct Answer(s)
    A. Query as a Web Service
    A. Business Intelligence Web Service
    A. LiveOffice
    Explanation
    An Xcelcius dashboard can access data from a BO universe through various methods. One way is by using Query as a Web Service, which allows the dashboard to send queries to the BO universe and retrieve the data. Another method is through Business Intelligence Web Service, which provides a set of web services that can be used to access and manipulate data from the BO universe. Additionally, LiveOffice can be used to directly integrate BO universe data into Microsoft Office applications. Therefore, the correct answer is Query as a Web Service, Business Intelligence Web Service, and LiveOffice.

    Rate this question:

  • 30. 

    What are the types of business objects repository domain?   

    • The security domain

    • The universe domain

    • The document domain

    • The Report Domain

    Correct Answer(s)
    A. The security domain
    A. The universe domain
    A. The document domain
    Explanation
    The types of business objects repository domain are the security domain, the universe domain, and the document domain. The security domain refers to the management of user access and permissions within the repository. The universe domain involves the creation and management of data models and queries. The document domain deals with storing and organizing various types of documents within the repository. These domains are essential for effectively managing and organizing business objects within a repository.

    Rate this question:

  • 31. 

    What are the types of dimensions?

    • Informational Dimension

    • Structural Dimension

    • Categorical Dimension

    • Partitioning Dimension

    Correct Answer(s)
    A. Informational Dimension
    A. Structural Dimension
    A. Categorical Dimension
    A. Partitioning Dimension
    Explanation
    The types of dimensions are informational, structural, categorical, and partitioning. Informational dimensions provide additional context or details about a certain attribute. Structural dimensions define the hierarchical relationships between different attributes. Categorical dimensions classify data into distinct categories or groups. Partitioning dimensions divide data into subsets based on certain criteria.

    Rate this question:

  • 32. 

    Check Integrity can detect :

    • Invalid syntax in the SQL definition of an object, condition, or join.

    • Isolated tables

    • Isolated joins

    • Missing or incorrect cardinalities

    Correct Answer(s)
    A. Invalid syntax in the SQL definition of an object, condition, or join.
    A. Isolated tables
    A. Isolated joins
    A. Missing or incorrect cardinalities
    Explanation
    Check Integrity is a feature that can be used to detect various types of errors or issues in a database. It can identify invalid syntax in the SQL definition of an object, condition, or join, which means it can catch any mistakes or typos in the SQL code that could lead to errors or unexpected results. Additionally, it can also detect isolated tables and joins, which are tables or joins that are not connected to the rest of the database structure. Lastly, it can identify missing or incorrect cardinalities, which refers to the relationship between tables and the number of records they can have.

    Rate this question:

  • 33. 

    Business Intelligence Web Service does not have a connection of its own. We access this Business Intelligence Web Service through a Query as a Web Service connection only.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the Business Intelligence Web Service does not have its own connection. Instead, it is accessed through a Query as a Web Service connection. This means that in order to interact with the Business Intelligence Web Service, we need to establish a connection through a Query as a Web Service connection. Therefore, the statement "Business Intelligence Web Service does not have a connection of its own. We access this Business Intelligence Web Service through a Query as a Web Service connection only" is true.

    Rate this question:

  • 34. 

    Xcelcius component  ‘Swf Loader’ can only open swf through ‘Push Button’ or selector components, whereas ‘Slideshow’ has a feature of automatic slide transition, which loads the image and swf files in the specified sequence.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the correct answer is that the statement is stating that the Xcelcius component 'Swf Loader' can only open swf files through 'Push Button' or selector components. On the other hand, the 'Slideshow' component has a feature of automatic slide transition, which means it can load both image and swf files in a specified sequence. Therefore, the statement is true.

    Rate this question:

  • 35. 

    In a Webi or Deski report when one drags the measure object with the dimension object of a particular granularity, the measure column from the Fact table of the corresponding granularity is selected in the BO default Query. If we did not use aggregate awareness, we would need to define separate objects for each of the fact tables which would be difficult to understand from a user’s point of view.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When creating a Webi or Deski report, if we drag a measure object with a dimension object of a specific granularity, the measure column from the Fact table that matches that granularity is automatically selected in the BusinessObjects default Query. This is possible due to the use of aggregate awareness. If we didn't use aggregate awareness, we would have to define separate objects for each fact table, which would make it more challenging for users to understand and navigate the report. Therefore, the statement "True" is correct.

    Rate this question:

  • 36. 

    Derived table can be to access tables from a different schema through a dblink.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A derived table is a temporary table that is created within a query and exists only for the duration of that query. It can be used to access tables from a different schema through a database link (dblink). This allows the query to retrieve data from tables that are not directly accessible in the current schema. Therefore, the statement "Derived table can be used to access tables from a different schema through a dblink" is true.

    Rate this question:

Quiz Review Timeline (Updated): May 7, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • May 07, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 05, 2013
    Quiz Created by
    Amehta

Related Topics

Recent Quizzes

SAP Material Management (ERP Certification) Prep Test SAP Material Management (ERP Certification) Prep Test
SAP S/4HANA ERP (1709, 1809, and 1909) Certification Exam Prep Test SAP S/4HANA ERP (1709, 1809, and 1909) Certification Exam Prep Test
How well do you know the SAP T-codes How well do you know the SAP T-codes
SAP S/4 HANA FI SAP S/4 HANA FI
SAP Ariba Procurement - Mock Exam SAP Ariba Procurement - Mock Exam
SAP Ariba Procurement Mock Exam SAP Ariba Procurement Mock Exam
3.2 SAP S/4HANA for Management Accounting Associates Certification 3.2 SAP S/4HANA for Management Accounting Associates Certification
SAP Trivia Questions For Beginners! SAP Trivia Questions For Beginners!
AWS Certified Cloud Practitioner AWS Certified Cloud Practitioner

Featured Quizzes

Are You Ready For IQ Quiz: Test Your Intelligence Now Are You Ready For IQ Quiz: Test Your Intelligence Now
What Is My Ethnicity? Let's Take Ethnicity Quiz What Is My Ethnicity? Let's Take Ethnicity Quiz
What Is My Talent? What Is My Talent?
What Ethnicity Do I Look Like? What Ethnicity Do I Look Like?
Introduction to Computer: MCQ Questions With Answers Introduction to Computer: MCQ Questions With Answers
Best Friend Quiz: Are You Really Best Friends? Best Friend Quiz: Are You Really Best Friends?
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.