Kopieren und bearbeiten

TBI15 part 2

Beschreibung

Quiz am TBI15 part 2, erstellt von Hannylou Celestial am 09/11/2017.
Hannylou Celestial
Quiz von Hannylou Celestial, aktualisiert more than 1 year ago
Hannylou Celestial
Erstellt von Hannylou Celestial vor etwa 7 Jahre
85
1
0

Zusammenfassung der Ressource

Frage 1

Frage
New rows/columns can be inserted
Antworten
  • Relative to the header section
  • Before and after every dimension
  • Before and after every dimension member
  • Before and after every measure
  • Before and after a result line
  • Relative to the dimension section

Frage 2

Frage
SAP custome style
Antworten
  • SAPMemberCellX
  • SAPMemberCellY
  • SAPMemberCellZ
  • SAPMemberCell

Frage 3

Frage
On Display options for Crosstab, Repeat Members duplicate measures in the crosstab
Antworten
  • True
  • False

Frage 4

Frage
Which of the following crosstab style set is the default style?
Antworten
  • SAP Black&White
  • SAP Blue
  • SAP TradeShow plus
  • SAPMemberCellX

Frage 5

Frage
Workbook components
Antworten
  • Info fields that provide information about your data and adapts dynamically on refresh and data navigation
  • Filter components that provide simplified filtering for consumer-type end users
  • Dynamic charts that provide graphical presentation of data and adapts dynamically on refresh and data navigation
  • Waterfall chart that is specialized to show how an initial value is affected by a series of intermediate positive and negative values

Frage 6

Frage
How to insert a chart in BOAO?
Antworten
  • Select the data source that will provide data → Choose chart drop down → Select chart, waterfall chart, or pivoted waterfall chart
  • Select the crosstab that will provide data → Choose chart drop down → Select chart, waterfall chart, or pivoted waterfall chart
  • Select the workbook that will provide data → Choose chart drop down → Select chart, waterfall chart, or pivoted waterfall chart
  • Select the sheet that will provide data → Choose chart drop down → Select chart, waterfall chart, or pivoted waterfall chart

Frage 7

Frage
Which of the following are the possible values for the fourth parameter of =SAPSetFilterComponent("DS_1","0DIVISION","ALL")
Antworten
  • LOWERBOUNDARY
  • SINGLE ENTRY
  • MULTIPLE
  • SINGLE
  • UPPERBOUNDARY

Frage 8

Frage
This formula returns the values of the specified property for a specific BW variable
Antworten
  • SAPSetFilterComponent
  • SAPListOfVariables
  • SAPGetVariable
  • SAPGetInfoLabel

Frage 9

Frage
Which of the following are the possible property name for SAPGetVariable
Antworten
  • VALUE, VALUEASKEY, ISMANDATORY, ISINPUTENABLED, DESCRIPTION, TECHNICALNAME, INPUT_STRING, INPUT_STRING_AS_ARRAY
  • VALUE, VALUEASKEY, ISMANDATORY, DESCRIPTION, TECHNICALNAME, INPUT_STRING, INPUT_STRING_AS_ARRAY
  • VALUE, VALUEASKEY, ISMANDATORY, ISINPUTENABLED, TECHNICALNAME, INPUT_STRING, INPUT_STRING_AS_ARRAY
  • VALUE, VALUEASKEY, ISMANDATORY, ISINPUTENABLED, DESCRIPTION, TECHNICALNAME, TEXT, INPUT_STRING, INPUT_STRING_AS_ARRAY,

Frage 10

Frage
This formula returns a list of all variables of a data source or planning object?
Antworten
  • SAPListOfVariables
  • SAPListOfFunctions
  • SAPListOfFormula
  • SAPGetVariable

Frage 11

Frage
Which of the following are the parameters and arguments of SAPListOfVariables?
Antworten
  • Data Source
  • Member Display (TEXT, KEY, INPUT_STRING)
  • Display (ALL, PROMPTS, ALL_FILLED, PROMPTS_FILLED, PLAN_PARAMETER)
  • Display (ALL_PROMPTS, ALL_FILLED, PROMPTS_FILLED, PLAN_PARAMETER)

Frage 12

Frage
You can set the formula alias of a data source or planning object on the Information tab
Antworten
  • True
  • False

Frage 13

Frage
Member display (TEXT, KEY, INPUT_STRING) and Display (ALL, PROMPTS, ALL_FILLED, PROMPTS_FILLED, PLAN_PARAMETER) are optional parameters
Antworten
  • True
  • False

Frage 14

Frage
The Display Parameter "ALL" displays all filled and unfilled variables visible or not visible on the prompts dialog
Antworten
  • True
  • False

Frage 15

Frage
In converting crosstab cells to formula, what can you do when in Formula mode?
Antworten
  • You can highlight cells w/ background and font color
  • You can insert spaces
  • You can copy parts of the table to another position in the workbook
  • re-use cells
  • overwrite a member with another one
  • You can calculate additional subtotals
  • You can create offers based on data from various data providers
  • You can drag & drop dimensions
  • You can use context menu as navigation

Frage 16

Frage
how to convert a crosstab to formula?
Antworten
  • Click Convert to Formula button in the Tools area of the ribbon
  • Click Convert to Formula button in the Design Panel
  • Click Convert to Formula button in the Menu area
  • Click Convert to Formula button in the Analysis area of the ribbon

Frage 17

Frage
On the components tab, you can define which tables should be affected by filter
Antworten
  • True
  • False

Frage 18

Frage
In Formula mode, the crosstab is displayed on the Components tab
Antworten
  • True
  • False

Frage 19

Frage
Which functions returns members hardcoded in the query characteristic restrictions?
Antworten
  • SAPGetStaticFilter
  • SAPGetDimensionDynamicFilter
  • SAPGetDimensionStaticFilter
  • SAPGetDimensionEffectiveFilter

Frage 20

Frage
You can insert more than one data source into a default workbook. The elements and settings from the second data source that you insert are used as a reference when you open a data source with the default workbook.
Antworten
  • True
  • False

Frage 21

Frage
To define your workbook as default workbook got to Analysis-specific Settings and browse for your workbook
Antworten
  • True
  • False

Frage 22

Frage
How would you insert a data source into your Default Workbook?
Antworten
  • In the analysis ribbon, click insert
  • File → Analysis → Open Data Source
  • In the analysis ribbon, click Open Data Source
  • File → Analysis → Insert Data Source

Frage 23

Frage
In what version of SAP BEx Analyzer can you convert workbooks to an Analysis workbook?
Antworten
  • SAP BEx Analyzer 4.0
  • SAP BEx Analyzer 3.5
  • SAP BEx Analyzer 3.2
  • SAP BEx Analyzer 7.0

Frage 24

Frage
In Converting BEx Analyzer Workbooks, which Conversion settings options can you select?
Antworten
  • Convert the whole workbook
  • Convert only Data Source and Crosstab
  • Convert only Data Source
  • Convert only Crosstab

Frage 25

Frage
Which of the following functions and API methods vary in parameters depending on the selection for merging variables?
Antworten
  • SAPListOfMembers
  • SAPListOfVariables
  • SAPCallMemberSelector
  • SAPGetVariable

Frage 26

Frage
On Components tab, you can change the Data Source name and Formula alias only
Antworten
  • True
  • False

Frage 27

Frage
Which property allows you to display the initial state of a query or a query view every time you open your workbook?
Antworten
  • Data Source Technical name
  • Data Source
  • Reset Data Source on Opening Workbook
  • System Alias

Frage 28

Frage
What is the structure of named range for a crosstab?
Antworten
  • SAP + Crosstab formula alias
  • Crosstab formula alias
  • Formula name
  • Range

Frage 29

Frage
How would you move a crosstab to a specific cell in a sheet?
Antworten
  • Using Range in Data Source settings
  • Using Range in Crosstab settings
  • Using Apply Default Formats in Crosstab settings
  • Using Repeat Members in Crosstab settings

Frage 30

Frage
Which settings tab where you can specify the maximum number of recently used list of data sources and the maximum number of members displayed in the Filter by Member dialog and workbook location?
Antworten
  • Platform Settings
  • Advanced Settings
  • User Settings
  • Support Settings

Frage 31

Frage
What is the minimum release of BEx Query Designer needed to use the Launch Query Designer option in the ribbon tools group?
Antworten
  • BEx Query Designer 7.20 SP10 or 7.30 SP3
  • BEx Query Designer 7.10 SP10 or 7.30 SP30
  • BEx Query Designer 4.1 SP10 or 7.30 SP20

Frage 32

Frage
Which options are available in the Advanced settings tab?
Antworten
  • Show planning group, Show "Convert To Formula", Show "Create Web Application", Show "Launch Query Designer", Enhance Currency Conversion by Definition, Show all time-dependent hierarchies in Analysis tab, Show Access Mode for member display, Save Workbook as 1.4 Format by default
  • Show planning group, Show "Convert To Formula", Show "Create Web Application", Show "Launch Query Designer", Enhance Currency Conversion by Definition, Show all time-dependent hierarchies in Analysis tab, BEx Workbook Conversion Settings, Show Access Mode for member display, Save Workbook as 1.4 Format by default,
  • Show planning group, Show "Convert To Formula", Show "Create Web Application", Show "Launch Query Designer", Show all time-dependent hierarchies in Analysis tab, Show Access Mode for member display, Save Workbook as 1.4 Format by default

Frage 33

Frage
Which of the following are the available options for Platform settings tab?
Antworten
  • Preferred Platform (BI platform, Netweaver, Compatibility (BI Platform), Lumira Cloud), BEx Workbook Conversion settings (Conversion settings, Refresh Workbook, Conversion log, Show Save Dialog after Conversion, Replace System)
  • Preferred Platform (BI platform, Netweaver), BEx Workbook Conversion settings (Conversion settings, Refresh Workbook, Conversion log, Show Save Dialog after Conversion, Replace System)
  • Preferred Platform (BI platform, Netweaver, Compatibility (BI Platform), Lumira Cloud), BEx Workbook Conversion settings (Conversion settings, Refresh Workbook, Conversion log)

Frage 34

Frage
With this settings tab, you can record traces to analyze problems in Analysis workbooks
Antworten
  • User Settings
  • Platform Settings
  • Advanced Settings
  • Support Settings

Frage 35

Frage
Prerequisites to export data source to Design studio
Antworten
  • Ensure that you have installed BOAO and Design studio on your machine and use both tools either local mode or with a BI platform
  • Ensure that you have installed BOAO and Dashboard on your machine
  • Ensure that you have installed Analysis Add-in and Design studio on your machine
  • Ensure that you have installed SAP BW 7.4 and Design studio on your machine

Frage 36

Frage
You can use analysis methods that are not available in the Design studio (e.g. conditional formatting, calculations, filters)
Antworten
  • True
  • False

Frage 37

Frage
Which feature in BOAO would you use to copy a data source (crosstab or chart) that is currently displayed in a workbook to your Design Studio application?
Antworten
  • Insert Data source
  • Import and Export
  • Smart copy and Smart paste
  • Copy data source and Paste data source

Frage 38

Frage
Which of the following statements are not true about Scheduling Workbooks to Run?
Antworten
  • You use CMC and BI Launch pad to schedule analysis workbooks to automatically run at specified times
  • An instance is created when a scheduled object runs successfully
  • You have to install Analysis to open a distributed workbook
  • A connection to BI Platform and SAP BW must be SSO configured to schedule an Analysis Workbook

Frage 39

Frage
Which of the following are the restrictions when you scheduled a workbook?
Antworten
  • Refresh Workbook on Opening, Force Prompt for Initial Refresh, Comments, Icons (e.g arrows in conditional formatting) are ignored
  • Refresh Workbook on Opening, Store Prompts with Workbook, Force Prompt for Initial Refresh, Comments are ignored
  • Protected mode, SAP formula Concatenation, Excel formulas are not precalculated
  • VB macros are not executed

Frage 40

Frage
How would you display the developer ribbon to create VBA macros?
Antworten
  • File → Settings → Select Customize Ribbon → Select Developer → OK
  • File → Options → Select Customize Ribbon → Select Developer → OK
  • File → Settings → Advanced Settings → Select Customize Ribbon → Select Developer → OK
  • File → Settings → Support Settings → Select Customize Ribbon → Select Developer → OK

Frage 41

Frage
Which VBA script assigns a value to a prompt?
Antworten
  • Sub Country2Prompt() r = Application.Run("SAPSetVariable","P_VAR_COUNTRY",Worksheet("Settings").Range("E2").Value, "Key", "DS_1") End Sub
  • Sub Country2Prompt() r = Application.Run("SAPGetVariable","P_VAR_COUNTRY",Worksheet("Settings").Range("E2").Value, "Key", "DS_1") End Sub
  • Sub Country2Prompt() r = Application.Run("SAPListOfVariables","P_VAR_COUNTRY",Worksheet("Settings").Range("E2").Value, "Key", "DS_1") End Sub
  • Sub Country2Prompt() r = Application.Run("SAPSetFilterComponent","P_VAR_COUNTRY",Worksheet("Settings").Range("E2").Value, "Key", "DS_1") End Sub

Frage 42

Frage
Save you time and headaches by automating common, repetitive tasks. This feature is embedded in MS Office Excel
Antworten
  • Macros
  • Micros
  • SAP Functions
Zusammenfassung anzeigen Zusammenfassung ausblenden

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

ähnlicher Inhalt

Mind Mapping
braun.rachel
Stochastik Mathe
Laura Overhoff
Genetik Quiz
Laura Overhoff
screws and bolts
Ruben Sutter
Biologie Abiturthemen 2016
katharina.boerge
1_Blut und Blutkreislauf
Ulrike Renauer
Euro-FH // Zusammenfassung SOPS2
Robert Paul
Vetie Radiologie 2017
Péroline de Gail
Vetie - Tierseuchenbekämpfung 2016
Peter Christian Ponn
Vetie - Milchkunde 2016
Birte Schulz
Vetie - Berufsrecht 2020 (Matrikel 15)
Jana r
Bibliothek durchsuchen