SAP Bo - Objective

36 Questions | Total Attempts: 1625

SettingsSettingsSettings
SAP Quizzes & Trivia

Questions and Answers
  • 1. 
    Custom Hierarchies are defined in a universe in order :-
    • A. 

      To facilitate custom drill down between objects from same or different classes

    • B. 

      They can be created from Tools -> Hierarchies in the BO Designer

    • C. 

      To prevent Fan Trap

    • D. 

      None of the Above

  • 2. 
    What all statements below are true about contexts ?
    • A. 

      Contexts may be created using detect contexts feature or manually

    • B. 

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

    • C. 

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

    • D. 

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

  • 3. 
    A chasm trap can be solved using 2 methods , they are :-
    • 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.

    • B. 

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

    • C. 

      Linked Universe

    • D. 

      None of the Above

  • 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
    • A. 

      True

    • B. 

      False

  • 5. 
    Aggregate awareness function is used in scenarios :-
    • A. 

      Where we have same fact tables in different grains

    • B. 

      Where we have same fact tables in same grains

    • C. 

      Where we have different fact tables in same grains

    • D. 

      Where we have different fact tables in different grains

  • 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)
    • A. 

      True

    • B. 

      False

  • 7. 
    A derived table is a table :-
    • A. 

      Created in the universe using an SQL Query from database level

    • B. 

      Created in the database using an SQL Query from database level

    • C. 

      Created in the universe using an SQL Query from table level

    • D. 

      Created in the universe using an SQL Query from report level

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

      True

    • B. 

      False

  • 9. 
    Index awareness is a property of the :-
    • A. 

      Universe

    • B. 

      Database

    • C. 

      Table

    • D. 

      None of the Above

  • 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.
    • A. 

      True

    • B. 

      False

  • 11. 
    A condition object is a filter condition created in the :-
    • A. 

      Universe Level

    • B. 

      Database Level

    • C. 

      Report

    • D. 

      Table

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

      True

    • B. 

      False

  • 13. 
    A query filter exists in the __________ only
    • A. 

      Universe

    • B. 

      Database

    • C. 

      Report

    • D. 

      Table

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

      True

    • B. 

      False

  • 15. 
    Linked universe are universes which share common component such as :-
    • A. 

      Objects

    • B. 

      Classes

    • C. 

      Joins

    • D. 

      None of the above

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

      True

    • B. 

      False

  • 17. 
    Input Control
    • A. 

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

    • B. 

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

    • C. 

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

    • D. 

      None of the Above

  • 18. 
    Input control does not allow multiselection of values which a report filter does support
    • A. 

      True

    • B. 

      False

  • 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.
    • A. 

      True

    • B. 

      False

  • 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.
    • A. 

      True

    • B. 

      False

  • 21. 
    Query Filter should be used
    • A. 

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

    • B. 

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

    • C. 

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

    • D. 

      None of the Above

  • 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.
    • A. 

      True

    • B. 

      False

  • 23. 
    Input context consists of
    • A. 

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

    • B. 

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

    • C. 

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

    • D. 

      None of the Above

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

      True

    • B. 

      False

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

      Add(Measure In Report)

    • B. 

      Total(Measure In Report)

    • C. 

      Sum(Measure In Report)

    • D. 

      TotalSum(Measure In Report)

Related Topics
Back to Top Back to top