Hannylou Celestial
Quiz by , created more than 1 year ago

Quiz on TBI10, created by Hannylou Celestial on 07/11/2017.

156
1
0
No tags specified
Hannylou Celestial
Created by Hannylou Celestial about 7 years ago
Close

TBI10

Question 1 of 156

1

Where the data you need is currently stored, how you can access the stored data, and how you can upload the data to SAP BW

Select one of the following:

  • Source Systems

  • Data Warehouse

  • Reporting

Explanation

Question 2 of 156

1

How you will store the data in SAP, which infoProviders you will need, and which levels of storage

Select one of the following:

  • Source Systems

  • Data Warehouse

  • Reporting

Explanation

Question 3 of 156

1

Which of the following connections is used to SAP BW via data replication Application Programming Interface (API) from different sources such as SAP ERP extractor, SAP Hana views, SAP Business ByDesign, and SAP Landscape Transformation Replication Server (SLT)

Select one of the following:

  • Operational Data Provisioning (ODP)

  • BW Service API (S-API)

  • DB Connect

  • UD Connect

Explanation

Question 4 of 156

1

It is a software component that is installed on an SAP source system with the SAP BASIS Plug-in. S-API allows for communication between SAP source systems and SAP BW and transfers data from source systems to the data warehouse

Select one of the following:

  • Operational Data Provisiong (ODP)

  • BW Service API (S-API)

  • UD Connect

  • DB Connect

Explanation

Question 5 of 156

1

It creates a connecttion to the database management system in an external database. By importing metadata and original data from the external database, the necessary structures are generated in SAP BW, and the data can be loaded easily and efficiently

Select one of the following:

  • Operational Data Provisioning (ODP)

  • BW Service API (S-API)

  • DB Connect

  • UD Connect

Explanation

Question 6 of 156

1

This accesses relational data sources. The technology runs on the JAVA 2 Platform Enterprise Edition (J2EE) Engine and supports the J2EE Connector Architecture

Select one of the following:

  • Operational Data Provisioning (ODP)

  • BW Service API (S-API)

  • DB Connect

  • UD Connect

Explanation

Question 7 of 156

1

It imports flat files in CSV, ASCII, and XLS formats.

Select one of the following:

  • File Interface

  • Web Services

  • Staging BAPIs

  • SAP Data Services

Explanation

Question 8 of 156

1

It allows to send data o SAP BW under third-party control

Select one of the following:

  • File Interface

  • Web Services

  • Staging BAPIs

  • SAP Data Services

Explanation

Question 9 of 156

1

It is an open interface that SAP Data Service and certified third-party tools can use to extract data from older systems. Data transfer is triggered by a request from SAP BW or SAP Data Services or by a certfied third-party tool

Select one of the following:

  • File Interface

  • Web Services

  • Staging BAPIs

  • SAP Data Services

Explanation

Question 10 of 156

1

It has a tight integration when providing data to SAP BW via Staging BAPIs

Select one of the following:

  • File Interface

  • Web Services

  • Staging BAPIs

  • SAP Data Services

Explanation

Question 11 of 156

1

Analysis can be used without an installed BI Platform

Select one of the following:

  • True
  • False

Explanation

Question 12 of 156

1

In SAP Netweaver mode, functions like single sign-on and saving workbooks cannot be provided from SAP BW without using BI Platform as a server.

Select one of the following:

  • True
  • False

Explanation

Question 13 of 156

1

Which of the following is not supported in Crystal Reports?

Select one of the following:

  • Hierarchy

  • Charts

  • Drill-down

  • Filtering

  • Support for manual entry of
    values

Explanation

Question 14 of 156

1

Which of the following are the supported data sources of WEBi?

Select one or more of the following:

  • Universe

  • Excel

  • BEx Query

  • SAP HANA view

  • SAP HANA Online

  • Analysis View

  • Text

  • Web Services

  • Free hand SQL

  • InfoProviders

Explanation

Question 15 of 156

1

Users can continue working with WEBi document (.wid) files, even when they are not connected to a CMS.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 156

1

is the basis of data analysis. You create and edit queries to evaluate data from Characteristics and Key Figure obbjects.

Select option below to complete the highlighted text

    BEx Query Designer
    BEx Analyzer
    BEx Web Application Designer
    BEx Report Designer
    Information Broadcasting
    SAP Enterprise portal

Explanation

Question 17 of 156

1

The goal of data warehousing is online analytical processing wit large amount of data of operative and historical data.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 156

1

From which of the following sources can SAP BW extract data directly?

Select one or more of the following:

  • CSV file

  • MS Word file

  • Relational database system

  • SAP ERP system

Explanation

Question 19 of 156

1

You can use SAP BO Analysis, edition for MIcrosoft excel, to create and edit queries for reports.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 156

1

Stores amount or quantities

Select one of the following:

  • InfoProvider

  • Characteristics InfoObject

  • Key Figure

  • Multiprovider

Explanation

Question 21 of 156

1

The generic term used to describe any objects for which you can create and execute queries in SAP BW

Select one or more of the following:

  • InfoProvider

  • Characteristics InfoObject

  • Key Figure

  • Multiprovider

Explanation

Question 22 of 156

1

Store master data and is used with key figures to build other infoProvider tables

Select one of the following:

  • InfoProvider

  • Characteristics InfoObject

  • Key Figure

  • Multiprovider

Explanation

Question 23 of 156

1

Provides view of data from multiple InfoProviders

Select one of the following:

  • InfoProvider

  • Characteristics InfoObject

  • Key Figure

  • Multiprovider

Explanation

Question 24 of 156

1

Which of the following is not true about working with hierarchies?

Select one of the following:

  • You can display multiple dimensions in a report as a flat presentation or as a hierarchy.

  • InfoObjects can be displayed with hierarchies and infoObjects displayed as a hierarchy

  • By default, hierarchy presentation is displayed.

Explanation

Question 25 of 156

1

Which tabs do you find in the design panel of SAP BO Analysis, edition for Microsoft Office?

Select one or more of the following:

  • Components

  • Information

  • Data Source

  • Workbook

  • Analysis

Explanation

Question 26 of 156

1

How can you navigate in SAP BO Analysis, edition for Microsoft Excel?

Select one or more of the following:

  • Use a drag and frop within the crosstab

  • Use a drag and drop between the design panel and the crosstab

  • Use a drag and drop within the design panel

  • Use double click

  • Use the context menu

  • Use the standard Excel menu functions and icons

  • Use the Analysis menu functions and icons

Explanation

Question 27 of 156

1

You cannot save a query in Query designer when it contains errors.

Select one of the following:

  • True
  • False

Explanation

Question 28 of 156

1

Show dropdown options

Select one or more of the following:

  • History

  • Include/Exclude

  • Favorites

  • Single Values

  • Description

  • Value Range

  • Variables

  • Offset

Explanation

Question 29 of 156

1

When a query is refreshed, result cells are formatted by default so that they are emphasized. Deselect this option to improve query performance or to use your own format templates

Select one of the following:

  • Adjust Formatting after Refreshing

  • Hide Repeated key Values

  • Display Scaling Factors for Key Figures

  • Document Links

Explanation

Question 30 of 156

1

Select from the dropdown list to complete the text.

( Variable Sequence tab, Sequence Variable tab, Variable tab, Value Display tab ) lets you change sequence of variables to ensure that they are presented to the user in a logical order

Explanation

Question 31 of 156

1

It specifies where to position results in rows and columns. By default, row results are presented below the results and columns are presented at the right hand side.

Select one of the following:

  • Results Position in Rows/Columns tab

  • Suppress Zeros in Rows/Columns tab

  • Results Position in Value tab

  • Suppress Zeros in Value tab

Explanation

Question 32 of 156

1

Which of the following is not included in Query Properties?

Select one of the following:

  • General

  • Variable Sequence

  • Display

  • Rows/Columns

  • Value Display

  • Planning

  • Extended

  • Query

Explanation

Question 33 of 156

1

are available in Planning tab.

Select option below to complete the highlighted text

    Display mode and Change mode
    Read mode and Change mode
    Read mode and Edit mode
    Display mode and Edit mode

Explanation

Question 34 of 156

1

Access by Easy Query allows you to release an existing query for external. The queries are static without formatting settings that you can use as Simple Object Access Protocol (SOAP) services. You can manage queries using Easy Query Manager in BW using transaction

Select option below to complete the highlighted text

    EQMANAGER
    EMANAGER
    RSMGR
    EMGR

Explanation

Question 35 of 156

1

It is used as a Web protocol for querying and updating data. It applies and builds upon Web technologies such as HTTP, Atom Publisiging Protocol (AtomPub) and JSON to provide access to information from a variety of applications.

Select one or more of the following:

  • OData

  • OPU-GW

  • Gateway

  • Easy Access

  • OLE DB for OLAP

Explanation

Question 36 of 156

1

If the query is based on an infoProvider for which data has already been stored in a , select this option so that the stored data is read and displayed when the query is run.

Select option below to complete the highlighted text

    near-line storage
    cube
    multiprovider
    BW system

Explanation

Question 37 of 156

1

By selecting and combining the InfoObjects in a query, you determine the way in which data from an InfoProvider is evaluated.

Select one of the following:

  • True
  • False

Explanation

Question 38 of 156

1

In what order do you perform these steps to open an existing query using the Query Designer seach function?

Select one of the following:

  • Ensure the search in Description is selected → On the Open Query: Select Query screen, enter the description in the empty field → Choose Find → In the Query Designer toolbar, choose Query, then Open

  • In the Query Designer toolbar, choose Query, then Open → On the Open Query: Select Query screen, enter the description in the empty field → Ensure the search in Description is selected → Choose Find

  • In the Query Designer toolbar, choose Query, then Open → Ensure the search in Description is selected → On the Open Query: Select Query screen, enter the description in the empty field → Choose Find

Explanation

Question 39 of 156

1

Select from the dropdown list to complete the text.

( Tasks, Check Query, Exit and Use the Query, Where-used ) displays the actions that are valid for the query object you have selected

Explanation

Question 40 of 156

1

When you make changes to a quer level filter, it affects all queries in which the same filteris used.

Select one of the following:

  • True
  • False

Explanation

Question 41 of 156

1

Select from the dropdown list to complete the text.

( Extended, General, Variable sequence, Planning, Rows/Columns, Display, Value Display ) allow external Access to the query

Explanation

Question 42 of 156

1

is where you choose how to present negative values

Select option below to complete the highlighted text

    Value Display
    Display
    General
    Plannng
    Extended

Explanation

Question 43 of 156

1

Select from the dropdown list to complete the text.

( Display tab, Value Display tab, Extended tab, Planning tab, General tab ) includes scaling factors in a row or a column header

Explanation

Question 44 of 156

1

Select from the dropdown list to complete the text.

In ( General tab, Display tab, Display Value tab, Rows/Columns tab ), you view the infoProvider to which the query is assigned.

Explanation

Question 45 of 156

1

To restrict a Characteristic, drag the characteristics values from the InfoProvider section to the required section , right click the characteristic to open context menu and choose Restrict, or double-click the characteristic in the Characteristic Restrictions section or Default Values section to launch the default task

Select one of the following:

  • True
  • False

Explanation

Question 46 of 156

1

A restricted key figure may be based on a basic key figure, a calculated key figure, a key figure that is already restricted and even characteristic value

Select one of the following:

  • True
  • False

Explanation

Question 47 of 156

1

To activate constant selection, select Constant Selection from the context menu of the restricting characteristic while editing the restricted key figure.

Select one of the following:

  • True
  • False

Explanation

Question 48 of 156

1

When creating calculated key figures at the infoProvider level, you do not have access to all operators because some operators are only active at query level.

Select one of the following:

  • True
  • False

Explanation

Question 49 of 156

1

What function would you use when you want to calculate values without units?

Select one of the following:

  • Value Without Dimension

  • Counts

  • NDIV0

  • Result

  • Overall Result

  • Report Result

Explanation

Question 50 of 156

1

Which of the following are available as operators when creating calculated figures?

Select one or more of the following:

  • Mathematical functions

  • Percentage Functions

  • Data Functions

  • Bolean Functions

  • Basic Functions

  • Trigonometric Functions

  • Algebra Functions

Explanation

Question 51 of 156

1

Calculates how high the percentage share is in relation to the result where result means the results of aggregation at the next level. (interim result)

Select one of the following:

  • Percentage Share of Result %CT

  • Percentage Share of Overall Result %GT

  • Percentage Share of Query Result %RT

  • Percentahe Variance %

  • Percentage Share %A

  • Percentage Share of Result along the columns %XT

  • Percentage Share of Result along the rows %YT

Explanation

Question 52 of 156

1

Percentage Share of Query Results %RT calculates how high the percentage share is in relation to the overall result and dynamic filters are included in the calculation of the overall result.

Select one of the following:

  • True
  • False

Explanation

Question 53 of 156

1

Length limitation of characters in your description including line breakers

Select one of the following:

  • 60

  • 65

  • 70

  • No limitation

Explanation

Question 54 of 156

1

As a prerequisit for currency translation, there must be existing currency translation tyes via the transaction .

Select option below to complete the highlighted text

    RSCUR
    EQMANAGER
    RSRT
    RSA1

Explanation

Question 55 of 156

1

When you apply a navigation filter to a restricted key figure,the restricted key figure remains the same in the result.

Select one of the following:

  • True
  • False

Explanation

Question 56 of 156

1

Which statements are incorrect regarding InfoProvider level calculated key figures?

Select one or more of the following:

  • You can include basic key figures, restricted key figures, and calculated key figures that have been defined at the query level.

  • You have access to all operators

  • You must drag the calculated key figure to the section where it should be used in your query.

  • You can define missing objects directly on the Change Formula screen.

Explanation

Question 57 of 156

1

Which one of the following is NOT a percentage function that is available as an operator in BEx Query Designer?

Select one of the following:

  • Percentage Share of Result

  • Percentage Share of Overall Result

  • Percentage Share of Report Result

  • Percentage Share of InfoProvider Result

Explanation

Question 58 of 156

1

Which one of these values does a Boolean Operator deliver in a BEx query formula when it is true?

Select one of the following:

  • 0

  • 1

  • True

  • Then

Explanation

Question 59 of 156

1

When you override a default setting, InfoObject metadata cannot be retrieved and the default cannot be restored.

Select one of the following:

  • True
  • False

Explanation

Question 60 of 156

1

Scaling Factor is in tab

Select option below to complete the highlighted text

    Display
    Extended tab
    Value Display tab
    Planning

Explanation

Question 61 of 156

1

Status node is in tab

Select option below to complete the highlighted text

    Display
    Value Display
    Extended
    Planning

Explanation

Question 62 of 156

1

Formula Collision is in tab

Select option below to complete the highlighted text

    Extended
    Display
    Value Display
    Planning

Explanation

Question 63 of 156

1

Change Data is in tab

Select option below to complete the highlighted text

    Planning
    Value Display
    Display
    Extended

Explanation

Question 64 of 156

1

Which one of the following aggregation options must you define as an exception aggregation?

Select one of the following:

  • Summation

  • Average

  • Minimum

  • Maximum

Explanation

Question 65 of 156

1

To create a key figure structure, right click on the key figure to open its context menu and choose Create Structure.

Select one of the following:

  • True
  • False

Explanation

Question 66 of 156

1

What do you have to consider when you create a query with multiple structures?

Select one or more of the following:

  • You must use a maximum of two structures

  • You must use one structure in the report columns and one structure the report rows.

  • You can only use one key figure structure in a query

  • You can only use one structure without key figures in a query

Explanation

Question 67 of 156

1

By default, the formula that was created first will be used when there is a formula collision .

Select one of the following:

  • True
  • False

Explanation

Question 68 of 156

1

Which of the following can you do in the BEx Query Designer Cell Editor?

Select one or more of the following:

  • Use a cell as referencecell so that it can be referenced in calculations.

  • Define help cells that contain comments for formulas in the report.

  • Apply cell formulas or selection conditionsto any cell in your Analysis report.

  • Define formulas and selection conditions for cells to pberride the automatically created cell values.

Explanation

Question 69 of 156

1

which of the following options are In Display tab for Characteristics?

Select one or more of the following:

  • Display As

  • Text view

  • Sorting

  • Result Rows

  • Display Level

  • Filter Value Selection at Query Execution

  • Access Type for Result Values

  • Hierarchy level

Explanation

Question 70 of 156

1

If you choose to display Text, Text and Key, or Key and Text in the Display As field, choose the length of text in what field?

Select one of the following:

  • Text View

  • Display As

  • Sorting

  • Sort by

  • Display level

Explanation

Question 71 of 156

1

Under Results Rows, which display option for results that only display the result if there is more than one value and there is something to total?

Select one of the following:

  • Always Display

  • Display if More than one value

  • Always Suppress

  • Hide

Explanation

Question 72 of 156

1

In Display tab for Characteristic, Which are the options available in Display Level?

Select one or more of the following:

  • In simple overview

  • In normal overview

  • Only in detail overview

  • Final Overview

  • Display if more than One Value

Explanation

Question 73 of 156

1

with Planning tab for Characteristic, you can plan the characteristic on hierarchy nodes within SAP BW Integrated Planning

Select one of the following:

  • True
  • False

Explanation

Question 74 of 156

1

Which property tab for Characteristic restricts the display of query result and specify how filter values are to be selected for query execution?

Select one of the following:

  • General

  • Extended

  • Planning

  • Display

  • Hierarchy

Explanation

Question 75 of 156

1

Which of the following access types is related to form-based planning?

Select one of the following:

  • Posted Values

  • Characteristic Relationship

  • Master Data

Explanation

Question 76 of 156

1

Which of the following access types is used to display all characteristic values from the master data, independent of transaction data?

Select one of the following:

  • Posted Values

  • Characteristic Relationship

  • Master Data

Explanation

Question 77 of 156

1

Which is not an option for Filter Value Selection at Query Execution?

Select one of the following:

  • Only Posted Value for Navigation

  • Only Values in InfoProvider

  • Characteristic Relationship

  • Values in Master Data table

  • Only Characteristic Values in InfoProvider

Explanation

Question 78 of 156

1

Fill the blank space to complete the text.

is where you assign attributes to Characteristics and maintain attributes as display attributes only or as navigation attributes.

Explanation

Question 79 of 156

1

What you must do to use an attribute as a navigation attribute?

Select one or more of the following:

  • Identify the attribute as a navigation attribute in the InfoObject maintenance of the characteristic.

  • Select the attribute froom the list of possible navigation attributes in the InfoProvider maintenance.

  • In the display tab for Characteristic, select the attribute as a navigation attribute

  • In the infoObject maintenance screen in Query designer, select the attribute as a navigation attribute

Explanation

Question 80 of 156

1

It enables you to view current transactional data with past attribute values using Key date to determine which values of the attribute data are applied in the report.

Select one of the following:

  • Time-dependent attribute

  • Time independent attribute

Explanation

Question 81 of 156

1

To display Characteristics as hierarchies in rows and columns, go to the Properties Pane for the . In the General tab, select Display as Hierarchy.

Select option below to complete the highlighted text

    rows/columns heading
    key figure
    characteristic
    query

Explanation

Question 82 of 156

1

Which of the following are the Hierarchy options?

Select one or more of the following:

  • Display characteristics in rows or in columns as hierarchy

  • Select an external hierarchy for a characteristic

  • Define how hierarchy is displayed

  • Use external hierarchies to make restrictions

  • Configure a hierarchical display within structures

  • Combine hierarchies and structures

  • Delete a hierarchy within structures

Explanation

Question 83 of 156

1

A hierarchy data is a master data belonging to a key figure and dependent of whether it is loaded to or created in SAP BW.

Select one of the following:

  • True
  • False

Explanation

Question 84 of 156

1

The data in External hierarchies are not part of the infoProvider on which your query is based. External hierarchies may be loaded from source systems by using predefined SAP BW content data flows or flat file interface.

Select one of the following:

  • True
  • False

Explanation

Question 85 of 156

1

External hierarchies behave olike a master data and can be used in all InfoProviders that contain the hierarchy characteristic.

Select one of the following:

  • True
  • False

Explanation

Question 86 of 156

1

Which of the following is not an options for Hierarchy property?

Select one of the following:

  • Expand level

  • Position of lower level nodes

  • Values of Posted Nodes

  • Nodes with Only One Lower Level node

  • Sorting

  • Posted values for InfoProvider

Explanation

Question 87 of 156

1

You cannot sort in descending or ascending order if you have select .

Select option below to complete the highlighted text

    Sort by As in Hierarchy
    Sort by Key
    Sort by Text
    Sort by Text and Sort by Key

Explanation

Question 88 of 156

1

When you restrict a characteristic to one hierarchy node and you want it to display as a display hierarchy, go to properties pane and select display hierarchy

Select one of the following:

  • True
  • False

Explanation

Question 89 of 156

1

Which of the following are the componentsof an external hierarchy?

Select one or more of the following:

  • Nodes

  • Leaves

  • Hierarchy levels

  • Intervals

  • Basic Characteristic

  • Attribute

  • Characteristic with Compounded Characteristic

Explanation

Question 90 of 156

1

relate to the basic characteristic on which the hierarchy is based. You can extract transaction data from the data target.

Select option below to complete the highlighted text

    Postable nodes
    Non-Postable nodes

Explanation

Question 91 of 156

1

Hierarchy leaves contain characteristic values for the basic characterictic and may have entries in the fact table

Select one of the following:

  • True
  • False

Explanation

Question 92 of 156

1

Hierarchy intervals contain more than one leaf that belong together,described by their upper and lower limits.

Select one of the following:

  • True
  • False

Explanation

Question 93 of 156

1

What options do you have when you have hierarchy nodes or leaves appear serveral times under different superordinate nodes?

Select one or more of the following:

  • Make the hierarchy sturcture time-dependent

  • Make the hierarchy structure time-independent

  • Set the nodes as link nodes

  • Unlink the nodes

Explanation

Question 94 of 156

1

You need to create a report that shows non-selling materials. With which option in BEx Query Designer can you display characteristic values without transaction data in the report?

Select one of the following:

  • Change the access type for result values to master data

  • Choose only InfoProvider values as the filter value selection at query execution

  • Create a formula with the operator set as Show all values

  • Choose Display all values in the Display tab.

Explanation

Question 95 of 156

1

Steps to display characteristics as a hierarchy in report rows.

Select one of the following:

  • In BEx Query Designer, select the Rows heading in the rows section → Go to Properties pane on the right-hand side of the Query designer → on the General tab, select Display as Hierarchy

  • In BEx Query Designer, select the Rows heading in the rows section → Go to Properties pane on the right-hand side of the Query designer → on the Hierarchy tab, select Display as Hierarchy

  • In BEx Query Designer, select the Rows heading in the rows section → Go to Properties pane on the right-hand side of the Query designer → on the Planning tab, select Display as Hierarchy

Explanation

Question 96 of 156

1

To display structure elements in a query hierarchically, you must activate the Display as Hierarchy option in the Query Designer Rows or Columns section

Select one of the following:

  • True
  • False

Explanation

Question 97 of 156

1

Which one of the following statement regarding external hierarchies is correct? External hierarchies contain data from:

Select one of the following:

  • External source system

  • Other queries in SAP BW

  • The master data tables of a basic characteristic

  • The hierarchy dimension table of an infoCube

Explanation

Question 98 of 156

1

You can sort the members of an external hierarchy in ascending or descing order

Select one of the following:

  • True
  • False

Explanation

Question 99 of 156

1

Steps on how to restrict a Characteristic with an external hierarchy

Select one of the following:

  • Right click on a characteristic to open the context menu and choose Restrict → Move your selection to the Chosen Selections section → Select a hierarchy and select the hierarchy node → In BEx Query designer Filter view, go to the Default Values section.

  • In BEx Query designer Filter view, go to the Default Values section → Right-click on a characteristic to open the context menu and choose Restrict → Select a hierarchy and select the hierarchy node → Move your selection to the Chosen Selections section

  • In BEx Query designer Filter view, go to the Default Values section → Right-click on a characteristic to open the context menu and choose Restrict → Move your selection to the Chosen Selections section → Select a hierarchy and select the hierarchy node

Explanation

Question 100 of 156

1

are postable nodes that have subordinate postable nodes

Select option below to complete the highlighted text

    Inner nodes
    Non-postable nodes
    Root nodes
    Level nodes
    Outer nodes

Explanation

Question 101 of 156

1

When new characteristic values are added to master data, the values will be automatically assigned to this component if they have been included in the relevant range.

Select one of the following:

  • Interval

  • Postable node

  • None Postable nodes

  • Root

Explanation

Question 102 of 156

1

You can extract transaction data from a data target for this component

Select one of the following:

  • Interval

  • Postable node

  • None Postable nodes

  • Root

Explanation

Question 103 of 156

1

This component relates to text nodes that you can include in a hierarchy.

Select one of the following:

  • Interval

  • Postable node

  • None Postable nodes

  • Root

Explanation

Question 104 of 156

1

This component is the uppermost node in a hierarchy structure

Select one of the following:

  • Interval

  • Postable node

  • None Postable nodes

  • Root

Explanation

Question 105 of 156

1

What of the following is not an option for settings for External Hierarchy on the InfoObject level?

Select one of the following:

  • Hierarchies, version-dependent

  • Hierarchy, not time-dependent

  • Entire hierarchy is time-dependent

  • Time-dependent hierarchy structure

  • Use Temporal Hierarchy Join

  • Interval Permitted in Hierarchy

  • Hierarchy, versioning data

  • Reverse +/- Sign for the Node

Explanation

Question 106 of 156

1

Variables do not depend on InfoProviders but on the InfoObjects for which they were created

Select one of the following:

  • True
  • False

Explanation

Question 107 of 156

1

Formula variables are available in all infoProviders and are independent of InfoProviders and dependent of infoObjects

Select one of the following:

  • True
  • False

Explanation

Question 108 of 156

1

Which Reporting tools support Variables?

Select one or more of the following:

  • Analysis, edition for Microsoft Office and edition for OLAP

  • SAP Crystal Reports

  • WEBi

  • Dashboards

  • Design Stuio

  • IDT

Explanation

Question 109 of 156

1

Which of the following variable types support Authorization processing type?

Select one or more of the following:

  • Characteristic Value

  • Text

  • Formula

  • Hierarchy

  • Hierarchy Node

Explanation

Question 110 of 156

1

Which of the following variable types support Replacement path processing type?

Select one or more of the following:

  • Characteristic Value

  • Text

  • Formula

  • Hierarchy

  • Hierarchy Value

Explanation

Question 111 of 156

1

Which of the following variable property tab where you enter the name of the variable, choose InfoProvider level settings such as what processing type will be used, Manual Input or Default Value, Replacement Path, Customer Exit or Authorization?

Select one of the following:

  • General

  • Replacement Path

  • Details

  • Detail Values

  • Currency/Unit

Explanation

Question 112 of 156

1

Which of the following can you select as a replacement value for a text or formula variable? Replacement Variable With

Select one or more of the following:

  • Key (Internal value)

  • Label (Text)

  • External Characteristic Value of the Key

  • Attribute Value

  • Hierarchy Attribue

  • Hierarchy Node attribute

Explanation

Question 113 of 156

1

determines whether the from-value, the to-value, or the difference is used when the value to be replaced is an interval

Select option below to complete the highlighted text

    Use Interval
    Interval Management
    Interval values

Explanation

Question 114 of 156

1

determines the start and length of the text output

Select option below to complete the highlighted text

    Offset start and Offset length
    Offsetting
    Offset Range
    Offset Value

Explanation

Question 115 of 156

1

The option Evaluate as Boolean (value 0 or 1) is only available for text variables.

Select one of the following:

  • True
  • False

Explanation

Question 116 of 156

1

Characteristic Value Variables with Replacement Processing Typ are replaced by a query result. You cannot reuse the result in another query as a pre-query because it contributes to slow performance. Instead, use a variable that represents a pre-calculated value set so that the variable are stored over time

Select one of the following:

  • True
  • False

Explanation

Question 117 of 156

1

Usage options for Characteristic Value Variables

Select one or more of the following:

  • RKFs

  • CKFs

  • Filter Values

Explanation

Question 118 of 156

1

Which of the following are the prerequisites for the target variable when replacing a text variable with another variable?

Select one or more of the following:

  • Must not be input ready

  • Must represent a single value

  • Must not be a hierarchy node variable

  • Must be input ready

  • Must be available in the query

Explanation

Question 119 of 156

1

Which of the following are the prerequisites for the source variable when replacing a text variable with another variable?

Select one or more of the following:

  • Must be a characteristic value variable, a hierarchy variable, a text variable or a formula variable

  • Must be a characteristic value variable, a hierarchy node variable, a text variable or a formula variable

  • Must not be a hierarchy node variable

  • Must be input-ready

  • Must be available in the query

  • Must represent a single value or an interval

  • Must represent a single value

Explanation

Question 120 of 156

1

To change the variable values, you can select a cell in the report, and in the Data Analysis tooset of the Analysis Ribbon, .

Select option below to complete the highlighted text

    choose Prompts → Prompts for Data Source
    choose Variables → Prompts
    choose Prompts → Change Prompts
    choose Prompts → Prompts for Workbook

Explanation

Question 121 of 156

1

How can you use formula variables?

Select one or more of the following:

  • As operands for local calculations in reports

  • As operands in formulas that are retrieved via replacement path

  • As threshold values in exceptions

  • As key values for characteristic restrictions

Explanation

Question 122 of 156

1

SAP Exit is a variable processing type that is only available in SAP BI Content variables

Select one of the following:

  • True
  • False

Explanation

Question 123 of 156

1

A characteristic value variable for the characteristic 0CALQUARTER that shows the current quarter, will show the same quarter of the last year when you enter an offset of -12

Select one of the following:

  • True
  • False

Explanation

Question 124 of 156

1

Use these steps to outline the process for transferring values between queries witha characteristic value variable that has the replacement path processing type

Select one of the following:

  • Select a characteristic → Create new variable → Choose the Replacement Path processing type → Select a pre-query as the replacement value for the variable → Execute the result query

  • Select a characteristic → Create new variable → Choose the Replacement Path processing type → Select a sub-query as the replacement value for the variable → Execute the result query

  • Select a characteristic or an attribute → Create new variable → Choose the Replacement Path processing type → Select a sub-query as the replacement value for the variable → Execute the result query

Explanation

Question 125 of 156

1

Exceptions are defined for key figure values, while conditional formatting is defined for certain cells in the spreadsheet and does not support report navigation

Select one of the following:

  • True
  • False

Explanation

Question 126 of 156

1

Each exception can be applied to one key figure in a query

Select one of the following:

  • True
  • False

Explanation

Question 127 of 156

1

A condition is technically a filter that is applied to key figure values

Select one of the following:

  • True
  • False

Explanation

Question 128 of 156

1

You have created a condition that should show the customers for Top 10 Sales Revenue. You can activate the condition in Analysis but do not see a result. What is the reason?

Select one of the following:

  • The query has not been saved.

  • Conditions are not supported in Analysis

  • You must reset the query in Analysis

  • You must add the customer characteristic to the drill down.

Explanation

Question 129 of 156

1

The exception affects all values except for the aggregated values of the characteristic

Select one of the following:

  • Everything Except Totals

  • Everything

  • Fixed Value

  • Totals Only

Explanation

Question 130 of 156

1

The exception applies for every drill-down state of the Characteristic with no restrictions on cell context

Select one of the following:

  • Everything Except Totals

  • Everything

  • Fixed Value

  • Totals Only

Explanation

Question 131 of 156

1

The exception applies only to a specific characteristic value or characteristic value variable

Select one of the following:

  • Everything Except Totals

  • Everything

  • Fixed Value

  • Totals Only

Explanation

Question 132 of 156

1

The exception affects only the aggregated values of the characteristic

Select one of the following:

  • Everything Except Totals

  • Everything

  • Fixed Value

  • Totals Only

Explanation

Question 133 of 156

1

You can select operators for threshold value conditionsn and for ranked list conditions on the General tab of the Change Condition screen, in the Define Condition Parameters section

Select one of the following:

  • True
  • False

Explanation

Question 134 of 156

1

Using the RRI, you can jump from a report to another report or to a different destination, as long as it is within the SAP BW system

Select one of the following:

  • True
  • False

Explanation

Question 135 of 156

1

Where do you define the sender/receiver assignement for a jump to target?

Select one of the following:

  • In the Query Designer Properties Pane

  • In SAP BW, using RSBBS

  • In the context menu of a report cell in Analysis

  • In the Report/Report Interface

Explanation

Question 136 of 156

1

Which of these settings do you need to enter when creating a jump target in the RRI?

Select one or more of the following:

  • Target System

  • Source System

  • Report Type

  • Receiver Variable

  • Goto

Explanation

Question 137 of 156

1

You can visualize the results of a BEx query with which of these reporting tools?

Select one or more of the following:

  • SAP Crystal Reports for Enterprise

  • Data Warehousing Workbench

  • SAP BusinessObjects BI Platform

  • BEx Analyzer

Explanation

Question 138 of 156

1

BEx Analyzer is the reporting tool of choice for executives because it allows the use of sophistictaed graphical elements to visualize highly aggregated data

Select one of the following:

  • True
  • False

Explanation

Question 139 of 156

1

BEx Web Application Designer and Design Studio allow all information consumers in thec ompany to build individual application for their reporting needs.

Select one of the following:

  • True
  • False

Explanation

Question 140 of 156

1

A practical use case for formatted reporting is an annual report that is centrally created and managed, and distributd to all executives in the company

Select one of the following:

  • True
  • False

Explanation

Question 141 of 156

1

WEBi only allows access to BEx queries when they are store in the BI Platform

Select one of the following:

  • True
  • False

Explanation

Question 142 of 156

1

SAP BusinessObjects Dashboards is the tool of choice for graphical visualizations of aggregated data. Dashboards are often build on queries with a very small result set.

Select one of the following:

  • True
  • False

Explanation

Question 143 of 156

1

Which of the following tools can consume BEx Queries?

Select one or more of the following:

  • SAP BEx Web Analyzer

  • SAP BEx Report Designer

  • SAP BEx Web application Designer

  • Design studio

  • CR for 2013

  • CR for enterprise

  • WEBi

  • Dashboards

  • Analysis, edition for MS Office and Analysis, edition for OLAP

  • Business Explorer

Explanation

Question 144 of 156

1

OLAP Analysis with BEx Analyzer: Navigation of a query allows you to perform actions such as the following:

Select one or more of the following:

  • Filter Characteristics on a single value

  • Drill down on all values for a characteristic

  • Regroup characteristics and key figures in the rows and columns of the results area

  • Hide key figures

  • None

Explanation

Question 145 of 156

1

If Ready for Input is selected when using a variable configured with authorization processing type, the user will automatically receive data for all values for which they are authorized

Select one of the following:

  • True
  • False

Explanation

Question 146 of 156

1

Which is not included in RSECADMIN: Analysis Authorization

Select one of the following:

  • Management of Analysis Authorizations

  • Query Selection

  • Maintain Authorizations

  • Assign to User Role or Profile

Explanation

Question 147 of 156

1

When a query is selected for a translation, the worklist automatically includes the query objects for translation. The worklist does not include the connected objects such as workbooks

Select one of the following:

  • True
  • False

Explanation

Question 148 of 156

1

Copying Queries between InfoProviders

Select one of the following:

  • Specify Source InfoProvider and Target InfoProvider → Select Objects → Transfer Selections → Compatibility Check → Continue to End

  • Specify Source InfoProvider → Select Objects → Transfer Selections → Compatibility Check → and Target InfoProvider → Continue to End

  • Specify Source InfoProvider → Transfer Selections → Compatibility Check → and Target InfoProvider → Continue to End

Explanation

Question 149 of 156

1

Steps on deleting Query Objects

Select one of the following:

  • Select Object type to delete → Restrict search → Execute to select → Select query elements to delete → Execute to delete

  • Select Object type to delete → Restrict search → Execute to select → Specify Source InfoProvider and Target InfoProvider → Select query elements to delete → Execute to delete

  • Select Object type to delete → Restrict search → Execute to select → Specify Source InfoProvider → Select query elements to delete → Execute to delete

Explanation

Question 150 of 156

1

The Where-Used List also shows references in other queries for other reusable elements such as Characteristic Value Variables, Formula Vairable, and RKF and CKF that were saved on the InfoProvider level

Select one of the following:

  • True
  • False

Explanation

Question 151 of 156

1

Users are creating reports for customers and their sales volumes. Sometimes, they drill down to material to analyze what exactly customers have bought. With which query layout can you optimize the query performance?

Select one of the following:

  • Customer and material in the rows

  • Customer and material in the free characteristics

  • Customer in the rows and material in the free characteristics

  • Material in the rows and customer in the free characteristics

Explanation

Question 152 of 156

1

Which of the following are query read modes for SAP BW queries?

Select one or more of the following:

  • Query to read all data at once

  • Query to read data on refresh

  • Query to read only aggregated data

  • Query to read data during navigation

Explanation

Question 153 of 156

1

The query monitor tests, checks, and manages SAP BW queries. Use the query monitor to test or regenrate queries and query views, and to check or change query properties. With the query monitor you have the option of displaying information about queries.

Select one of the following:

  • True
  • False

Explanation

Question 154 of 156

1

Which considerations should be made for Query Performance Improvent?

Select one or more of the following:

  • Check layout and filter settings in the query definition

  • Use query performance monitoring tools

  • Ensure that read mode is set appropriately

  • Check the data model

  • Design aggregates aligned to common filter requirements

  • Improve performance on the database level

  • Delete unused data in the database level

Explanation

Question 155 of 156

1

Aggregates are necessary if you use SAP BW Accelerator or SAP BW on HANA

Select one of the following:

  • True
  • False

Explanation

Question 156 of 156

1

When you have entered the target system information, you can select the type of report for the receiver report. Which of the following types is NOT available in the Maintain Sender/Receiver Assignment Screen

Select one of the following:

  • BQ Query

  • Web Application (Netweaver 7.0)

  • Web Application (BW 3.x)

  • SAP Crystal Report

  • BW Xcelsius (Dashboard)

  • InfoSet Query (queries on classic InfoSets)

  • SAP Transaction

  • ABAP/4 Report

  • Web Address

  • Intranet

Explanation

Previous
Next