New rows/columns can be inserted
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
SAP custome style
SAPMemberCellX
SAPMemberCellY
SAPMemberCellZ
SAPMemberCell
On Display options for Crosstab, Repeat Members duplicate measures in the crosstab
Which of the following crosstab style set is the default style?
SAP Black&White
SAP Blue
SAP TradeShow plus
Workbook components
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
How to insert a chart in BOAO?
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
Which of the following are the possible values for the fourth parameter of =SAPSetFilterComponent("DS_1","0DIVISION","ALL")
LOWERBOUNDARY
SINGLE ENTRY
MULTIPLE
SINGLE
UPPERBOUNDARY
This formula returns the values of the specified property for a specific BW variable
SAPSetFilterComponent
SAPListOfVariables
SAPGetVariable
SAPGetInfoLabel
Which of the following are the possible property name for SAPGetVariable
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,
This formula returns a list of all variables of a data source or planning object?
SAPListOfFunctions
SAPListOfFormula
Which of the following are the parameters and arguments of SAPListOfVariables?
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)
You can set the formula alias of a data source or planning object on the Information tab
Member display (TEXT, KEY, INPUT_STRING) and Display (ALL, PROMPTS, ALL_FILLED, PROMPTS_FILLED, PLAN_PARAMETER) are optional parameters
The Display Parameter "ALL" displays all filled and unfilled variables visible or not visible on the prompts dialog
In converting crosstab cells to formula, what can you do when in Formula mode?
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
how to convert a crosstab to formula?
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
On the components tab, you can define which tables should be affected by filter
In Formula mode, the crosstab is displayed on the Components tab
Which functions returns members hardcoded in the query characteristic restrictions?
SAPGetStaticFilter
SAPGetDimensionDynamicFilter
SAPGetDimensionStaticFilter
SAPGetDimensionEffectiveFilter
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.
To define your workbook as default workbook got to Analysis-specific Settings and browse for your workbook
How would you insert a data source into your Default Workbook?
In the analysis ribbon, click insert
File → Analysis → Open Data Source
In the analysis ribbon, click Open Data Source
File → Analysis → Insert Data Source
In what version of SAP BEx Analyzer can you convert workbooks to an Analysis workbook?
SAP BEx Analyzer 4.0
SAP BEx Analyzer 3.5
SAP BEx Analyzer 3.2
SAP BEx Analyzer 7.0
In Converting BEx Analyzer Workbooks, which Conversion settings options can you select?
Convert the whole workbook
Convert only Data Source and Crosstab
Convert only Data Source
Convert only Crosstab
Which of the following functions and API methods vary in parameters depending on the selection for merging variables?
SAPListOfMembers
SAPCallMemberSelector
On Components tab, you can change the Data Source name and Formula alias only
Which property allows you to display the initial state of a query or a query view every time you open your workbook?
Data Source Technical name
Reset Data Source on Opening Workbook
System Alias
What is the structure of named range for a crosstab?
SAP + Crosstab formula alias
Crosstab formula alias
Formula name
Range
How would you move a crosstab to a specific cell in a sheet?
Using Range in Data Source settings
Using Range in Crosstab settings
Using Apply Default Formats in Crosstab settings
Using Repeat Members in Crosstab settings
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?
Platform Settings
Advanced Settings
User Settings
Support Settings
What is the minimum release of BEx Query Designer needed to use the Launch Query Designer option in the ribbon tools group?
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
Which options are available in the Advanced settings tab?
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
Which of the following are the available options for Platform settings tab?
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)
With this settings tab, you can record traces to analyze problems in Analysis workbooks
Prerequisites to export data source to Design studio
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
You can use analysis methods that are not available in the Design studio (e.g. conditional formatting, calculations, filters)
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?
Insert Data source
Import and Export
Smart copy and Smart paste
Copy data source and Paste data source
Which of the following statements are not true about Scheduling Workbooks to Run?
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
Which of the following are the restrictions when you scheduled a workbook?
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
How would you display the developer ribbon to create VBA macros?
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
Which VBA script assigns a value to a prompt?
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
Save you time and headaches by automating common, repetitive tasks. This feature is embedded in MS Office Excel
Macros
Micros
SAP Functions
