TBI15

Question 1 of 200

1

Who are the target users for BOAO, MS Powerpoint?

Select one of the following:

Business Users
Data Analyst
SAP BW Consultants

Explanation

Question 2 of 200

1

Use Cases for Analysis for Powerpoint

Select one of the following:

Distribution of Analysis (Slide deck building)
Distribution of Analysis (Workbookbuilding)
Analysis

Explanation

Question 3 of 200

1

Analysis for Powerpoint have the same functionality as Analysis for Excel

Select one of the following:

True
False

Explanation

Question 4 of 200

1

Analysis Powerpoint does not have a Design Panel

Select one of the following:

True
False

Explanation

Question 5 of 200

1

Available features in Analysis for Powerpoint ribbon

Select one of the following:

Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Fit Table, Move to, Smart Copy/ Smart Paste, Properties
Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Move to, Smart Copy/ Smart Paste, Properties
Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Fit Table, Move to, Design Panel, Smart Copy/ Smart Paste, Properties
Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Fit Table, Move to, Copy/ Paste, Properties

Explanation

Question 6 of 200

1

Which Settings are available in Analysis for Powerpoint?

Select one or more of the following:

User Settings (Maximum number of Entries in Recent List, Maximum number of Members displayed in Filter Dialog)
User Settings (Maximum number of Entries in Data source List, Maximum number of Members displayed in Filter Dialog)
Advanced Settings (Show Access Mode for Member Display, Allow client and Language Selection for SSO Logon)
Advanced Settings (Show Access Mode for Member Display, Allow all time-dependent hierarchies to be displayed in Design panel)
Platform Settings (Preferred Platform, Show Access Mode for Member Display, Replace system)
Platform Settings (Preferred Platform, Replace system)
Support Settings (Folder for Log file, Log Severity, Enable BW Server Tracing, Enable Workbook Profiling, Enable Client Profiling, Display Technical Name, Enable NCO Tracing, Show suppressed Messages)

Explanation

Question 7 of 200

1

Available Properties to configure for the entire presentation

Select one or more of the following:

Refresh Workbook on Opening
Refresh Presentation on Opening
Force Prompt for Initial Refresh
Store Prompts with Presentation
Store Prompts with Workbook
Remove Data before Saving
Merge Variables

Explanation

Question 8 of 200

1

When you smart paste a crosstab or a chart from a current navigation state in Excel to Analysis for Powerpoint, the objects paste in Powerpoint exist dependently to the objects in Excel

Select one of the following:

True
False

Explanation

Question 9 of 200

1

What are the options available in using Fit Table feature?

Select one or more of the following:

Split Table
Fit Table
Abbreviate Table
Hide Table

Explanation

Question 10 of 200

1

What is the maximum number of rows per slide in Analysis for Powerpoint?

Select one of the following:

65
75
99
1,000,000

Explanation

Question 11 of 200

1

If the number of total rows has changed, slides are created and/or deleted based on the changes when it is data refreshed.

Select one of the following:

True
False

Explanation

Question 12 of 200

1

Which options of Fit table would you use if you want to truncate data from the Dimension at row N and display "..." indicating the users that there is more data but they are hidden.

Select one of the following:

Fit Table
Split Table
Abbreviate Table

Explanation

Question 13 of 200

1

In Abbreviating table, Sorting will not affect the display of data

Select one of the following:

True
False

Explanation

Question 14 of 200

1

If you turn a split table into an abbreviation table, one or more slides are added.

Select one of the following:

True
False

Explanation

Question 15 of 200

1

You have the option to delete existing slides via Fit Table Dialog

Select one of the following:

True
False

Explanation

Question 16 of 200

1

If a table is split across multiple slides and one or more slides is manually deleted, the lost slides are replaced on refresh.

Select one of the following:

True
False

Explanation

Question 17 of 200

1

You may change the display order of the slides from a split table. But when you refresh the data it will be back from the initial order

Select one of the following:

True
False

Explanation

Question 18 of 200

1

What are the following available options for info field in Analysis for Powerpoint?

Select one or more of the following:

Presentation name
Key date
Data Source name
Last Data update
Effective Filters
Variables

Explanation

Question 19 of 200

1

Which of the following are true statements about Info field in Analysis for Powerpoint?

Select one or more of the following:

Any manual user edits are overwritten when refreshed
Any manual user edits are retained when refreshed
Info fields are language-independent
Info fields are refreshed when the slide deck is refreshed
Info Fields are inserted into the slide as groups
Info Fields consist of a label and a value which can be broken if you choose
Info Fields consist of a label and a value which cannot be broken

Explanation

Question 20 of 200

1

Available Platforms in Saving Platforms

Select one or more of the following:

SAP BI Platform
SAP Netweaver Platform
SAP Lumira Cloud
SAP BW Server

Explanation

Question 21 of 200

1

When you have a data source with numerous rows you can use the Fit Table feature to break the result into multiple slides

Select one of the following:

True
False

Explanation

Question 22 of 200

1

If a table is split across multiple slides and one or more of the slides is manually deleted, the lost slides cannot be recovered.

Select one of the following:

True
False

Explanation

Question 23 of 200

1

It enables application designers to create analysis applications and dashboards based on SAP Netweaver BW, SAP Hana, and Universe data sources, for web and mobile devices

Select one of the following:

Crystal Reports 2016
Dashboards
Lumira
Design Studio
Information Designer Tool

Explanation

Question 24 of 200

1

Which of the following are the true statements about Design Studio?

Select one or more of the following:

Drag & Drop Visualizations and Controls: Tables, Charts, Geo Map, Filters etc.
Personalized Online Composition for End-Users
Standard Apps for Analysis, Planning, Data Exploration, Self-Service
State of the Art HTML5 Rendering & Mobile Support
Rapid Prototyping with Offline Data (CSV)
Full OLAP & Planning Support, Dashboards
Access Enterprise Data Sources: BW, HANA, UNX, ESP Event Streaming
Ad hoc analysis and reporting tool for business users with or without access to BI platform
Windows based report design tool used to create powerful stuctured reports
Statistical Analysis and data mining solution that enables you to build predictive models to discover hidden insights and relationships

Explanation

Question 25 of 200

1

Deployment Options for Design Studio Applications

Select one or more of the following:

BI Platform
SAP Netweaver
HANA Native
Universe

Explanation

Question 26 of 200

1

Which of the following are true about Deploying Design Studio Application on BI Platform?

Select one or more of the following:

Available as of Design Studio 1.1
Available as of Design Studio 1.0
BI 4.0 SP5 or BI 4.1 SP0 as the prerequisite
BI 4.4 SP1 or BI 4.7 SP0 as the prerequisite
Applications are stored on BI Platform
Applications are stored on BI Platform then transported to SAP Netweaver
Transportation via Promotion
Transpoted through TLOGO
Connections through CMC, able to connect to multiple SAP BW and SAP HANA systems

Explanation

Question 27 of 200

1

Which of the following are true statements about Deploment Options for SAP Netweaver?

Select one or more of the following:

Available as of Design studio 1.1
Available as of Design studio 1.0
BW 7.3 SP9, BW 7.31 SP7 or BW 7.4 SP2 as the pre-requisite
BW 4.0 SP5, BW 4.1 SP0 or BW 7.31 SP7 as the pre-requisite
Applications are stored on SAP BW
Applications are stored on BI Platform
Can only connect to one BW System
Can connect to multiple BW System and HANA systems
Mobile Solution: Portal on Device

Explanation

Question 28 of 200

1

Which of the following are true about Deploying Design Studio Application on HANA Native?

Select one or more of the following:

Available as of Design Studio 1.5
Available as of Design Studio 1.3
HANA 1.0 revision 90+
HANA 1.1 revision 90+
Applications are stored in HANA repository
Applications are stored in BW repository
Direct native connectivity to HANA's Information Access Service (INA) via Firefly
Direct native connectivity to HANA's Data Access Service (INA) via Firefly

Explanation

Question 29 of 200

1

Which of the following are true statements about the Local Mode in Design Studio?

Select one or more of the following:

This option can be used for end-user use and for demo or quick prototyping
Only for demo or quick prototyping
Direct Connection to backend data sources. Uses local SAP logon.ini file & ODBC HANA connection info
Direct Connection to backend data sources and to HANA's Information Access Service (INA)
Design Studio Java Application runtime runs locally on laptop or PC

Explanation

Question 30 of 200

1

Which of the following Platform strategy is recommended by SAP?

Select one of the following:

SAP recommends to deploy Design Studio on the BW Platform
SAP recommends to deploy Design Studio on the BI Platform
SAP recommends deploying Design Studio on the SAP Netweaver
SAP recommends deploying Design Studio on HANA Native

Explanation

Question 31 of 200

1

How would you change the the startup mode from a Local mode to BI Platform?

Select one of the following:

Choose tools → Preferences → Select SAP BusinessObjects BI Platform
Choose Settings→ Preferences → Select SAP BusinessObjects BI Platform
Choose Application→ Preferences → Select SAP BusinessObjects BI Platform

Explanation

Question 32 of 200

1

In choosing BI platform or Netweaver as the startup mode, you can still decide to log on locally by clicking the SKIP. The design tool starts in local mode.

Select one of the following:

True
False

Explanation

Question 33 of 200

1

Which of the following can you do on the Welcome page of Design Studio?

Select one or more of the following:

Watch most recent tutorials
Create new application
Delete an existing application
Open an existing application through Recently-used Analysis application
Open Useful Links
Create Tutorials

Explanation

Question 34 of 200

1

You can create a new Design Studio Application via

Select one or more of the following:

Application menu
Toolbar
Layout
Edit
View

Explanation

Question 35 of 200

1

Storage location of Design Studio Application deployed on BI Platform

Select one of the following:

Favorites or Public Folder on BI Platform Server
BW -ABAP Server
HANA Repository
C:\Users\<YourUser>\Analysis-workspace\com.sap.ip.bi.zen\repository

Explanation

Question 36 of 200

1

How to use the "New Application" Dialog

Select one of the following:

Enter a unique name for your application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Create
Enter a unique name for your application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Add
Enter a unique name for your application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Choose Query → Create
Enter a unique name for our application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Create → Query Panel → Choose Query → Add

Explanation

Question 37 of 200

1

Which of the following are main screen elements of Design Studio?

Select one or more of the following:

Components
Analysis
Information
Layout
Outline
Properties

Explanation

Question 38 of 200

1

Which of the following are the possible additional views on Design Studio?

Select one or more of the following:

Additional Properties
Properties
Script problems
Script Editor
Search Results
ERROR Log
Conversion Log

Explanation

Question 39 of 200

1

Design Studio Sources for a Data Source Object

Select one or more of the following:

SAP BW (Query, Query view, InfoProvider)
SAP HANA (Analytic View, Calculation View)
CSV
Universe (Relational and OLAP)
Universe (Relational)
SAP BW (Query, Query view)

Explanation

Question 40 of 200

1

Restrictions for Universes as Data Source of a Design Studio Application

Select one or more of the following:

Must be BI Platform 4.1 to access universe as data source
Must be BI Platform 4.2 to access universe as data source
Universe should be relational universe, single-source universe, or multi-source relational universes
The result set has a fixed limit of 20,000 rows or 200,000 data cells
The result set has a fixed limit of 200,000 rows or 200,000 data cells

Explanation

Question 41 of 200

1

Ways on how to create a new Data Source

Select one or more of the following:

Application menu → Add Data Source
Right-click Data Sources in the Outline tab of the design tool → New
Copy and Paste from another Design Studio Application or within Application
Copy and Paste from another Reporting tool
Use of interoperability features of Analysis Office or Analysis OLAP

Explanation

Question 42 of 200

1

Which of the following allows you to modify initial state of any data source?

Select one of the following:

Initial View dialog box
Data Source settings dialog box
Components settings dialog box
Layout dialog box

Explanation

Question 43 of 200

1

Which of the following are the options to add components to an Application?

Select one or more of the following:

Drag and Drop into preview area
Drag and Drop into Layout folder of the Outline view
Drag and Drop into Components area
Right-click to a component → add to Layout folder

Explanation

Question 44 of 200

1

Which of the following are not true about Layout Properties and Docking behavior in Design Studio?

Select one or more of the following:

Each component is always bound to its surrounding borders, borders of application or a surrounding object
Each component is sometimes bound to its surrounding borders, borders of application or a surrounding object depending on the settings
For each axis, three values have to be specified, and one of these three values is always defined as auto
For each axis, three values have to be specified, and one of these three values is always defined as 0
Use Maximize Component button to define width/height as auto and the margins as auto
Use Maximize Component button to define width/height as auto and the margins as 0

Explanation

Question 45 of 200

1

Which of the following are true about Aligning and Distributing components in layout?

Select one or more of the following:

Only the Analytic components can be aligned and distributed
All type of components can be aligned and distributed
Components within the same container or under the same root can be aligned and distributed
Components can be automatically maximized
Alignment and Distribution can be done via context menu in layout or per buttons on the Design studio menu

Explanation

Question 46 of 200

1

Ways on how to assign Data source to a component

Select one or more of the following:

Drag the data source from the Data Sources folder and drop it into the corresponding component in the Layout Folder in the Outline view
Drag the data source from the Data Sources folder and drop it into the corresponding component in the Layout Folder in the Properties view
Drag the data source from the Data Sources folder and drop it into the corresponding component in the design area of the tool
Select Data Source in the Data Source property of the component
Select Data Source in the Application property

Explanation

Question 47 of 200

1

Basic Components includes

Select one or more of the following:

Button
Chart Type Picker
Checkbox and Checkbox Group
Filter Line
Date Field
Geo Map
Dropdown box
Chart
Crosstab
Fromatted Text view

Explanation

Question 48 of 200

1

Analytic Components includes

Select one or more of the following:

Dimension Filter
Filter Panel
Spreadsheet
Scorecard
Filter Line
Chart Type Picker
Tabstrip
Info field
Crosstab
Geo Map

Explanation

Question 49 of 200

1

Container Components include

Select one or more of the following:

Grid Layout
Page number
Pagebook
Panel
Navigation Panel
Popup
Split Cell Container
Tabstrip
Merge Cell Container

Explanation

Question 50 of 200

1

This type of component is used to optimize an application for a mobile device and enable specific motion gestures in mobile applications

Select one of the following:

Components
Container
Basic
Analytic

Explanation

Question 51 of 200

1

This type of component is used to enable navigation and user interaction at runtime, enhance the design and layout of the application

Select one of the following:

Components
Container
Basic
Analytic

Explanation

Question 52 of 200

1

The ❌ displays multi-dimensional data in a grid with analytic functions.

Drag and drop to complete the text.

Crosstab

Tablestrip

Geo map

Explanation

Question 53 of 200

1

Which of the following is not true about Crosstab component in Design studio?

Select one of the following:

You can enable/disable navigation functions like hierarchical navigation, sorting, column resizing function
Exceptions defined in SAP BW backend or in Analysis Office can be activated in crosstab setting
Exceptions are not supported in Design Studio
Context Menu available and can be adjusted
RRI is supported

Explanation

Question 54 of 200

1

Feeding Panel is not compatible with Charts, only with Info Charts.

Select one of the following:

True
False

Explanation

Question 55 of 200

1

With the info Chart component, you could assign only crosstab rows and columns. With Chart component, each dimension can be assigned a different axis independently.

Select one of the following:

True
False

Explanation

Question 56 of 200

1

Which of the following can you do with the Navigational Panel?

Select one or more of the following:

Configure whether key figures should be included in filter line
You let end-users navigate via drag and drop (dimensions and measures)
Quick access to dimension and measures via search bar
Option to pause refresh
Measures and Dimension are shown in one area only to simplify view
Measures can be shown separately

Explanation

Question 57 of 200

1

The order of dimensions in a Navigational Panel can be determined in runtime

Select one of the following:

True
False

Explanation

Question 58 of 200

1

Drag and Drop from Navigational Panel to Crosstab is a default setting in Application property

Select one of the following:

True
False

Explanation

Question 59 of 200

1

The Filter Panel component can be used for ❌

Drag and drop to complete the text.

Filtering and Navigation

Selecting dimension and measures

Choosing filter options

Configuring data on a crosstab

Explanation

Question 60 of 200

1

Which of the following are true about Filter Line component

Select one or more of the following:

Horizontal filter area
Vertical filter area
End-users can easily select filter criteria and filter values
Application designers can configure whether key figures should be included in filter line
Configuration by properties, no scripting is required
Application designers can configure whether dimensions should be included in filter line

Explanation

Question 61 of 200

1

Which of the following is true about Dimension Filter?

Select one or more of the following:

Horizontal filter area
Application designer can decide to enable "Filter only", "Navigation only" or both
Member display could be defined as text, key, or both
Dimension name could be shown or hidden
Ranges are able to be defined in addition to multiple selection of members
Specify other data sources as target
Specifies the dimension to be filtered

Explanation

Question 62 of 200

1

Design studio generates a generic prompt screen if prompts are defined ❌ and do not have a valid default value in the Data source or the Application is set to "Force prompts on Startup"

Drag and drop to complete the text.

as mandatory

as optional

as variable

as mandatory variable

Explanation

Question 63 of 200

1

Grid layout is used to group and order the content of an application and is displayed at runtime

Select one of the following:

True
False

Explanation

Question 64 of 200

1

The ❌ component enables the user to switch between different views of an application.

Drag and drop to complete the text.

Pagebook

Tabstrip

Panel

Popup

Image

Text

Explanation

Question 65 of 200

1

Pages are shown in the outline view

Select one of the following:

True
False

Explanation

Question 66 of 200

1

If you use Pagebook component in the layout editor, the system automatically creates one page for the Pagebook.

Select one of the following:

True
False

Explanation

Question 67 of 200

1

If you want to add further pages on a Pagebook component, use the content menu of the Pagebook in the Outline view and ❌

Drag and drop to complete the text.

click Create Child → Page

click Pagebook → Choose Page

click Create Pagebook → Page

click Create Child → Page N

Explanation

Question 68 of 200

1

Pagebook component are compatible with any browser types/versions and capable to display the transition effects correctly.

Select one of the following:

True
False

Explanation

Question 69 of 200

1

❌ is used to group and order the content of your application in tabs. You can also use it to enable user interaction within the application.

Drag and drop to complete the text.

Tabstrip component

Pagebook component

Filter Line component

Filter Panel component

Navigational Panel

Explanation

Question 70 of 200

1

Application designer must add a script to the tabstrip to enable interaction within the application. The script is triggered when the user selects one of the tabs on the tabstrip

Select one of the following:

True
False

Explanation

Question 71 of 200

1

With the ❌, you can specify which tab should be displayed initially. The Index starts with 0, which means the first tab is Index = 0.

Drag and drop to complete the text.

Selected Tab Index Property

On Select Property

On Select Index Property

Select Index Property

Explanation

Question 72 of 200

1

❌ is used to group other components in your application. This is a very simple container component.

Drag and drop to complete the text.

Panel component

Pagebook component

Tabstrip component

Popup component

Explanation

Question 73 of 200

1

The components nested in the Panel are positioned ❌ to the Panel and not to the Application border.

Drag and drop to complete the text.

relative

linear

beside

10 pixels to the left

Explanation

Question 74 of 200

1

❌ helps users to quickly enter information, perform configurations or make selections. In addition, it can also be useful for displaying more specific data for a selected item.

Drag and drop to complete the text.

Popup component

Panel component

Pagebook component

Tabstrip component

Navigational component

Explanation

Question 75 of 200

1

You can only put texts component into a popup

Select one of the following:

True
False

Explanation

Question 76 of 200

1

Which of the following are the restrictions of using Popup component?

Select one or more of the following:

Popup can only be nested in the root layout and not within another container
Popup can only be nested in the container and not within root layout
Popup can only be positioned relative to the root layout
Popup can only be positioned relative to another container
Popup can only be positioned linear to another container

Explanation

Question 77 of 200

1

Popup component is set to visible by default

Select one of the following:

True
False

Explanation

Question 78 of 200

1

Working with Design Studio Applications provides Multi language support

Select one of the following:

True
False

Explanation

Question 79 of 200

1

❌ to add translations centrally

Drag and drop to complete the text.

Text pool

Translation component

Translation pool

Text Translation

Explanation

Question 80 of 200

1

This component is used to add text to your application. Text can be formatted with Style Property and use of one the predefined styles out of the selected theme

Select one of the following:

Formatted Text View
Text Component
Text pool

Explanation

Question 81 of 200

1

This component is used to enable the user to apply text formatting within one control.

Select one of the following:

Formatted Text View
Formatted Text Pool
Text pool
Text Component

Explanation

Question 82 of 200

1

Which of the following is true about Data Bound Component Properties

Select one or more of the following:

You can bind dropdown, List boxes to master data
You can bind text elements to measure values
Scripting is required to trigger functions when the user selects the component
No scripting is required
Bind CSS style to measure value conditions (e.g. for conditional highlighting)

Explanation

Question 83 of 200

1

How would you bind a text component to a cell value?

Select one of the following:

Select the text property → Click on the Binding Icon → Choose the Select Data icon → Select the Data Source → Click in the cell you want to use as source → OK
Select the text property → Click on the Binding Icon → Choose the Select Data icon → Select the Data Source → OK
Select the text property → Click on the text Icon → Choose the Select Data icon → Select the Data Source → Click in the cell you want to use as source → OK

Explanation

Question 84 of 200

1

How would you bind Listbox and Define Filtering?

Select one of the following:

Enable the Source settings → Define the Data Binding → Define the Target settings
Enable the Data Binding → Define the Source settings → Define the Target settings
Enable the Data Binding → Define the Target settings → Define the Source settings

Explanation

Question 85 of 200

1

Scorecard is recommended to be used with dynamic data sources and data sources with free multidimensional navigation (slice and dice)

Select one of the following:

True
False

Explanation

Question 86 of 200

1

The ❌ is designed for use in dashboards and reports with controlled visualization content and restricted navigation possibilities.

Drag and drop to complete the text.

Scorecard Component

Scoreboard Component

Info Chart Component

Info field Component

Explanation

Question 87 of 200

1

Auto Generation of Scorecard analyzes fully any specialties of the data source.

Select one of the following:

True
False

Explanation

Question 88 of 200

1

Steps to create a Scoreboard

Select one of the following:

Add Scoreboard to the Application → Assign a Data source → Define the row scope → Define Columns and Group Headers
Add Scoreboard to the Application → Assign a Crosstab → Define the row scope → Define Columns and Group Headers
Add Scorecard to the Application → Assign a Data source → Define the row scope → Define Columns and Group Headers
Add Scorecard to the Application → Assign a Crosstab → Define the row scope → Define Columns and Group Headers

Explanation

Question 89 of 200

1

The ❌ define how many or how detailed your data is presented in the Scorecard

Drag and drop to complete the text.

Row Scope property

Columns and Group Headers

Data Source property

Column Scope property

Explanation

Question 90 of 200

1

Interoperability between Analysis Office and Design studio

Select one or more of the following:

Smart Copy/Smart Paste
Create Web Application
Create Design Studio Application
Copy/Paste

Explanation

Question 91 of 200

1

Which of the following are true statements about Smart Copy ?

Select one or more of the following:

It copies the navigation state of a single or multiple Data Sources into the clipboard
It copies the navigation state of a single Data Sources into the clipboard
Data Source is added in Design Studio via Smart Copy
Data Source is added in Design Studio via Smart Paste
Visualization is created automatically
No Visualization is created in Design Studio automatically

Explanation

Question 92 of 200

1

If you want to use the "Create Web Application" Function in Analysis, the button needs to be activated in the ❌

Drag and drop to complete the text.

Settings → Advanced Settings

Options → Advanced Settings

Settings → Platform Settings

Settings → User Settings

Explanation

Question 93 of 200

1

Which of the following Analysis components can be transferred to Design studio?

Select one or more of the following:

Crosstab
Data Source
Charts such as Pie, Line, Column, Bar, Surface, Radar, Bubble and Scatter
Charts such as Pie, Line, Column, Bar, Waterfall, Radar, Bubble and Scatter
Filter Panel
Filter

Explanation

Question 94 of 200

1

You can used Create Web Application even when the Design Studio is open

Select one of the following:

True
False

Explanation

Question 95 of 200

1

Script to manually add Export to Lumira option to any application: DS_1.export(❌);

Drag and drop to complete the text.

DataSourceExportType.LUMIRA_lums

ExportType.LUMIRA_lums

DataSourceExportType.LUMIRA

DataFileExportType.LUMIRA_lums

Explanation

Question 96 of 200

1

The Generic Analysis Template has no data source assigned by default. The users execute it and then assign a data source at runtime. This means the template remains generic and independent of the data source.

Select one of the following:

True
False

Explanation

Question 97 of 200

1

Which features are available in Ready to Run: Online Composition?

Select one or more of the following:

Overview page to see all composition
Create, Edit, Delete, Open and Share Composition
Global Filters for composition
Overview page to see all Global Filters
Create, Edit, Delete Composition

Explanation

Question 98 of 200

1

Which features are available in Ready to Run: Data Exploration & Visualization App?

Select one or more of the following:

Use RRI interface
Visualize several datasources and display them in one story
Visualize with only one data source and display them in one story
Share a PDF export of a story and URL link to the story
New Info Charts and Feeding Component
Custom Measures and Top N Filters

Explanation

Question 99 of 200

1

Define your Template Folders: ❌ → Application Templates

Drag and drop to complete the text.

Tools → Preferences → Application Design

Tools → Settings → Application Design

Tools → Preferences → Application

Tools → Preferences → Design

Explanation

Question 100 of 200

1

Export the Application you want to use as new Template: ❌

Drag and drop to complete the text.

Application → Export as Template

Design Application → Export as Template

Application → Export

Design Application → Template

Explanation

Question 101 of 200

1

Which CSS attributes are supported for both desktop browser and iPad/iPhone application?

Select one or more of the following:

font size
font color
weight (bold)
style (italic)
text decoration (underline)
background
text decoration (strikethrough)

Explanation

Question 102 of 200

1

The scripts are executed on the ❌ (unlike JavaScript that is executed in the Web browser)

Drag and drop to complete the text.

Analysis Application Design Service

Analysis Application Designer Service

Analytic Application Design Service

Analytic Application Designer Service

Explanation

Question 103 of 200

1

Script Statement Types

Select one or more of the following:

call statements
conditional execution statements
assignment statements
calling statements
exception execution statements

Explanation

Question 104 of 200

1

Call statement Sytanx : ❌

Drag and drop to complete the text.

.();

IF xxx THEN xxx ELSE

VAR =

=

Explanation

Question 105 of 200

1

It offers content assistance.

Select one of the following:

CTRL + ENTER
CTRL + SPACE
CTRL + SHIFT + SPACE
CTRL + ?

Explanation

Question 106 of 200

1

BI Types: Design studio needs to know what type a parameter has. Which of the following is not included in BI Types?

Select one of the following:

Dimension
Member
Filter
MemberPresentation
ChartType
None of the above

Explanation

Question 107 of 200

1

Application methods to analyze the general behavior of your Design Studio application

Select one of the following:

log, alert, createErrorMessage, createWarningMessage, createInfoMessage
log, alert, createErrMessage, createWarningMessage, createInfoMessage
log, alert, createErrorMsg, createWarningMsg, createInfoMsg

Explanation

Question 108 of 200

1

Plug-ins that are included in SAP BusinessObjects Analysis, edition for Microsoft Office for both Excel and Powerpoint

Select one or more of the following:

Live Office
Analysis
EPM
Data Manager

Explanation

Question 109 of 200

1

BOAO is for multidimensional analysis of OLAP sources

Select one of the following:

True
False

Explanation

Question 110 of 200

1

The edition of SAP BusinessObjects Analysis for OLAP is accessed in ❌

Drag and drop to complete the text.

BI Launch pad

Central Management Console

Central Configuration Manager

Explanation

Question 111 of 200

1

In what cases do we use Analysis, edition for MS Office?

Select one or more of the following:

Building MS Office Content in Excel & Ppt
Ad hoc Data Analysis in Excel
Consuming pre-defined BI Content in Excel and Ppt
Sophisticated workbook design that uses VBA APIs and so on
None of the Above
Exploring and Visualizing pre-defined BI Content

Explanation

Question 112 of 200

1

Three user profiles in SAP BOAO

Select one or more of the following:

Workbook Creator
Data Analyst
Administrator
Data Modeling Analyst
Architecture
SAP BW Consultant

Explanation

Question 113 of 200

1

What do you call on a new inserted sheet in Analysis?

Select one of the following:

Neutral
Analysis Sheet
Workbook sheet
Sheet

Explanation

Question 114 of 200

1

For Microsoft Powerpoint, you can add data sources with Analysis plug-in only

Select one of the following:

True
False

Explanation

Question 115 of 200

1

Info fields are available in BOAO both excel and ppt

Select one of the following:

True
False

Explanation

Question 116 of 200

1

We can access Analysis in MS Excel through

Select one or more of the following:

MS 2007, analysis options are available via File → Analysis
MS 2007, analysis options are available via MS Office button
MS 2010, Analysis options are available in the ribbon tab under File → Analysis

Explanation

Question 117 of 200

1

Which panel in BOAO is used to create views of your data, to find information on the used data sources and the components on your workbook?

Select one of the following:

Analysis Design Panel/Design Panel
Information Panel
Analysis Panel
Components Panel

Explanation

Question 118 of 200

1

What happens when working with the Design panel?

Select one of the following:

The crosstab is updated after each navigation step
The crosstab is updated before and after each navigation step
The crosstab cross checks the data on BEx query
The crosstab creates, updates, and deletes data after each navigation step

Explanation

Question 119 of 200

1

This is where we view the available fields for a single data source and the fields currently used in a crosstab

Select one of the following:

Analysis tab
Components tab
Analysis Design tab
Information tab

Explanation

Question 120 of 200

1

This is where we find the information about a data source or the entire workbook and used filters and variables.

Select one of the following:

Information tab
Analysis Design tab
Analysis tab
Info Fields

Explanation

Question 121 of 200

1

We cannot display information of a data source and entire workbook through drag and drop of information fields in the information tab

Select one of the following:

True
False

Explanation

Question 122 of 200

1

When using components tab for setting preferences, which is the highest node for the available components?

Select one of the following:

Workbook Settings
Data Source Settings
Crosstab Settings
Default Settings

Explanation

Question 123 of 200

1

Which of the following are the three tabs in the design panel?

Select one or more of the following:

Analysis
Components
Information
Worksheet

Explanation

Question 124 of 200

1

If HANA is implemented, what are the two additional data sources for Analysis?

Select one or more of the following:

local providers
composite providers
Remote Providers
Virtual Providers

Explanation

Question 125 of 200

1

If Analysis tab does not appear, the Analysis Add-in can be manually enabled.

Select one of the following:

True
False

Explanation

Question 126 of 200

1

Which of the following is true about break hierarchies?

Select one or more of the following:

Members are sorted independently of the hierarchy
The data is converted to a flat list
Result sets are reduced with focus on the most important data
Result set are color coded

Explanation

Question 127 of 200

1

If you open the Filter by Measure dialog box from a measure cell, the options such as definition is applied to a selected dimension, to all dimensions or to the most detailed dimension in your analysis are available

Select one of the following:

True
False

Explanation

Question 128 of 200

1

Dimensional Hierarchies that are created or imported in SAP BW are called Characteristic Hierarchies

Select one of the following:

True
False

Explanation

Question 129 of 200

1

Display hierarchies and dimensional hierarchies cannot be used in parallel

Select one of the following:

True
False

Explanation

Question 130 of 200

1

When using multiple queries in a workbook, you can open the prompt dialog by Data Source or by Query

Select one of the following:

True
False

Explanation

Question 131 of 200

1

Which of the following are performed for general settings in the Conditional Formatting dialog?

Select one or more of the following:

Choose the format option
Assign a name to the specific conditional formatting
Choose the measure for the conditional formatting
Format the filter components

Explanation

Question 132 of 200

1

It is not possible to restrict conditional formatting to specific area or member selection

Select one of the following:

True
False

Explanation

Question 133 of 200

1

You can delete all user-defined style sets and all that are installed with the Add-in.

Select one of the following:

True
False

Explanation

Question 134 of 200

1

Since styles are workbook-specific, you cannot import or export them

Select one of the following:

True
False

Explanation

Question 135 of 200

1

Which of the following can be used to supplement a crosstab?

Select one or more of the following:

Info Fields
Dynamic Charts
Filter Components
Dimensional Hierarchies

Explanation

Question 136 of 200

1

A waterfall chart can be used to show how an initial value is affected by a series of intermediate positive or negative values

Select one of the following:

True
False

Explanation

Question 137 of 200

1

Filter Functions can be used for which of the following?

Select one or more of the following:

Display Dynamic Filters
Display Static Filters
Display Effective Filters
Display User Filters

Explanation

Question 138 of 200

1

You can access User, Advanced, Platform, and Support settings via File → Analysis → Settings

Select one of the following:

True
False

Explanation

Question 139 of 200

1

The Design Studio enables application designers to create analysis applications and dashboards for browser and mobile devices on top of BW and SAP HANA data sources

Select one of the following:

True
False

Explanation

Question 140 of 200

1

You cannot use VBA to read values from cells in worksheets

Select one of the following:

True
False

Explanation

Question 141 of 200

1

When you have a data source with numerous rows you can use Fit Table feature to break the result into multiple slides

Select one of the following:

True
False

Explanation

Question 142 of 200

1

If a table is split across multiple slides and one or more of the details is manually deleted, the lost slides cannot be recovered

Select one of the following:

True
False

Explanation

Question 143 of 200

1

Columns and Rows in BOAO contain either measures or dimensions

Select one of the following:

True
False

Explanation

Question 144 of 200

1

BOAO must be installed on local machine. What are the available platforms and data sources?

Select one or more of the following:

SAP BW system
SAP BusinessObjects Business Intelligence Platform
SAP HANA
SYBASE

Explanation

Question 145 of 200

1

For the installation of Analysis, what components should be installed first?

Select one or more of the following:

MS Office (Excel and Powerpoint)
JDBC
MS .NET Framework 4.5 Redistributable Package for BIBO 4.1 Platform
MS .NET Framework 4.5 Redistributable Package for BIBO 4.3 Platform

Explanation

Question 146 of 200

1

Which applications can be used for accessing Analysis views?

Select one or more of the following:

Crystal Reports for Enterprise
WEBi
BOAO
BOAO for OLAP
Design Studio
Crystal Reports 2016

Explanation

Question 147 of 200

1

How can you access the Analysis client for Excel?

Select one of the following:

Start → All Programs → SAP Business Intelligence → SAP BusinessObjects Analysis → Analysis for MS Excel
Start → All Programs → SAP Business Warehouse → SAP BusinessObjects Analysis → Analysis for MS Excel
RDMX
RRMX
Excel icon → Analysis Ribbon in Excel

Explanation

Question 148 of 200

1

How do you manually enable and disable Analysis Client?

Select one of the following:

File → Options → Add-ins → Next to Manage, Select Com Add-ins → Choose Go → Select Analysis → OK
File → Settings → Add-ins → Next to Manage, Select Com Add-ins → Choose Go → Select Analysis → OK
Cannot be done
File → Options → Analysis Add-ins → Next to Manager, Select Com Add-ins → Choose Go → Select Analysis → OK

Explanation

Question 149 of 200

1

What are the main data sources for Analysis?

Select one or more of the following:

BW Queries
InfoProviders
HANA views
Query views
Universe
Relational connection

Explanation

Question 150 of 200

1

These are pre-analyzed data that implement business logic

Select one of the following:

HANA views
Query views
Analysis views

Explanation

Question 151 of 200

1

An area in which new models can be created based on a central data provider (e.g. Multiprovider) from BW and local data

Select one of the following:

BW Workplace
BW Workspace
BW Modeler
BW Workbench

Explanation

Question 152 of 200

1

These are tables in HANA that can be created from a flat file which can be added to a workbook as a data source

Select one of the following:

Local Provider
Composite Provider
Virtual Provider
Hybrid Provider

Explanation

Question 153 of 200

1

Combination of all the data that you want to view in your query

Select one of the following:

Local Providers
Local Composite Provider
Virtual Provider
Hybrid Provider

Explanation

Question 154 of 200

1

This can be used to view data in Analytic and other views for complex scenarios

Select one of the following:

A calculation view
A formula view
A conditional view

Explanation

Question 155 of 200

1

a data tables made up of row and column axis (report axis)

Select one of the following:

Analysis crosstab
Table
Data Table
Query Table

Explanation

Question 156 of 200

1

In Default view in Crosstab, the Default view of all BW sources should be

Select one of the following:

as in BEx
as defined by Query View
measures in the columns, aggregated over all dimensions
BEx Query Designer

Explanation

Question 157 of 200

1

Refreshing the data source will update your analysis with the changes

Select one of the following:

True
False

Explanation

Question 158 of 200

1

You can build an entire report by using Analysis tab

Select one of the following:

True
False

Explanation

Question 159 of 200

1

Areas in Analysis Tab

Select one or more of the following:

Explorer area
Field Explorer area
Rows/Columns area
Background filter
Filter member area

Explanation

Question 160 of 200

1

Configure Display for Members in BOAO

Select one of the following:

Select a dimension header → choose Members display menu → select the desired option (text, key, text and key, key and text)
Select a dimension header → choose Measures display menu → select the desired option
Select a column header → choose Measures display menu → select the desired option (Number format, Show SF, Currency Translation, General Format)

Explanation

Question 161 of 200

1

Comments in BOAO will be deleted when we changed the view on your data

Select one of the following:

True
False

Explanation

Question 162 of 200

1

In jumping to all targets using RRI, what would you use?

Select one of the following:

Goto
GotoAll
Gotoin

Explanation

Question 163 of 200

1

With sorting in BOAO, if you sort values of one measure, the other cells in your crosstab are also affected

Select one of the following:

True
False

Explanation

Question 164 of 200

1

Filtering members is a dynamic action because the members you have removed from your analysis remain excluded unless change the filter criteria and include them again

Select one of the following:

True
False

Explanation

Question 165 of 200

1

Ways on how to Filter by Member

Select one or more of the following:

Sort icon
Filter icon
Via context menu
Dragging elements to background filter

Explanation

Question 166 of 200

1

What are the filter options in the Filter icon?

Select one or more of the following:

Filter by Members
Filter by Measure
Select All Members
Supress Zeros on Rows and on Columns
Filter other members

Explanation

Question 167 of 200

1

Filter by Member is the only method in Analysis for Powerpoint

Select one of the following:

True
False

Explanation

Question 168 of 200

1

You can filter on hierarchy nodes. In filtering hierarchy nodes, You cannot display leaves only but you can display the entire Hierarchy

Select one of the following:

True
False

Explanation

Question 169 of 200

1

Which of the following are the Access Mode in Filter by member?

Select one or more of the following:

Read mode
Posted Values in the InfoProvider
Posted data in the current navigational state
Filter on Values in Master Data
Update mode
Write mode

Explanation

Question 170 of 200

1

Types of selection in filtering

Select one or more of the following:

Measure
Member
Individual
Range

Explanation

Question 171 of 200

1

With filtering by measures, you can define one or multiple rules (parameters) to filter the data of your analysis and not affecting the total or subtotals in your analysis

Select one of the following:

True
False

Explanation

Question 172 of 200

1

With filter by Measure, we can restrict all dimensions to top N independently

Select one of the following:

True
False

Explanation

Question 173 of 200

1

How would you exclude members that are not displayed in your analysis in totaling?

Select one of the following:

Totals → Calculate Total As → Only displayed values
Totals → Only displayed values
Totals → Calculate Total As → Sum
Totals → Calculate Total As → Sum of Displayed values

Explanation

Question 174 of 200

1

Which of the following are true about working with BEx conditions in Analysis?

Select one or more of the following:

BEx conditions correspond to a filter by measure
BEx conditions can be defined for a query created in BEx Query Designer
BEx conditions can be defined for a query view created in BEx tools such as BEx Web Analyzer
BEx conditions can be defined for a workbook created in BEx Analyzer
Inserting a query view with conditions in Analysis recognize activated and deactivated conditions as BEx conditions and displayed as filter by measure
BEx conditions from a workbook created in BEx Analyzer can be activated and deactivated before workbook conversion

Explanation

Question 175 of 200

1

How would you activate and deactivate conditions as BEx Conditions in Analysis?

Select one or more of the following:

Filter icon → BEx Conditions
Filter icon → Filter by measure
Filter icon → Filter by member

Explanation

Question 176 of 200

1

Your customer wants to create new measures in your analysis without changing the query definition

Select one or more of the following:

Create new measure based on Simple Calculation
Create new measure based on Math Calculation
Create new measure based on Dynamic Calculation
Create new measure based on Free-Form Calculation
Create Restricted Measure for HANA Data sources

Explanation

Question 177 of 200

1

With Dynamic Calculation, we use two or more available measures

Select one of the following:

True
False

Explanation

Question 178 of 200

1

Where can you specify whether all time-dependent hierarchies for a dimension should be available or only the hierarchy for a selected date?

Select one of the following:

In settings, select Advanced Settings
In Analysis ribbon, select Hierarchy
In Design panel, select Hierarchy

Explanation

Question 179 of 200

1

How to expand node to Level

Select one or more of the following:

Select a member cell of the dimension → Via context menu → expand node to level
Select a member cell of the dimension → Hierarchy drop down option in the menu → expand node to level
Select a member cell of the dimension → choose Hierarchy Show level → select the level → OK
Select a member cell of the dimension → Hierarchy menu → Show levels

Explanation

Question 180 of 200

1

Hierarchy totals can be displayed at the top or the bottom of the crosstab. When you choose Expand Upwards (Rows), the totals will be displayed at the bottom

Select one of the following:

True
False

Explanation

Question 181 of 200

1

In sorting with hierarchy, the members of the hierarchy are sorted within their groups by default unless you use Break Hierarchies

Select one of the following:

True
False

Explanation

Question 182 of 200

1

What do you call this option in which you can display multiple dimensions hierarchically without using dimensional hierarchy?

Select one or more of the following:

Filter
Sorting
Compact display in rows or columns
Runtime/Display Hierarchy

Explanation

Question 183 of 200

1

What should be set in order for a variable to be editable in the prompting dialog?

Select one or more of the following:

It must be input-ready
set to Manual Input in the Query Designer
it must not be input-ready
set to automatic Input in the Query Designer

Explanation

Question 184 of 200

1

Saved variable values in a workbook

Select one of the following:

Variant
Parameter
Variable values
Prompt values

Explanation

Question 185 of 200

1

The use of the operators in prompts, such as =, >=, [], *, ![], must be enabled in the registry by your IT administrator

Select one of the following:

True
False

Explanation

Question 186 of 200

1

When you have multiple queries in a workbook, what options are available to open the prompt dialog?

Select one or more of the following:

Open prompt dialog by workbook to see all variables
Open prompt dialog by data source to see variables for a specific query
Open prompt dialog by all query to see all variables
Open prompt dialog by sheet to see variables for a specific query

Explanation

Question 187 of 200

1

We can define variant for a query or for a document (workbook or presentation) and for a user-specific or global variant.

Select one of the following:

True
False

Explanation

Question 188 of 200

1

We can create multiple variants and multiple active variants.

Select one of the following:

True
False

Explanation

Question 189 of 200

1

Working with document variant is document mode. What is working with query variant?

Select one of the following:

data source mode
query mode
query source mode
query view

Explanation

Question 190 of 200

1

On what tab in Design panel would you see the Merge Variables?

Select one of the following:

Design tab
Analysis tab
Information tab
Components tab

Explanation

Question 191 of 200

1

What authorization object must be maintained in the Netweaver server so that the user can create variant?

Select one of the following:

S_RS_PARAM
R_SR_PARAM
S_SR_PARAM
S_RS_COMP

Explanation

Question 192 of 200

1

In data source mode, the context menu for prompts is only available if workbook property Merge Variables is selected unlike in document mode

Select one of the following:

True
False

Explanation

Question 193 of 200

1

In data source mode, Workbook property Merge Variables is selected when a new query is inserted so you don't have to select Merge Variables again

Select one of the following:

True
False

Explanation

Question 194 of 200

1

You can select various workbook properties on the Components tab in the Design panel that does not affect the behavior of the prompting dialog and existing prompt values.

Select one of the following:

True
False

Explanation

Question 195 of 200

1

To configure workbook properties, be sure to select the crosstab or the name of the data source on the Components tab

Select one of the following:

True
False

Explanation

Question 196 of 200

1

Which of the following options can be selected for workbook properties on the Components tab?

Select one or more of the following:

Remove Data before Saving
Force Prompt for Initial Refresh
Refresh workbook on Opening
Store prompts with Workbook
Merge variables
Update Data on Opening
Remove Data Cells before Saving

Explanation

Question 197 of 200

1

You can use the logic AND and OR in conditional formatting

Select one of the following:

True
False

Explanation

Question 198 of 200

1

In Conditional Formatting, how can you shift the visualization to a different measure than the one the rules have been defined on?

Select one of the following:

In New Conditional Formatting screen, choose display → check Applied to under Apply Visualization to Another measure → then choose a member
In New Conditional Formatting screen, choose selection → check Applied to under Apply Visualization to Another measure → then choose a member
In New Conditional Formatting screen, choose definition → check Applied to under Apply Visualization to Another measure → then choose a member

Explanation

Question 199 of 200

1

How do you apply conditional Formatting?

Select one of the following:

Conditional Formatting → New → Enter name → select measure → select style → define one or more rules on the definition tab by selecting a priority, operator, and threshold value → add
Conditional Formatting → New → Enter name → select member → select style → define one or more rules on the definition tab by selecting a priority, operator, and threshold value → add
Conditional Formatting → New → Enter name → select measure → select style → define one or more rules on the selection tab by defining for each dimension if the conditional formatting should be applied to All Members and Totals or only to Members or Totals → add
Conditional Formatting → New → Enter name → select measure → select style → define one or more rules on the display tab by defining which parts of the crosstab are affected by conditional formatting: Data cells, Row headers, Column headers and apply visualization for another measure → add

	Created by Hannylou Celestial over 6 years ago

Prep Questions

TBI15

Question 1 of 200

Who are the target users for BOAO, MS Powerpoint?

Select one of the following:

Explanation

Question 2 of 200

Use Cases for Analysis for Powerpoint

Select one of the following:

Explanation

Question 3 of 200

Analysis for Powerpoint have the same functionality as Analysis for Excel

Select one of the following:

Explanation

Question 4 of 200

Analysis Powerpoint does not have a Design Panel

Select one of the following:

Explanation

Question 5 of 200

Available features in Analysis for Powerpoint ribbon

Select one of the following:

Explanation

Question 6 of 200

Which Settings are available in Analysis for Powerpoint?

Select one or more of the following:

Explanation

Question 7 of 200

Available Properties to configure for the entire presentation

Select one or more of the following:

Explanation

Question 8 of 200

When you smart paste a crosstab or a chart from a current navigation state in Excel to Analysis for Powerpoint, the objects paste in Powerpoint exist dependently to the objects in Excel

Select one of the following:

Explanation

Question 9 of 200

What are the options available in using Fit Table feature?

Select one or more of the following:

Explanation

Question 10 of 200

What is the maximum number of rows per slide in Analysis for Powerpoint?

Select one of the following:

Explanation

Question 11 of 200

If the number of total rows has changed, slides are created and/or deleted based on the changes when it is data refreshed.

Select one of the following:

Explanation

Question 12 of 200

Which options of Fit table would you use if you want to truncate data from the Dimension at row N and display "..." indicating the users that there is more data but they are hidden.

Select one of the following:

Explanation

Question 13 of 200

In Abbreviating table, Sorting will not affect the display of data

Select one of the following:

Explanation

Question 14 of 200

If you turn a split table into an abbreviation table, one or more slides are added.

Select one of the following:

Explanation

Question 15 of 200

You have the option to delete existing slides via Fit Table Dialog

Select one of the following:

Explanation

Question 16 of 200

If a table is split across multiple slides and one or more slides is manually deleted, the lost slides are replaced on refresh.

Select one of the following:

Explanation

Question 17 of 200

You may change the display order of the slides from a split table. But when you refresh the data it will be back from the initial order

Select one of the following:

Explanation

Question 18 of 200

What are the following available options for info field in Analysis for Powerpoint?

Select one or more of the following:

Explanation

Question 19 of 200

Which of the following are true statements about Info field in Analysis for Powerpoint?

Select one or more of the following:

Explanation

Question 20 of 200