Test
KARL POGI
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (20)
1What can you do with a condition? (Choose 2)
- ADefine filter restriction
- BDefine value limits
- CRestrict combination of characteristics using a structure
- DAnalyse combinations of charactrestics using ranked lists
2Where can you set a variable offset to time-based characteristic?
- AIn the values For dialog in the query designer
- BIn the characteristic definition in SAP Business Warehouse
- CIn the Calculated Key Figure dialog in the query designer
- DIn the InfoProvider definition in SAP Business Warehouse
3What do you have to consider when you work with exception aggregation?
- AException aggregations are excuted in addition to standard aggregations
- BException aggregations are excuted on multiple rows
- CException aggregations are excuted on multiple columns
- DException aggregations are excuted instead of standard aggregations
4What is a prerequisite for creating an external hierarchy?
- AThe With hierarchies indicator of the infoObjects must be set
- BThe hierarchy must be time-dependent
- CThe hierarchy must cotain at least two nodes
- DThe With master data indicator of the infoObjects must be set
5You want to build a BEx Query in the BEx Query Designer to display to 10 customers with the highest sales revenue, what must you do? (Choose 2)
- ACreate a condition using TOP sum ranked list operator
- BCreate a condition using TOP N ranked list operator
- CUse the all charactersitics in drill-down independently option
- DUse indivual characteristic and characteristic combinations
6Where can a characterstic be restricted in the BEx Query definition?
- AIn the characterstic's context menu in the default value section
- BIn the characterstic's context menu in InfoProvider section
- CIn the query properties, in the tab "Extended"
- DIn the query properties, in the tab "General"
7Which display options are available in the Display As tab of the Query Designer? (Choose 3)
- AText and Key
- BKey and Text
- CText
- DKey and short Text
- EShort Text and long Text
8In a report you want to add 20% to the Volume Key Figure only if it is above 100. How can you achieve this?
- A(Volume>100) * Volume * 0,2 + Volume
- BF Volume > 100 THEN Volume * 0,2 + Volume ELSE Volume
- C(Volume>100) * Volume * 0,2 + (Volume<=100) * Volume
- DIF Volume > 100 THEN Volume * 0,2 * ELSE Volume
9What can you use to create a restricted key figure? (Choose 2)
- Aa calculated key figure
- Ba structure
- Ca characteristic selection
- Da formula
10What can an end user do in SAP BusinessObjects Analysis, Edition for Microsoft Office with a BEx Query as a datasource? (Choose 2)
- AActivate an exception that was created in the BEx Query Designer
- BSort the displayed elements on a given measure
- CShow the runtime statistics of the Analysis workbook
- DChange the display language for text fields
11In the BEx Query Designer, what can you define using the cell editor? (Choose 2)
- AHelp cells that serve as containers for help selection or help formulas
- BReference cells that can pass their results to variables with the replacement path processing option
- CAdditional filter restrictions that apply to a complete column or row of the result set
- DFormulas and selection conditions for sales to override the cell value that are created automatically
12You have two structures and an intersecting formula; nothing is defined in eliminate formula collision. What will happen when you run the Query?
- ABy default, the formula from the structure that was created first will be used.
- BAdditional filter restrictions that apply to a complete column or row of the result se
- CFormulas and selection conditions for sales to override the cell value that are created automatically
- DShow the runtime statistics of the Analysis workbook
13Authorization system objects you need... (Choose 2)
- AS_RS_COMP
- BS_RS_COMP1
- CS_RS_Auth
- DS_RS_Folder
14How many key figure structure can you use in a query?
- A1
- B2
- C3
- D4
15What are the functions of the query monitor? choose 2
- ACheck or change query properties
- BTest or regenerate Queries and query view.
- CUpdate
- DRefresh
16What are characteristics of data warehousing with SAP Business Warehouse? (Choose 2)
- AIt is optimized for read access
- BIt has a multidimensional structure
- CIt is optimized for write access
- DIt has a relational structure
17Which of the following SAP Business Warehouse elements does SAP Crystal Reports for Enterprise support?
- AScaling factor
- BZero suppression
- CNumber of decimals
- DHierarchy version variable
18What can you use as data source when you create reports in SAP Crystal Reports for Enterprise? (Choose 2)
- AAnalysis view
- BUniverse
- CSAP ERP
- DSAP HANA view
19In Crystal Reports 2013, how can you join date field and string filed for city? (Choose 2)
- ACity+Date
- BCity + Text (Date)
- CCity & Date
- DJoin (City, Date)
20Which table fields can you find in the field explorer display? (Choose 2)
- AParameters
- BFormulas
- CText
- DFilters
Información
- Descripción
- (BW) Information Technology Test sobre KARL POGI, creado por Karl Azadhee II Cuizon el 11/11/2017.
- Idioma
- English
- Visitas
- 8
- Historial
- Creado el 11 nov 2017 · actualizado el 11 nov 2017
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test