Quiz
TBI10
This quiz has question types that open in the usual player.
Questions in this quiz (156)
1Where the data you need is currently stored, how you can access the stored data, and how you can upload the data to SAP BW
- ASource Systems
- BData Warehouse
- CReporting
2How you will store the data in SAP, which infoProviders you will need, and which levels of storage
- ASource Systems
- BData Warehouse
- CReporting
3Which 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)
- AOperational Data Provisioning (ODP)
- BBW Service API (S-API)
- CDB Connect
- DUD Connect
4It 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
- AOperational Data Provisiong (ODP)
- BBW Service API (S-API)
- CUD Connect
- DDB Connect
5It 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
- AOperational Data Provisioning (ODP)
- BBW Service API (S-API)
- CDB Connect
- DUD Connect
6This accesses relational data sources. The technology runs on the JAVA 2 Platform Enterprise Edition (J2EE) Engine and supports the J2EE Connector Architecture
- AOperational Data Provisioning (ODP)
- BBW Service API (S-API)
- CDB Connect
- DUD Connect
7It imports flat files in CSV, ASCII, and XLS formats.
- AFile Interface
- BWeb Services
- CStaging BAPIs
- DSAP Data Services
8It allows to send data o SAP BW under third-party control
- AFile Interface
- BWeb Services
- CStaging BAPIs
- DSAP Data Services
9It 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
- AFile Interface
- BWeb Services
- CStaging BAPIs
- DSAP Data Services
10It has a tight integration when providing data to SAP BW via Staging BAPIs
- AFile Interface
- BWeb Services
- CStaging BAPIs
- DSAP Data Services
11Analysis can be used without an installed BI Platform
- ATrue
- BFalse
12In SAP Netweaver mode, functions like single sign-on and saving workbooks cannot be provided from SAP BW without using BI Platform as a server.
- ATrue
- BFalse
13Which of the following is not supported in Crystal Reports?
- AHierarchy
- BCharts
- CDrill-down
- DFiltering
- ESupport for manual entry of
values
14Which of the following are the supported data sources of WEBi?
- AUniverse
- BExcel
- CBEx Query
- DSAP HANA view
- ESAP HANA Online
- FAnalysis View
- GText
- HWeb Services
- IFree hand SQL
- JInfoProviders
15Users can continue working with WEBi document (.wid) files, even when they are not connected to a CMS.
- ATrue
- BFalse
16[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.
- ABEx Query Designer
- BBEx Analyzer
- CBEx Web Application Designer
- DBEx Report Designer
- EInformation Broadcasting
- FSAP Enterprise portal
17The goal of data warehousing is online analytical processing wit large amount of data of operative and historical data.
- ATrue
- BFalse
18From which of the following sources can SAP BW extract data directly?
- ACSV file
- BMS Word file
- CRelational database system
- DSAP ERP system
19You can use SAP BO Analysis, edition for MIcrosoft excel, to create and edit queries for reports.
- ATrue
- BFalse
20Stores amount or quantities
- AInfoProvider
- BCharacteristics InfoObject
- CKey Figure
- DMultiprovider
21The generic term used to describe any objects for which you can create and execute queries in SAP BW
- AInfoProvider
- BCharacteristics InfoObject
- CKey Figure
- DMultiprovider
22Store master data and is used with key figures to build other infoProvider tables
- AInfoProvider
- BCharacteristics InfoObject
- CKey Figure
- DMultiprovider
23Provides view of data from multiple InfoProviders
- AInfoProvider
- BCharacteristics InfoObject
- CKey Figure
- DMultiprovider
24Which of the following is not true about working with hierarchies?
- AYou can display multiple dimensions in a report as a flat presentation or as a hierarchy.
- BInfoObjects can be displayed with hierarchies and infoObjects displayed as a hierarchy
- CBy default, hierarchy presentation is displayed.
25Which tabs do you find in the design panel of SAP BO Analysis, edition for Microsoft Office?
- AComponents
- BInformation
- CData Source
- DWorkbook
- EAnalysis
26How can you navigate in SAP BO Analysis, edition for Microsoft Excel?
- AUse a drag and frop within the crosstab
- BUse a drag and drop between the design panel and the crosstab
- CUse a drag and drop within the design panel
- DUse double click
- EUse the context menu
- FUse the standard Excel menu functions and icons
- GUse the Analysis menu functions and icons
27You cannot save a query in Query designer when it contains errors.
- ATrue
- BFalse
28Show dropdown options
- AHistory
- BInclude/Exclude
- CFavorites
- DSingle Values
- EDescription
- FValue Range
- GVariables
- HOffset
29When 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
- AAdjust Formatting after Refreshing
- BHide Repeated key Values
- CDisplay Scaling Factors for Key Figures
- DDocument Links
30[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
- AVariable Sequence tab
- BSequence Variable tab
- CVariable tab
- DValue Display tab
31It 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.
- AResults Position in Rows/Columns tab
- BSuppress Zeros in Rows/Columns tab
- CResults Position in Value tab
- DSuppress Zeros in Value tab
32Which of the following is not included in Query Properties?
- AGeneral
- BVariable Sequence
- CDisplay
- DRows/Columns
- EValue Display
- FPlanning
- GExtended
- HQuery
33[blank_start]Display mode and Change mode[blank_end] are available in Planning tab.
- ADisplay mode and Change mode
- BRead mode and Change mode
- CRead mode and Edit mode
- DDisplay mode and Edit mode
34Access 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]
- AEQMANAGER
- BEMANAGER
- CRSMGR
- DEMGR
35It 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.
- AOData
- BOPU-GW
- CGateway
- DEasy Access
- EOLE DB for OLAP
36If 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.
- Anear-line storage
- Bcube
- Cmultiprovider
- DBW system
37By selecting and combining the InfoObjects in a query, you determine the way in which data from an InfoProvider is evaluated.
- ATrue
- BFalse
38In what order do you perform these steps to open an existing query using the Query Designer seach function?
- AEnsure 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
- BIn 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
- CIn 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
39[blank_start]Tasks[blank_end] displays the actions that are valid for the query object you have selected
- ATasks
- BCheck Query
- CExit and Use the Query
- DWhere-used
40When you make changes to a quer level filter, it affects all queries in which the same filteris used.
- ATrue
- BFalse
41[blank_start]Extended[blank_end] allow external Access to the query
- AExtended
- BGeneral
- CVariable sequence
- DPlanning
- ERows/Columns
- FDisplay
- GValue Display
42[blank_start]Value Display[blank_end] is where you choose how to present negative values
- AValue Display
- BDisplay
- CGeneral
- DPlannng
- EExtended
43[blank_start]Display tab[blank_end] includes scaling factors in a row or a column header
- ADisplay tab
- BValue Display tab
- CExtended tab
- DPlanning tab
- EGeneral tab
44In [blank_start]General tab[blank_end], you view the infoProvider to which the query is assigned.
- AGeneral tab
- BDisplay tab
- CDisplay Value tab
- DRows/Columns tab
45To 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
- ATrue
- BFalse
46A 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
- ATrue
- BFalse
47To activate constant selection, select Constant Selection from the context menu of the restricting characteristic while editing the restricted key figure.
- ATrue
- BFalse
48When 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.
- ATrue
- BFalse
49What function would you use when you want to calculate values without units?
- AValue Without Dimension
- BCounts
- CNDIV0
- DResult
- EOverall Result
- FReport Result
50Which of the following are available as operators when creating calculated figures?
- AMathematical functions
- BPercentage Functions
- CData Functions
- DBolean Functions
- EBasic Functions
- FTrigonometric Functions
- GAlgebra Functions
51Calculates how high the percentage share is in relation to the result where result means the results of aggregation at the next level. (interim result)
- APercentage Share of Result %CT
- BPercentage Share of Overall Result %GT
- CPercentage Share of Query Result %RT
- DPercentahe Variance %
- EPercentage Share %A
- FPercentage Share of Result along the columns %XT
- GPercentage Share of Result along the rows %YT
52Percentage 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.
- ATrue
- BFalse
53Length limitation of characters in your description including line breakers
- A60
- B65
- C70
- DNo limitation
54As a prerequisit for currency translation, there must be existing currency translation tyes via the transaction [blank_start]RSCUR[blank_end].
- ARSCUR
- BEQMANAGER
- CRSRT
- DRSA1
55When you apply a navigation filter to a restricted key figure,the restricted key figure remains the same in the result.
- ATrue
- BFalse
56Which statements are incorrect regarding InfoProvider level calculated key figures?
- AYou can include basic key figures, restricted key figures, and calculated key figures that have been defined at the query level.
- BYou have access to all operators
- CYou must drag the calculated key figure to the section where it should be used in your query.
- DYou can define missing objects directly on the Change Formula screen.
57Which one of the following is NOT a percentage function that is available as an operator in BEx Query Designer?
- APercentage Share of Result
- BPercentage Share of Overall Result
- CPercentage Share of Report Result
- DPercentage Share of InfoProvider Result
58Which one of these values does a Boolean Operator deliver in a BEx query formula when it is true?
- A0
- B1
- CTrue
- DThen
59When you override a default setting, InfoObject metadata cannot be retrieved and the default cannot be restored.
- ATrue
- BFalse
60Scaling Factor is in [blank_start]Display[blank_end] tab
- ADisplay
- BExtended tab
- CValue Display tab
- DPlanning
61Status node is in [blank_start]Display[blank_end] tab
- ADisplay
- BValue Display
- CExtended
- DPlanning
62Formula Collision is in [blank_start]Extended[blank_end] tab
- AExtended
- BDisplay
- CValue Display
- DPlanning
63Change Data is in [blank_start]Planning[blank_end] tab
- APlanning
- BValue Display
- CDisplay
- DExtended
64Which one of the following aggregation options must you define as an exception aggregation?
- ASummation
- BAverage
- CMinimum
- DMaximum
65To create a key figure structure, right click on the key figure to open its context menu and choose Create Structure.
- ATrue
- BFalse
66What do you have to consider when you create a query with multiple structures?
- AYou must use a maximum of two structures
- BYou must use one structure in the report columns and one structure the report rows.
- CYou can only use one key figure structure in a query
- DYou can only use one structure without key figures in a query
67By default, the formula that was created first will be used when there is a formula collision .
- ATrue
- BFalse
68Which of the following can you do in the BEx Query Designer Cell Editor?
- AUse a cell as referencecell so that it can be referenced in calculations.
- BDefine help cells that contain comments for formulas in the report.
- CApply cell formulas or selection conditionsto any cell in your Analysis report.
- DDefine formulas and selection conditions for cells to pberride the automatically created cell values.
69which of the following options are In Display tab for Characteristics?
- ADisplay As
- BText view
- CSorting
- DResult Rows
- EDisplay Level
- FFilter Value Selection at Query Execution
- GAccess Type for Result Values
- HHierarchy level
70If 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?
- AText View
- BDisplay As
- CSorting
- DSort by
- EDisplay level
71Under 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?
- AAlways Display
- BDisplay if More than one value
- CAlways Suppress
- DHide
72In Display tab for Characteristic, Which are the options available in Display Level?
- AIn simple overview
- BIn normal overview
- COnly in detail overview
- DFinal Overview
- EDisplay if more than One Value
73with Planning tab for Characteristic, you can plan the characteristic on hierarchy nodes within SAP BW Integrated Planning
- ATrue
- BFalse
74Which property tab for Characteristic restricts the display of query result and specify how filter values are to be selected for query execution?
- AGeneral
- BExtended
- CPlanning
- DDisplay
- EHierarchy
75Which of the following access types is related to form-based planning?
- APosted Values
- BCharacteristic Relationship
- CMaster Data
76Which of the following access types is used to display all characteristic values from the master data, independent of transaction data?
- APosted Values
- BCharacteristic Relationship
- CMaster Data
77Which is not an option for Filter Value Selection at Query Execution?
- AOnly Posted Value for Navigation
- BOnly Values in InfoProvider
- CCharacteristic Relationship
- DValues in Master Data table
- EOnly Characteristic Values in InfoProvider
78[blank_start]InfoObject Maintenance[blank_end] is where you assign attributes to Characteristics and maintain attributes as display attributes only or as navigation attributes.
- AInfoObject Maintenance
79What you must do to use an attribute as a navigation attribute?
- AIdentify the attribute as a navigation attribute in the InfoObject maintenance of the characteristic.
- BSelect the attribute froom the list of possible navigation attributes in the InfoProvider maintenance.
- CIn the display tab for Characteristic, select the attribute as a navigation attribute
- DIn the infoObject maintenance screen in Query designer, select the attribute as a navigation attribute
80It 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.
- ATime-dependent attribute
- BTime independent attribute
81To 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.
- Arows/columns heading
- Bkey figure
- Ccharacteristic
- Dquery
82Which of the following are the Hierarchy options?
- ADisplay characteristics in rows or in columns as hierarchy
- BSelect an external hierarchy for a characteristic
- CDefine how hierarchy is displayed
- DUse external hierarchies to make restrictions
- EConfigure a hierarchical display within structures
- FCombine hierarchies and structures
- GDelete a hierarchy within structures
83A hierarchy data is a master data belonging to a key figure and dependent of whether it is loaded to or created in SAP BW.
- ATrue
- BFalse
84The 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.
- ATrue
- BFalse
85External hierarchies behave olike a master data and can be used in all InfoProviders that contain the hierarchy characteristic.
- ATrue
- BFalse
86Which of the following is not an options for Hierarchy property?
- AExpand level
- BPosition of lower level nodes
- CValues of Posted Nodes
- DNodes with Only One Lower Level node
- ESorting
- FPosted values for InfoProvider
87You cannot sort in descending or ascending order if you have select [blank_start]Sort by As in Hierarchy[blank_end].
- ASort by As in Hierarchy
- BSort by Key
- CSort by Text
- DSort by Text and Sort by Key
88When 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
- ATrue
- BFalse
89Which of the following are the componentsof an external hierarchy?
- ANodes
- BLeaves
- CHierarchy levels
- DIntervals
- EBasic Characteristic
- FAttribute
- GCharacteristic with Compounded Characteristic
90[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.
- APostable nodes
- BNon-Postable nodes
91Hierarchy leaves contain characteristic values for the basic characterictic and may have entries in the fact table
- ATrue
- BFalse
92Hierarchy intervals contain more than one leaf that belong together,described by their upper and lower limits.
- ATrue
- BFalse
93What options do you have when you have hierarchy nodes or leaves appear serveral times under different superordinate nodes?
- AMake the hierarchy sturcture time-dependent
- BMake the hierarchy structure time-independent
- CSet the nodes as link nodes
- DUnlink the nodes
94You 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?
- AChange the access type for result values to master data
- BChoose only InfoProvider values as the filter value selection at query execution
- CCreate a formula with the operator set as Show all values
- DChoose Display all values in the Display tab.
95Steps to display characteristics as a hierarchy in report rows.
- AIn 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
- BIn 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
- CIn 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
96To display structure elements in a query hierarchically, you must activate the Display as Hierarchy option in the Query Designer Rows or Columns section
- ATrue
- BFalse
97Which one of the following statement regarding external hierarchies is correct? External hierarchies contain data from:
- AExternal source system
- BOther queries in SAP BW
- CThe master data tables of a basic characteristic
- DThe hierarchy dimension table of an infoCube
98You can sort the members of an external hierarchy in ascending or descing order
- ATrue
- BFalse
99Steps on how to restrict a Characteristic with an external hierarchy
- ARight 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.
- BIn 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
- CIn 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
100[blank_start]Inner nodes[blank_end] are postable nodes that have subordinate postable nodes
- AInner nodes
- BNon-postable nodes
- CRoot nodes
- DLevel nodes
- EOuter nodes
101When 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.
- AInterval
- BPostable node
- CNone Postable nodes
- DRoot
102You can extract transaction data from a data target for this component
- AInterval
- BPostable node
- CNone Postable nodes
- DRoot
103This component relates to text nodes that you can include in a hierarchy.
- AInterval
- BPostable node
- CNone Postable nodes
- DRoot
104This component is the uppermost node in a hierarchy structure
- AInterval
- BPostable node
- CNone Postable nodes
- DRoot
105What of the following is not an option for settings for External Hierarchy on the InfoObject level?
- AHierarchies, version-dependent
- BHierarchy, not time-dependent
- CEntire hierarchy is time-dependent
- DTime-dependent hierarchy structure
- EUse Temporal Hierarchy Join
- FInterval Permitted in Hierarchy
- GHierarchy, versioning data
- HReverse +/- Sign for the Node
106Variables do not depend on InfoProviders but on the InfoObjects for which they were created
- ATrue
- BFalse
107Formula variables are available in all infoProviders and are independent of InfoProviders and dependent of infoObjects
- ATrue
- BFalse
108Which Reporting tools support Variables?
- AAnalysis, edition for Microsoft Office and edition for OLAP
- BSAP Crystal Reports
- CWEBi
- DDashboards
- EDesign Stuio
- FIDT
109Which of the following variable types support Authorization processing type?
- ACharacteristic Value
- BText
- CFormula
- DHierarchy
- EHierarchy Node
110Which of the following variable types support Replacement path processing type?
- ACharacteristic Value
- BText
- CFormula
- DHierarchy
- EHierarchy Value
111Which 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?
- AGeneral
- BReplacement Path
- CDetails
- DDetail Values
- ECurrency/Unit
112Which of the following can you select as a replacement value for a text or formula variable? Replacement Variable With
- AKey (Internal value)
- BLabel (Text)
- CExternal Characteristic Value of the Key
- DAttribute Value
- EHierarchy Attribue
- FHierarchy Node attribute
113[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
- AUse Interval
- BInterval Management
- CInterval values
114[blank_start]Offset start and Offset length[blank_end] determines the start and length of the text output
- AOffset start and Offset length
- BOffsetting
- COffset Range
- DOffset Value
115The option Evaluate as Boolean (value 0 or 1) is only available for text variables.
- ATrue
- BFalse
116Characteristic 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
- ATrue
- BFalse
117Usage options for Characteristic Value Variables
- ARKFs
- BCKFs
- CFilter Values
118Which of the following are the prerequisites for the target variable when replacing a text variable with another variable?
- AMust not be input ready
- BMust represent a single value
- CMust not be a hierarchy node variable
- DMust be input ready
- EMust be available in the query
119Which of the following are the prerequisites for the source variable when replacing a text variable with another variable?
- AMust be a characteristic value variable, a hierarchy variable, a text variable or a formula variable
- BMust be a characteristic value variable, a hierarchy node variable, a text variable or a formula variable
- CMust not be a hierarchy node variable
- DMust be input-ready
- EMust be available in the query
- FMust represent a single value or an interval
- GMust represent a single value
120To 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].
- Achoose Prompts → Prompts for Data Source
- Bchoose Variables → Prompts
- Cchoose Prompts → Change Prompts
- Dchoose Prompts → Prompts for Workbook
121How can you use formula variables?
- AAs operands for local calculations in reports
- BAs operands in formulas that are retrieved via replacement path
- CAs threshold values in exceptions
- DAs key values for characteristic restrictions
122SAP Exit is a variable processing type that is only available in SAP BI Content variables
- ATrue
- BFalse
123A 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
- ATrue
- BFalse
124Use these steps to outline the process for transferring values between queries witha characteristic value variable that has the replacement path processing type
- ASelect 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
- BSelect 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
- CSelect 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
125Exceptions are defined for key figure values, while conditional formatting is defined for certain cells in the spreadsheet and does not support report navigation
- ATrue
- BFalse
126Each exception can be applied to one key figure in a query
- ATrue
- BFalse
127A condition is technically a filter that is applied to key figure values
- ATrue
- BFalse
128You 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?
- AThe query has not been saved.
- BConditions are not supported in Analysis
- CYou must reset the query in Analysis
- DYou must add the customer characteristic to the drill down.
129The exception affects all values except for the aggregated values of the characteristic
- AEverything Except Totals
- BEverything
- CFixed Value
- DTotals Only
130The exception applies for every drill-down state of the Characteristic with no restrictions on cell context
- AEverything Except Totals
- BEverything
- CFixed Value
- DTotals Only
131The exception applies only to a specific characteristic value or characteristic value variable
- AEverything Except Totals
- BEverything
- CFixed Value
- DTotals Only
132The exception affects only the aggregated values of the characteristic
- AEverything Except Totals
- BEverything
- CFixed Value
- DTotals Only
133You 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
- ATrue
- BFalse
134Using 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
- ATrue
- BFalse
135Where do you define the sender/receiver assignement for a jump to target?
- AIn the Query Designer Properties Pane
- BIn SAP BW, using RSBBS
- CIn the context menu of a report cell in Analysis
- DIn the Report/Report Interface
136Which of these settings do you need to enter when creating a jump target in the RRI?
- ATarget System
- BSource System
- CReport Type
- DReceiver Variable
- EGoto
137You can visualize the results of a BEx query with which of these reporting tools?
- ASAP Crystal Reports for Enterprise
- BData Warehousing Workbench
- CSAP BusinessObjects BI Platform
- DBEx Analyzer
138BEx Analyzer is the reporting tool of choice for executives because it allows the use of sophistictaed graphical elements to visualize highly aggregated data
- ATrue
- BFalse
139BEx Web Application Designer and Design Studio allow all information consumers in thec ompany to build individual application for their reporting needs.
- ATrue
- BFalse
140A practical use case for formatted reporting is an annual report that is centrally created and managed, and distributd to all executives in the company
- ATrue
- BFalse
141WEBi only allows access to BEx queries when they are store in the BI Platform
- ATrue
- BFalse
142SAP 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.
- ATrue
- BFalse
143Which of the following tools can consume BEx Queries?
- ASAP BEx Web Analyzer
- BSAP BEx Report Designer
- CSAP BEx Web application Designer
- DDesign studio
- ECR for 2013
- FCR for enterprise
- GWEBi
- HDashboards
- IAnalysis, edition for MS Office and Analysis, edition for OLAP
- JBusiness Explorer
144OLAP Analysis with BEx Analyzer: Navigation of a query allows you to perform actions such as the following:
- AFilter Characteristics on a single value
- BDrill down on all values for a characteristic
- CRegroup characteristics and key figures in the rows and columns of the results area
- DHide key figures
- ENone
145If 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
- ATrue
- BFalse
146Which is not included in RSECADMIN: Analysis Authorization
- AManagement of Analysis Authorizations
- BQuery Selection
- CMaintain Authorizations
- DAssign to User Role or Profile
147When 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
- ATrue
- BFalse
148Copying Queries between InfoProviders
- ASpecify Source InfoProvider and Target InfoProvider → Select Objects → Transfer Selections → Compatibility Check → Continue to End
- BSpecify Source InfoProvider → Select Objects → Transfer Selections → Compatibility Check → and Target InfoProvider → Continue to End
- CSpecify Source InfoProvider → Transfer Selections → Compatibility Check → and Target InfoProvider → Continue to End
149Steps on deleting Query Objects
- ASelect Object type to delete → Restrict search → Execute to select → Select query elements to delete → Execute to delete
- BSelect Object type to delete → Restrict search → Execute to select → Specify Source InfoProvider and Target InfoProvider → Select query elements to delete → Execute to delete
- CSelect Object type to delete → Restrict search → Execute to select → Specify Source InfoProvider → Select query elements to delete → Execute to delete
150The 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
- ATrue
- BFalse
151Users 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?
- ACustomer and material in the rows
- BCustomer and material in the free characteristics
- CCustomer in the rows and material in the free characteristics
- DMaterial in the rows and customer in the free characteristics
152Which of the following are query read modes for SAP BW queries?
- AQuery to read all data at once
- BQuery to read data on refresh
- CQuery to read only aggregated data
- DQuery to read data during navigation
153The 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.
- ATrue
- BFalse
154Which considerations should be made for Query Performance Improvent?
- ACheck layout and filter settings in the query definition
- BUse query performance monitoring tools
- CEnsure that read mode is set appropriately
- DCheck the data model
- EDesign aggregates aligned to common filter requirements
- FImprove performance on the database level
- GDelete unused data in the database level
155Aggregates are necessary if you use SAP BW Accelerator or SAP BW on HANA
- ATrue
- BFalse
156When 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
- ABQ Query
- BWeb Application (Netweaver 7.0)
- CWeb Application (BW 3.x)
- DSAP Crystal Report
- EBW Xcelsius (Dashboard)
- FInfoSet Query (queries on classic InfoSets)
- GSAP Transaction
- HABAP/4 Report
- IWeb Address
- JIntranet
Information
- Description
- Quiz on TBI10, created by Hannylou Celestial on 07/11/2017.
- Author
- Hannylou Celestial
- Language
- English
- Views
- 176
- Rating
- No ratings yet Rate this quiz