Hannylou Celestial
Quiz by , created more than 1 year ago

Quiz on TBI15 part 2, created by Hannylou Celestial on 09/11/2017.

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

TBI15 part 2

Question 1 of 42

1

New rows/columns can be inserted

Select one or more of the following:

  • 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

Explanation

Question 2 of 42

1

SAP custome style

Select one of the following:

  • SAPMemberCellX

  • SAPMemberCellY

  • SAPMemberCellZ

  • SAPMemberCell

Explanation

Question 3 of 42

1

On Display options for Crosstab, Repeat Members duplicate measures in the crosstab

Select one of the following:

  • True
  • False

Explanation

Question 4 of 42

1

Which of the following crosstab style set is the default style?

Select one of the following:

  • SAP Black&White

  • SAP Blue

  • SAP TradeShow plus

  • SAPMemberCellX

Explanation

Question 5 of 42

1

Workbook components

Select one or more of the following:

  • 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

Explanation

Question 6 of 42

1

How to insert a chart in BOAO?

Select one of the following:

  • 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

Explanation

Question 7 of 42

1

Which of the following are the possible values for the fourth parameter of =SAPSetFilterComponent("DS_1","0DIVISION","ALL")

Select one or more of the following:

  • LOWERBOUNDARY

  • SINGLE ENTRY

  • MULTIPLE

  • SINGLE

  • UPPERBOUNDARY

Explanation

Question 8 of 42

1

This formula returns the values of the specified property for a specific BW variable

Select one of the following:

  • SAPSetFilterComponent

  • SAPListOfVariables

  • SAPGetVariable

  • SAPGetInfoLabel

Explanation

Question 9 of 42

1

Which of the following are the possible property name for SAPGetVariable

Select one of the following:

  • 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,

Explanation

Question 10 of 42

1

This formula returns a list of all variables of a data source or planning object?

Select one of the following:

  • SAPListOfVariables

  • SAPListOfFunctions

  • SAPListOfFormula

  • SAPGetVariable

Explanation

Question 11 of 42

1

Which of the following are the parameters and arguments of SAPListOfVariables?

Select one or more of the following:

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

Explanation

Question 12 of 42

1

You can set the formula alias of a data source or planning object on the Information tab

Select one of the following:

  • True
  • False

Explanation

Question 13 of 42

1

Member display (TEXT, KEY, INPUT_STRING) and Display (ALL, PROMPTS, ALL_FILLED, PROMPTS_FILLED, PLAN_PARAMETER) are optional parameters

Select one of the following:

  • True
  • False

Explanation

Question 14 of 42

1

The Display Parameter "ALL" displays all filled and unfilled variables visible or not visible on the prompts dialog

Select one of the following:

  • True
  • False

Explanation

Question 15 of 42

1

In converting crosstab cells to formula, what can you do when in Formula mode?

Select one or more of the following:

  • 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

Explanation

Question 16 of 42

1

how to convert a crosstab to formula?

Select one of the following:

  • 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

Explanation

Question 17 of 42

1

On the components tab, you can define which tables should be affected by filter

Select one of the following:

  • True
  • False

Explanation

Question 18 of 42

1

In Formula mode, the crosstab is displayed on the Components tab

Select one of the following:

  • True
  • False

Explanation

Question 19 of 42

1

Which functions returns members hardcoded in the query characteristic restrictions?

Select one of the following:

  • SAPGetStaticFilter

  • SAPGetDimensionDynamicFilter

  • SAPGetDimensionStaticFilter

  • SAPGetDimensionEffectiveFilter

Explanation

Question 20 of 42

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 21 of 42

1

To define your workbook as default workbook got to Analysis-specific Settings and browse for your workbook

Select one of the following:

  • True
  • False

Explanation

Question 22 of 42

1

How would you insert a data source into your Default Workbook?

Select one of the following:

  • In the analysis ribbon, click insert

  • File → Analysis → Open Data Source

  • In the analysis ribbon, click Open Data Source

  • File → Analysis → Insert Data Source

Explanation

Question 23 of 42

1

In what version of SAP BEx Analyzer can you convert workbooks to an Analysis workbook?

Select one or more of the following:

  • SAP BEx Analyzer 4.0

  • SAP BEx Analyzer 3.5

  • SAP BEx Analyzer 3.2

  • SAP BEx Analyzer 7.0

Explanation

Question 24 of 42

1

In Converting BEx Analyzer Workbooks, which Conversion settings options can you select?

Select one or more of the following:

  • Convert the whole workbook

  • Convert only Data Source and Crosstab

  • Convert only Data Source

  • Convert only Crosstab

Explanation

Question 25 of 42

1

Which of the following functions and API methods vary in parameters depending on the selection for merging variables?

Select one or more of the following:

  • SAPListOfMembers

  • SAPListOfVariables

  • SAPCallMemberSelector

  • SAPGetVariable

Explanation

Question 26 of 42

1

On Components tab, you can change the Data Source name and Formula alias only

Select one of the following:

  • True
  • False

Explanation

Question 27 of 42

1

Which property allows you to display the initial state of a query or a query view every time you open your workbook?

Select one of the following:

  • Data Source Technical name

  • Data Source

  • Reset Data Source on Opening Workbook

  • System Alias

Explanation

Question 28 of 42

1

What is the structure of named range for a crosstab?

Select one of the following:

  • SAP + Crosstab formula alias

  • Crosstab formula alias

  • Formula name

  • Range

Explanation

Question 29 of 42

1

How would you move a crosstab to a specific cell in a sheet?

Select one of the following:

  • Using Range in Data Source settings

  • Using Range in Crosstab settings

  • Using Apply Default Formats in Crosstab settings

  • Using Repeat Members in Crosstab settings

Explanation

Question 30 of 42

1

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?

Select one of the following:

  • Platform Settings

  • Advanced Settings

  • User Settings

  • Support Settings

Explanation

Question 31 of 42

1

What is the minimum release of BEx Query Designer needed to use the Launch Query Designer option in the ribbon tools group?

Select one of the following:

  • 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

Explanation

Question 32 of 42

1

Which options are available in the Advanced settings tab?

Select one of the following:

  • 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

Explanation

Question 33 of 42

1

Which of the following are the available options for Platform settings tab?

Select one of the following:

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

Explanation

Question 34 of 42

1

With this settings tab, you can record traces to analyze problems in Analysis workbooks

Select one of the following:

  • User Settings

  • Platform Settings

  • Advanced Settings

  • Support Settings

Explanation

Question 35 of 42

1

Prerequisites to export data source to Design studio

Select one of the following:

  • 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

Explanation

Question 36 of 42

1

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

Select one of the following:

  • True
  • False

Explanation

Question 37 of 42

1

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?

Select one of the following:

  • Insert Data source

  • Import and Export

  • Smart copy and Smart paste

  • Copy data source and Paste data source

Explanation

Question 38 of 42

1

Which of the following statements are not true about Scheduling Workbooks to Run?

Select one of the following:

  • 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

Explanation

Question 39 of 42

1

Which of the following are the restrictions when you scheduled a workbook?

Select one or more of the following:

  • 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

Explanation

Question 40 of 42

1

How would you display the developer ribbon to create VBA macros?

Select one of the following:

  • 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

Explanation

Question 41 of 42

1

Which VBA script assigns a value to a prompt?

Select one of the following:

  • 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

Explanation

Question 42 of 42

1

Save you time and headaches by automating common, repetitive tasks. This feature is embedded in MS Office Excel

Select one of the following:

  • Macros

  • Micros

  • SAP Functions

Explanation

Previous
Next