Kopieren und bearbeiten

TBI10

Beschreibung

Quiz am TBI10, erstellt von Hannylou Celestial am 07/11/2017.
Hannylou Celestial
Quiz von Hannylou Celestial, aktualisiert more than 1 year ago
Hannylou Celestial
Erstellt von Hannylou Celestial vor mehr als 6 Jahre
143
1
0

Zusammenfassung der Ressource

Frage 1

Frage
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
Antworten
  • Source Systems
  • Data Warehouse
  • Reporting

Frage 2

Frage
How you will store the data in SAP, which infoProviders you will need, and which levels of storage
Antworten
  • Source Systems
  • Data Warehouse
  • Reporting

Frage 3

Frage
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)
Antworten
  • Operational Data Provisioning (ODP)
  • BW Service API (S-API)
  • DB Connect
  • UD Connect

Frage 4

Frage
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
Antworten
  • Operational Data Provisiong (ODP)
  • BW Service API (S-API)
  • UD Connect
  • DB Connect

Frage 5

Frage
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
Antworten
  • Operational Data Provisioning (ODP)
  • BW Service API (S-API)
  • DB Connect
  • UD Connect

Frage 6

Frage
This accesses relational data sources. The technology runs on the JAVA 2 Platform Enterprise Edition (J2EE) Engine and supports the J2EE Connector Architecture
Antworten
  • Operational Data Provisioning (ODP)
  • BW Service API (S-API)
  • DB Connect
  • UD Connect

Frage 7

Frage
It imports flat files in CSV, ASCII, and XLS formats.
Antworten
  • File Interface
  • Web Services
  • Staging BAPIs
  • SAP Data Services

Frage 8

Frage
It allows to send data o SAP BW under third-party control
Antworten
  • File Interface
  • Web Services
  • Staging BAPIs
  • SAP Data Services

Frage 9

Frage
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
Antworten
  • File Interface
  • Web Services
  • Staging BAPIs
  • SAP Data Services

Frage 10

Frage
It has a tight integration when providing data to SAP BW via Staging BAPIs
Antworten
  • File Interface
  • Web Services
  • Staging BAPIs
  • SAP Data Services

Frage 11

Frage
Analysis can be used without an installed BI Platform
Antworten
  • True
  • False

Frage 12

Frage
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.
Antworten
  • True
  • False

Frage 13

Frage
Which of the following is not supported in Crystal Reports?
Antworten
  • Hierarchy
  • Charts
  • Drill-down
  • Filtering
  • Support for manual entry of values

Frage 14

Frage
Which of the following are the supported data sources of WEBi?
Antworten
  • Universe
  • Excel
  • BEx Query
  • SAP HANA view
  • SAP HANA Online
  • Analysis View
  • Text
  • Web Services
  • Free hand SQL
  • InfoProviders

Frage 15

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

Frage 16

Frage
[blank_start]BEx Query Designer[blank_end] is the basis of data analysis. You create and edit queries to evaluate data from Characteristics and Key Figure obbjects.
Antworten
  • BEx Query Designer
  • BEx Analyzer
  • BEx Web Application Designer
  • BEx Report Designer
  • Information Broadcasting
  • SAP Enterprise portal

Frage 17

Frage
The goal of data warehousing is online analytical processing wit large amount of data of operative and historical data.
Antworten
  • True
  • False

Frage 18

Frage
From which of the following sources can SAP BW extract data directly?
Antworten
  • CSV file
  • MS Word file
  • Relational database system
  • SAP ERP system

Frage 19

Frage
You can use SAP BO Analysis, edition for MIcrosoft excel, to create and edit queries for reports.
Antworten
  • True
  • False

Frage 20

Frage
Stores amount or quantities
Antworten
  • InfoProvider
  • Characteristics InfoObject
  • Key Figure
  • Multiprovider

Frage 21

Frage
The generic term used to describe any objects for which you can create and execute queries in SAP BW
Antworten
  • InfoProvider
  • Characteristics InfoObject
  • Key Figure
  • Multiprovider

Frage 22

Frage
Store master data and is used with key figures to build other infoProvider tables
Antworten
  • InfoProvider
  • Characteristics InfoObject
  • Key Figure
  • Multiprovider

Frage 23

Frage
Provides view of data from multiple InfoProviders
Antworten
  • InfoProvider
  • Characteristics InfoObject
  • Key Figure
  • Multiprovider

Frage 24

Frage
Which of the following is not true about working with hierarchies?
Antworten
  • 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.

Frage 25

Frage
Which tabs do you find in the design panel of SAP BO Analysis, edition for Microsoft Office?
Antworten
  • Components
  • Information
  • Data Source
  • Workbook
  • Analysis

Frage 26

Frage
How can you navigate in SAP BO Analysis, edition for Microsoft Excel?
Antworten
  • 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

Frage 27

Frage
You cannot save a query in Query designer when it contains errors.
Antworten
  • True
  • False

Frage 28

Frage
Show dropdown options
Antworten
  • History
  • Include/Exclude
  • Favorites
  • Single Values
  • Description
  • Value Range
  • Variables
  • Offset

Frage 29

Frage
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
Antworten
  • Adjust Formatting after Refreshing
  • Hide Repeated key Values
  • Display Scaling Factors for Key Figures
  • Document Links

Frage 30

Frage
[blank_start]Variable Sequence tab[blank_end] lets you change sequence of variables to ensure that they are presented to the user in a logical order
Antworten
  • Variable Sequence tab
  • Sequence Variable tab
  • Variable tab
  • Value Display tab

Frage 31

Frage
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.
Antworten
  • Results Position in Rows/Columns tab
  • Suppress Zeros in Rows/Columns tab
  • Results Position in Value tab
  • Suppress Zeros in Value tab

Frage 32

Frage
Which of the following is not included in Query Properties?
Antworten
  • General
  • Variable Sequence
  • Display
  • Rows/Columns
  • Value Display
  • Planning
  • Extended
  • Query

Frage 33

Frage
[blank_start]Display mode and Change mode[blank_end] are available in Planning tab.
Antworten
  • Display mode and Change mode
  • Read mode and Change mode
  • Read mode and Edit mode
  • Display mode and Edit mode

Frage 34

Frage
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 [blank_start]EQMANAGER[blank_end]
Antworten
  • EQMANAGER
  • EMANAGER
  • RSMGR
  • EMGR

Frage 35

Frage
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.
Antworten
  • OData
  • OPU-GW
  • Gateway
  • Easy Access
  • OLE DB for OLAP

Frage 36

Frage
If the query is based on an infoProvider for which data has already been stored in a [blank_start]near-line storage[blank_end], select this option so that the stored data is read and displayed when the query is run.
Antworten
  • near-line storage
  • cube
  • multiprovider
  • BW system

Frage 37

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

Frage 38

Frage
In what order do you perform these steps to open an existing query using the Query Designer seach function?
Antworten
  • 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

Frage 39

Frage
[blank_start]Tasks[blank_end] displays the actions that are valid for the query object you have selected
Antworten
  • Tasks
  • Check Query
  • Exit and Use the Query
  • Where-used

Frage 40

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

Frage 41

Frage
[blank_start]Extended[blank_end] allow external Access to the query
Antworten
  • Extended
  • General
  • Variable sequence
  • Planning
  • Rows/Columns
  • Display
  • Value Display

Frage 42

Frage
[blank_start]Value Display[blank_end] is where you choose how to present negative values
Antworten
  • Value Display
  • Display
  • General
  • Plannng
  • Extended

Frage 43

Frage
[blank_start]Display tab[blank_end] includes scaling factors in a row or a column header
Antworten
  • Display tab
  • Value Display tab
  • Extended tab
  • Planning tab
  • General tab

Frage 44

Frage
In [blank_start]General tab[blank_end], you view the infoProvider to which the query is assigned.
Antworten
  • General tab
  • Display tab
  • Display Value tab
  • Rows/Columns tab

Frage 45

Frage
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
Antworten
  • True
  • False

Frage 46

Frage
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
Antworten
  • True
  • False

Frage 47

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

Frage 48

Frage
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.
Antworten
  • True
  • False

Frage 49

Frage
What function would you use when you want to calculate values without units?
Antworten
  • Value Without Dimension
  • Counts
  • NDIV0
  • Result
  • Overall Result
  • Report Result

Frage 50

Frage
Which of the following are available as operators when creating calculated figures?
Antworten
  • Mathematical functions
  • Percentage Functions
  • Data Functions
  • Bolean Functions
  • Basic Functions
  • Trigonometric Functions
  • Algebra Functions

Frage 51

Frage
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)
Antworten
  • 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

Frage 52

Frage
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.
Antworten
  • True
  • False

Frage 53

Frage
Length limitation of characters in your description including line breakers
Antworten
  • 60
  • 65
  • 70
  • No limitation

Frage 54

Frage
As a prerequisit for currency translation, there must be existing currency translation tyes via the transaction [blank_start]RSCUR[blank_end].
Antworten
  • RSCUR
  • EQMANAGER
  • RSRT
  • RSA1

Frage 55

Frage
When you apply a navigation filter to a restricted key figure,the restricted key figure remains the same in the result.
Antworten
  • True
  • False

Frage 56

Frage
Which statements are incorrect regarding InfoProvider level calculated key figures?
Antworten
  • 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.

Frage 57

Frage
Which one of the following is NOT a percentage function that is available as an operator in BEx Query Designer?
Antworten
  • Percentage Share of Result
  • Percentage Share of Overall Result
  • Percentage Share of Report Result
  • Percentage Share of InfoProvider Result

Frage 58

Frage
Which one of these values does a Boolean Operator deliver in a BEx query formula when it is true?
Antworten
  • 0
  • 1
  • True
  • Then

Frage 59

Frage
When you override a default setting, InfoObject metadata cannot be retrieved and the default cannot be restored.
Antworten
  • True
  • False

Frage 60

Frage
Scaling Factor is in [blank_start]Display[blank_end] tab
Antworten
  • Display
  • Extended tab
  • Value Display tab
  • Planning

Frage 61

Frage
Status node is in [blank_start]Display[blank_end] tab
Antworten
  • Display
  • Value Display
  • Extended
  • Planning

Frage 62

Frage
Formula Collision is in [blank_start]Extended[blank_end] tab
Antworten
  • Extended
  • Display
  • Value Display
  • Planning

Frage 63

Frage
Change Data is in [blank_start]Planning[blank_end] tab
Antworten
  • Planning
  • Value Display
  • Display
  • Extended

Frage 64

Frage
Which one of the following aggregation options must you define as an exception aggregation?
Antworten
  • Summation
  • Average
  • Minimum
  • Maximum

Frage 65

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

Frage 66

Frage
What do you have to consider when you create a query with multiple structures?
Antworten
  • 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

Frage 67

Frage
By default, the formula that was created first will be used when there is a formula collision .
Antworten
  • True
  • False

Frage 68

Frage
Which of the following can you do in the BEx Query Designer Cell Editor?
Antworten
  • 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.

Frage 69

Frage
which of the following options are In Display tab for Characteristics?
Antworten
  • Display As
  • Text view
  • Sorting
  • Result Rows
  • Display Level
  • Filter Value Selection at Query Execution
  • Access Type for Result Values
  • Hierarchy level

Frage 70

Frage
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?
Antworten
  • Text View
  • Display As
  • Sorting
  • Sort by
  • Display level

Frage 71

Frage
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?
Antworten
  • Always Display
  • Display if More than one value
  • Always Suppress
  • Hide

Frage 72

Frage
In Display tab for Characteristic, Which are the options available in Display Level?
Antworten
  • In simple overview
  • In normal overview
  • Only in detail overview
  • Final Overview
  • Display if more than One Value

Frage 73

Frage
with Planning tab for Characteristic, you can plan the characteristic on hierarchy nodes within SAP BW Integrated Planning
Antworten
  • True
  • False

Frage 74

Frage
Which property tab for Characteristic restricts the display of query result and specify how filter values are to be selected for query execution?
Antworten
  • General
  • Extended
  • Planning
  • Display
  • Hierarchy

Frage 75

Frage
Which of the following access types is related to form-based planning?
Antworten
  • Posted Values
  • Characteristic Relationship
  • Master Data

Frage 76

Frage
Which of the following access types is used to display all characteristic values from the master data, independent of transaction data?
Antworten
  • Posted Values
  • Characteristic Relationship
  • Master Data

Frage 77

Frage
Which is not an option for Filter Value Selection at Query Execution?
Antworten
  • Only Posted Value for Navigation
  • Only Values in InfoProvider
  • Characteristic Relationship
  • Values in Master Data table
  • Only Characteristic Values in InfoProvider

Frage 78

Frage
[blank_start]InfoObject Maintenance[blank_end] is where you assign attributes to Characteristics and maintain attributes as display attributes only or as navigation attributes.
Antworten
  • InfoObject Maintenance

Frage 79

Frage
What you must do to use an attribute as a navigation attribute?
Antworten
  • 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

Frage 80

Frage
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.
Antworten
  • Time-dependent attribute
  • Time independent attribute

Frage 81

Frage
To display Characteristics as hierarchies in rows and columns, go to the Properties Pane for the [blank_start]rows/columns heading[blank_end]. In the General tab, select Display as Hierarchy.
Antworten
  • rows/columns heading
  • key figure
  • characteristic
  • query

Frage 82

Frage
Which of the following are the Hierarchy options?
Antworten
  • 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

Frage 83

Frage
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.
Antworten
  • True
  • False

Frage 84

Frage
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.
Antworten
  • True
  • False

Frage 85

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

Frage 86

Frage
Which of the following is not an options for Hierarchy property?
Antworten
  • Expand level
  • Position of lower level nodes
  • Values of Posted Nodes
  • Nodes with Only One Lower Level node
  • Sorting
  • Posted values for InfoProvider

Frage 87

Frage
You cannot sort in descending or ascending order if you have select [blank_start]Sort by As in Hierarchy[blank_end].
Antworten
  • Sort by As in Hierarchy
  • Sort by Key
  • Sort by Text
  • Sort by Text and Sort by Key

Frage 88

Frage
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
Antworten
  • True
  • False

Frage 89

Frage
Which of the following are the componentsof an external hierarchy?
Antworten
  • Nodes
  • Leaves
  • Hierarchy levels
  • Intervals
  • Basic Characteristic
  • Attribute
  • Characteristic with Compounded Characteristic

Frage 90

Frage
[blank_start]Postable nodes[blank_end] relate to the basic characteristic on which the hierarchy is based. You can extract transaction data from the data target.
Antworten
  • Postable nodes
  • Non-Postable nodes

Frage 91

Frage
Hierarchy leaves contain characteristic values for the basic characterictic and may have entries in the fact table
Antworten
  • True
  • False

Frage 92

Frage
Hierarchy intervals contain more than one leaf that belong together,described by their upper and lower limits.
Antworten
  • True
  • False

Frage 93

Frage
What options do you have when you have hierarchy nodes or leaves appear serveral times under different superordinate nodes?
Antworten
  • Make the hierarchy sturcture time-dependent
  • Make the hierarchy structure time-independent
  • Set the nodes as link nodes
  • Unlink the nodes

Frage 94

Frage
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?
Antworten
  • 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.

Frage 95

Frage
Steps to display characteristics as a hierarchy in report rows.
Antworten
  • 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

Frage 96

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

Frage 97

Frage
Which one of the following statement regarding external hierarchies is correct? External hierarchies contain data from:
Antworten
  • External source system
  • Other queries in SAP BW
  • The master data tables of a basic characteristic
  • The hierarchy dimension table of an infoCube

Frage 98

Frage
You can sort the members of an external hierarchy in ascending or descing order
Antworten
  • True
  • False

Frage 99

Frage
Steps on how to restrict a Characteristic with an external hierarchy
Antworten
  • 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

Frage 100

Frage
[blank_start]Inner nodes[blank_end] are postable nodes that have subordinate postable nodes
Antworten
  • Inner nodes
  • Non-postable nodes
  • Root nodes
  • Level nodes
  • Outer nodes

Frage 101

Frage
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.
Antworten
  • Interval
  • Postable node
  • None Postable nodes
  • Root

Frage 102

Frage
You can extract transaction data from a data target for this component
Antworten
  • Interval
  • Postable node
  • None Postable nodes
  • Root

Frage 103

Frage
This component relates to text nodes that you can include in a hierarchy.
Antworten
  • Interval
  • Postable node
  • None Postable nodes
  • Root

Frage 104

Frage
This component is the uppermost node in a hierarchy structure
Antworten
  • Interval
  • Postable node
  • None Postable nodes
  • Root

Frage 105

Frage
What of the following is not an option for settings for External Hierarchy on the InfoObject level?
Antworten
  • 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

Frage 106

Frage
Variables do not depend on InfoProviders but on the InfoObjects for which they were created
Antworten
  • True
  • False

Frage 107

Frage
Formula variables are available in all infoProviders and are independent of InfoProviders and dependent of infoObjects
Antworten
  • True
  • False

Frage 108

Frage
Which Reporting tools support Variables?
Antworten
  • Analysis, edition for Microsoft Office and edition for OLAP
  • SAP Crystal Reports
  • WEBi
  • Dashboards
  • Design Stuio
  • IDT

Frage 109

Frage
Which of the following variable types support Authorization processing type?
Antworten
  • Characteristic Value
  • Text
  • Formula
  • Hierarchy
  • Hierarchy Node

Frage 110

Frage
Which of the following variable types support Replacement path processing type?
Antworten
  • Characteristic Value
  • Text
  • Formula
  • Hierarchy
  • Hierarchy Value

Frage 111

Frage
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?
Antworten
  • General
  • Replacement Path
  • Details
  • Detail Values
  • Currency/Unit

Frage 112

Frage
Which of the following can you select as a replacement value for a text or formula variable? Replacement Variable With
Antworten
  • Key (Internal value)
  • Label (Text)
  • External Characteristic Value of the Key
  • Attribute Value
  • Hierarchy Attribue
  • Hierarchy Node attribute

Frage 113

Frage
[blank_start]Use Interval[blank_end] determines whether the from-value, the to-value, or the difference is used when the value to be replaced is an interval
Antworten
  • Use Interval
  • Interval Management
  • Interval values

Frage 114

Frage
[blank_start]Offset start and Offset length[blank_end] determines the start and length of the text output
Antworten
  • Offset start and Offset length
  • Offsetting
  • Offset Range
  • Offset Value

Frage 115

Frage
The option Evaluate as Boolean (value 0 or 1) is only available for text variables.
Antworten
  • True
  • False

Frage 116

Frage
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
Antworten
  • True
  • False

Frage 117

Frage
Usage options for Characteristic Value Variables
Antworten
  • RKFs
  • CKFs
  • Filter Values

Frage 118

Frage
Which of the following are the prerequisites for the target variable when replacing a text variable with another variable?
Antworten
  • 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

Frage 119

Frage
Which of the following are the prerequisites for the source variable when replacing a text variable with another variable?
Antworten
  • 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

Frage 120

Frage
To change the variable values, you can select a cell in the report, and in the Data Analysis tooset of the Analysis Ribbon, [blank_start]choose Prompts → Prompts for Data Source[blank_end].
Antworten
  • choose Prompts → Prompts for Data Source
  • choose Variables → Prompts
  • choose Prompts → Change Prompts
  • choose Prompts → Prompts for Workbook

Frage 121

Frage
How can you use formula variables?
Antworten
  • 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

Frage 122

Frage
SAP Exit is a variable processing type that is only available in SAP BI Content variables
Antworten
  • True
  • False

Frage 123

Frage
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
Antworten
  • True
  • False

Frage 124

Frage
Use these steps to outline the process for transferring values between queries witha characteristic value variable that has the replacement path processing type
Antworten
  • 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

Frage 125

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

Frage 126

Frage
Each exception can be applied to one key figure in a query
Antworten
  • True
  • False

Frage 127

Frage
A condition is technically a filter that is applied to key figure values
Antworten
  • True
  • False

Frage 128

Frage
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?
Antworten
  • 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.

Frage 129

Frage
The exception affects all values except for the aggregated values of the characteristic
Antworten
  • Everything Except Totals
  • Everything
  • Fixed Value
  • Totals Only

Frage 130

Frage
The exception applies for every drill-down state of the Characteristic with no restrictions on cell context
Antworten
  • Everything Except Totals
  • Everything
  • Fixed Value
  • Totals Only

Frage 131

Frage
The exception applies only to a specific characteristic value or characteristic value variable
Antworten
  • Everything Except Totals
  • Everything
  • Fixed Value
  • Totals Only

Frage 132

Frage
The exception affects only the aggregated values of the characteristic
Antworten
  • Everything Except Totals
  • Everything
  • Fixed Value
  • Totals Only

Frage 133

Frage
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
Antworten
  • True
  • False

Frage 134

Frage
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
Antworten
  • True
  • False

Frage 135

Frage
Where do you define the sender/receiver assignement for a jump to target?
Antworten
  • 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

Frage 136

Frage
Which of these settings do you need to enter when creating a jump target in the RRI?
Antworten
  • Target System
  • Source System
  • Report Type
  • Receiver Variable
  • Goto

Frage 137

Frage
You can visualize the results of a BEx query with which of these reporting tools?
Antworten
  • SAP Crystal Reports for Enterprise
  • Data Warehousing Workbench
  • SAP BusinessObjects BI Platform
  • BEx Analyzer

Frage 138

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

Frage 139

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

Frage 140

Frage
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
Antworten
  • True
  • False

Frage 141

Frage
WEBi only allows access to BEx queries when they are store in the BI Platform
Antworten
  • True
  • False

Frage 142

Frage
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.
Antworten
  • True
  • False

Frage 143

Frage
Which of the following tools can consume BEx Queries?
Antworten
  • 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

Frage 144

Frage
OLAP Analysis with BEx Analyzer: Navigation of a query allows you to perform actions such as the following:
Antworten
  • 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

Frage 145

Frage
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
Antworten
  • True
  • False

Frage 146

Frage
Which is not included in RSECADMIN: Analysis Authorization
Antworten
  • Management of Analysis Authorizations
  • Query Selection
  • Maintain Authorizations
  • Assign to User Role or Profile

Frage 147

Frage
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
Antworten
  • True
  • False

Frage 148

Frage
Copying Queries between InfoProviders
Antworten
  • 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

Frage 149

Frage
Steps on deleting Query Objects
Antworten
  • 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

Frage 150

Frage
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
Antworten
  • True
  • False

Frage 151

Frage
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?
Antworten
  • 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

Frage 152

Frage
Which of the following are query read modes for SAP BW queries?
Antworten
  • 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

Frage 153

Frage
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.
Antworten
  • True
  • False

Frage 154

Frage
Which considerations should be made for Query Performance Improvent?
Antworten
  • 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

Frage 155

Frage
Aggregates are necessary if you use SAP BW Accelerator or SAP BW on HANA
Antworten
  • True
  • False

Frage 156

Frage
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
Antworten
  • 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
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Einstufungstest Englisch
SprachschuleAktiv
Mathe Themen
barbara91
Enzyme
Cornelius Ges
PR UNI WIEN WS 2014/15
magdalena.zoeschg
Architektur und Kunstgeschichte 1 Bilder
Elif Chiquet
Wie schreibe ich eine wissenschaftliche Arbeit
Antonia C
Tierhaltung & Tierhygiene 1
Anne Käfer
Vetie Radiologie 2013
Péroline de Gail
Veti Pharma
Anna Leps
Gesko Werb Fragen
Adrienne Tschaudi
Vetie - Recht 2014
Lena Ru
Bibliothek durchsuchen