Copy and Edit

TBI15

Description

Prep Questions
Hannylou Celestial
Quiz by Hannylou Celestial, updated more than 1 year ago
Hannylou Celestial
Created by Hannylou Celestial over 6 years ago
28
1
0

Resource summary

Question 1

Question
Who are the target users for BOAO, MS Powerpoint?
Answer
  • Business Users
  • Data Analyst
  • SAP BW Consultants

Question 2

Question
Use Cases for Analysis for Powerpoint
Answer
  • Distribution of Analysis (Slide deck building)
  • Distribution of Analysis (Workbookbuilding)
  • Analysis

Question 3

Question
Analysis for Powerpoint have the same functionality as Analysis for Excel
Answer
  • True
  • False

Question 4

Question
Analysis Powerpoint does not have a Design Panel
Answer
  • True
  • False

Question 5

Question
Available features in Analysis for Powerpoint ribbon
Answer
  • 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

Question 6

Question
Which Settings are available in Analysis for Powerpoint?
Answer
  • 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)

Question 7

Question
Available Properties to configure for the entire presentation
Answer
  • 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

Question 8

Question
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
Answer
  • True
  • False

Question 9

Question
What are the options available in using Fit Table feature?
Answer
  • Split Table
  • Fit Table
  • Abbreviate Table
  • Hide Table

Question 10

Question
What is the maximum number of rows per slide in Analysis for Powerpoint?
Answer
  • 65
  • 75
  • 99
  • 1,000,000

Question 11

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

Question 12

Question
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.
Answer
  • Fit Table
  • Split Table
  • Abbreviate Table

Question 13

Question
In Abbreviating table, Sorting will not affect the display of data
Answer
  • True
  • False

Question 14

Question
If you turn a split table into an abbreviation table, one or more slides are added.
Answer
  • True
  • False

Question 15

Question
You have the option to delete existing slides via Fit Table Dialog
Answer
  • True
  • False

Question 16

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

Question 17

Question
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
Answer
  • True
  • False

Question 18

Question
What are the following available options for info field in Analysis for Powerpoint?
Answer
  • Presentation name
  • Key date
  • Data Source name
  • Last Data update
  • Effective Filters
  • Variables

Question 19

Question
Which of the following are true statements about Info field in Analysis for Powerpoint?
Answer
  • 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

Question 20

Question
Available Platforms in Saving Platforms
Answer
  • SAP BI Platform
  • SAP Netweaver Platform
  • SAP Lumira Cloud
  • SAP BW Server

Question 21

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

Question 22

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

Question 23

Question
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
Answer
  • Crystal Reports 2016
  • Dashboards
  • Lumira
  • Design Studio
  • Information Designer Tool

Question 24

Question
Which of the following are the true statements about Design Studio?
Answer
  • 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

Question 25

Question
Deployment Options for Design Studio Applications
Answer
  • BI Platform
  • SAP Netweaver
  • HANA Native
  • Universe

Question 26

Question
Which of the following are true about Deploying Design Studio Application on BI Platform?
Answer
  • 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

Question 27

Question
Which of the following are true statements about Deploment Options for SAP Netweaver?
Answer
  • 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

Question 28

Question
Which of the following are true about Deploying Design Studio Application on HANA Native?
Answer
  • 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

Question 29

Question
Which of the following are true statements about the Local Mode in Design Studio?
Answer
  • 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

Question 30

Question
Which of the following Platform strategy is recommended by SAP?
Answer
  • 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

Question 31

Question
How would you change the the startup mode from a Local mode to BI Platform?
Answer
  • Choose tools → Preferences → Select SAP BusinessObjects BI Platform
  • Choose Settings→ Preferences → Select SAP BusinessObjects BI Platform
  • Choose Application→ Preferences → Select SAP BusinessObjects BI Platform

Question 32

Question
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.
Answer
  • True
  • False

Question 33

Question
Which of the following can you do on the Welcome page of Design Studio?
Answer
  • 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

Question 34

Question
You can create a new Design Studio Application via
Answer
  • Application menu
  • Toolbar
  • Layout
  • Edit
  • View

Question 35

Question
Storage location of Design Studio Application deployed on BI Platform
Answer
  • Favorites or Public Folder on BI Platform Server
  • BW -ABAP Server
  • HANA Repository
  • C:\Users\<YourUser>\Analysis-workspace\com.sap.ip.bi.zen\repository

Question 36

Question
How to use the "New Application" Dialog
Answer
  • 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

Question 37

Question
Which of the following are main screen elements of Design Studio?
Answer
  • Components
  • Analysis
  • Information
  • Layout
  • Outline
  • Properties

Question 38

Question
Which of the following are the possible additional views on Design Studio?
Answer
  • Additional Properties
  • Properties
  • Script problems
  • Script Editor
  • Search Results
  • ERROR Log
  • Conversion Log

Question 39

Question
Design Studio Sources for a Data Source Object
Answer
  • SAP BW (Query, Query view, InfoProvider)
  • SAP HANA (Analytic View, Calculation View)
  • CSV
  • Universe (Relational and OLAP)
  • Universe (Relational)
  • SAP BW (Query, Query view)

Question 40

Question
Restrictions for Universes as Data Source of a Design Studio Application
Answer
  • 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

Question 41

Question
Ways on how to create a new Data Source
Answer
  • 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

Question 42

Question
Which of the following allows you to modify initial state of any data source?
Answer
  • Initial View dialog box
  • Data Source settings dialog box
  • Components settings dialog box
  • Layout dialog box

Question 43

Question
Which of the following are the options to add components to an Application?
Answer
  • 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

Question 44

Question
Which of the following are not true about Layout Properties and Docking behavior in Design Studio?
Answer
  • 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

Question 45

Question
Which of the following are true about Aligning and Distributing components in layout?
Answer
  • 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

Question 46

Question
Ways on how to assign Data source to a component
Answer
  • 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

Question 47

Question
Basic Components includes
Answer
  • Button
  • Chart Type Picker
  • Checkbox and Checkbox Group
  • Filter Line
  • Date Field
  • Geo Map
  • Dropdown box
  • Chart
  • Crosstab
  • Fromatted Text view

Question 48

Question
Analytic Components includes
Answer
  • Dimension Filter
  • Filter Panel
  • Spreadsheet
  • Scorecard
  • Filter Line
  • Chart Type Picker
  • Tabstrip
  • Info field
  • Crosstab
  • Geo Map

Question 49

Question
Container Components include
Answer
  • Grid Layout
  • Page number
  • Pagebook
  • Panel
  • Navigation Panel
  • Popup
  • Split Cell Container
  • Tabstrip
  • Merge Cell Container

Question 50

Question
This type of component is used to optimize an application for a mobile device and enable specific motion gestures in mobile applications
Answer
  • Components
  • Container
  • Basic
  • Analytic

Question 51

Question
This type of component is used to enable navigation and user interaction at runtime, enhance the design and layout of the application
Answer
  • Components
  • Container
  • Basic
  • Analytic

Question 52

Question
The [blank_start]Crosstab[blank_end] displays multi-dimensional data in a grid with analytic functions.
Answer
  • Crosstab
  • Tablestrip
  • Geo map

Question 53

Question
Which of the following is not true about Crosstab component in Design studio?
Answer
  • 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

Question 54

Question
Feeding Panel is not compatible with Charts, only with Info Charts.
Answer
  • True
  • False

Question 55

Question
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.
Answer
  • True
  • False

Question 56

Question
Which of the following can you do with the Navigational Panel?
Answer
  • 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

Question 57

Question
The order of dimensions in a Navigational Panel can be determined in runtime
Answer
  • True
  • False

Question 58

Question
Drag and Drop from Navigational Panel to Crosstab is a default setting in Application property
Answer
  • True
  • False

Question 59

Question
The Filter Panel component can be used for [blank_start]Filtering and Navigation[blank_end]
Answer
  • Filtering and Navigation
  • Selecting dimension and measures
  • Choosing filter options
  • Configuring data on a crosstab

Question 60

Question
Which of the following are true about Filter Line component
Answer
  • 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

Question 61

Question
Which of the following is true about Dimension Filter?
Answer
  • 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

Question 62

Question
Design studio generates a generic prompt screen if prompts are defined [blank_start]as mandatory[blank_end] and do not have a valid default value in the Data source or the Application is set to "Force prompts on Startup"
Answer
  • as mandatory
  • as optional
  • as variable
  • as mandatory variable

Question 63

Question
Grid layout is used to group and order the content of an application and is displayed at runtime
Answer
  • True
  • False

Question 64

Question
The [blank_start]Pagebook[blank_end] component enables the user to switch between different views of an application.
Answer
  • Pagebook
  • Tabstrip
  • Panel
  • Popup
  • Image
  • Text

Question 65

Question
Pages are shown in the outline view
Answer
  • True
  • False

Question 66

Question
If you use Pagebook component in the layout editor, the system automatically creates one page for the Pagebook.
Answer
  • True
  • False

Question 67

Question
If you want to add further pages on a Pagebook component, use the content menu of the Pagebook in the Outline view and [blank_start]click Create Child → Page[blank_end]
Answer
  • click Create Child → Page
  • click Pagebook → Choose Page
  • click Create Pagebook → Page
  • click Create Child → Page N

Question 68

Question
Pagebook component are compatible with any browser types/versions and capable to display the transition effects correctly.
Answer
  • True
  • False

Question 69

Question
[blank_start]Tabstrip component[blank_end] 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.
Answer
  • Tabstrip component
  • Pagebook component
  • Filter Line component
  • Filter Panel component
  • Navigational Panel

Question 70

Question
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
Answer
  • True
  • False

Question 71

Question
With the [blank_start]Selected Tab Index Property[blank_end], you can specify which tab should be displayed initially. The Index starts with 0, which means the first tab is Index = 0.
Answer
  • Selected Tab Index Property
  • On Select Property
  • On Select Index Property
  • Select Index Property

Question 72

Question
[blank_start]Panel component[blank_end] is used to group other components in your application. This is a very simple container component.
Answer
  • Panel component
  • Pagebook component
  • Tabstrip component
  • Popup component

Question 73

Question
The components nested in the Panel are positioned [blank_start]relative[blank_end] to the Panel and not to the Application border.
Answer
  • relative
  • linear
  • beside
  • 10 pixels to the left

Question 74

Question
[blank_start]Popup component[blank_end] 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.
Answer
  • Popup component
  • Panel component
  • Pagebook component
  • Tabstrip component
  • Navigational component

Question 75

Question
You can only put texts component into a popup
Answer
  • True
  • False

Question 76

Question
Which of the following are the restrictions of using Popup component?
Answer
  • 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

Question 77

Question
Popup component is set to visible by default
Answer
  • True
  • False

Question 78

Question
Working with Design Studio Applications provides Multi language support
Answer
  • True
  • False

Question 79

Question
[blank_start]Text pool[blank_end] to add translations centrally
Answer
  • Text pool
  • Translation component
  • Translation pool
  • Text Translation

Question 80

Question
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
Answer
  • Formatted Text View
  • Text Component
  • Text pool

Question 81

Question
This component is used to enable the user to apply text formatting within one control.
Answer
  • Formatted Text View
  • Formatted Text Pool
  • Text pool
  • Text Component

Question 82

Question
Which of the following is true about Data Bound Component Properties
Answer
  • 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)

Question 83

Question
How would you bind a text component to a cell value?
Answer
  • 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

Question 84

Question
How would you bind Listbox and Define Filtering?
Answer
  • 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

Question 85

Question
Scorecard is recommended to be used with dynamic data sources and data sources with free multidimensional navigation (slice and dice)
Answer
  • True
  • False

Question 86

Question
The [blank_start]Scorecard Component[blank_end] is designed for use in dashboards and reports with controlled visualization content and restricted navigation possibilities.
Answer
  • Scorecard Component
  • Scoreboard Component
  • Info Chart Component
  • Info field Component

Question 87

Question
Auto Generation of Scorecard analyzes fully any specialties of the data source.
Answer
  • True
  • False

Question 88

Question
Steps to create a Scoreboard
Answer
  • 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

Question 89

Question
The [blank_start]Row Scope property[blank_end] define how many or how detailed your data is presented in the Scorecard
Answer
  • Row Scope property
  • Columns and Group Headers
  • Data Source property
  • Column Scope property

Question 90

Question
Interoperability between Analysis Office and Design studio
Answer
  • Smart Copy/Smart Paste
  • Create Web Application
  • Create Design Studio Application
  • Copy/Paste

Question 91

Question
Which of the following are true statements about Smart Copy ?
Answer
  • 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

Question 92

Question
If you want to use the "Create Web Application" Function in Analysis, the button needs to be activated in the [blank_start]Settings → Advanced Settings[blank_end]
Answer
  • Settings → Advanced Settings
  • Options → Advanced Settings
  • Settings → Platform Settings
  • Settings → User Settings

Question 93

Question
Which of the following Analysis components can be transferred to Design studio?
Answer
  • 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

Question 94

Question
You can used Create Web Application even when the Design Studio is open
Answer
  • True
  • False

Question 95

Question
Script to manually add Export to Lumira option to any application: DS_1.export([blank_start]DataSourceExportType.LUMIRA_lums[blank_end]);
Answer
  • DataSourceExportType.LUMIRA_lums
  • ExportType.LUMIRA_lums
  • DataSourceExportType.LUMIRA
  • DataFileExportType.LUMIRA_lums

Question 96

Question
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.
Answer
  • True
  • False

Question 97

Question
Which features are available in Ready to Run: Online Composition?
Answer
  • 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

Question 98

Question
Which features are available in Ready to Run: Data Exploration & Visualization App?
Answer
  • 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

Question 99

Question
Define your Template Folders: [blank_start]Tools → Preferences → Application Design[blank_end] → Application Templates
Answer
  • Tools → Preferences → Application Design
  • Tools → Settings → Application Design
  • Tools → Preferences → Application
  • Tools → Preferences → Design

Question 100

Question
Export the Application you want to use as new Template: [blank_start]Application → Export as Template[blank_end]
Answer
  • Application → Export as Template
  • Design Application → Export as Template
  • Application → Export
  • Design Application → Template

Question 101

Question
Which CSS attributes are supported for both desktop browser and iPad/iPhone application?
Answer
  • font size
  • font color
  • weight (bold)
  • style (italic)
  • text decoration (underline)
  • background
  • text decoration (strikethrough)

Question 102

Question
The scripts are executed on the [blank_start]Analysis Application Design Service[blank_end] (unlike JavaScript that is executed in the Web browser)
Answer
  • Analysis Application Design Service
  • Analysis Application Designer Service
  • Analytic Application Design Service
  • Analytic Application Designer Service

Question 103

Question
Script Statement Types
Answer
  • call statements
  • conditional execution statements
  • assignment statements
  • calling statements
  • exception execution statements

Question 104

Question
Call statement Sytanx : [blank_start]<Component>.<Method>(<Arguments>);[blank_end]
Answer
  • <Component>.<Method>(<Arguments>);
  • IF xxx THEN xxx ELSE
  • VAR <VARIABLE> = <EXPRESSION>
  • <VARIABLE> = <EXPRESSION>

Question 105

Question
It offers content assistance.
Answer
  • CTRL + ENTER
  • CTRL + SPACE
  • CTRL + SHIFT + SPACE
  • CTRL + ?

Question 106

Question
BI Types: Design studio needs to know what type a parameter has. Which of the following is not included in BI Types?
Answer
  • Dimension
  • Member
  • Filter
  • MemberPresentation
  • ChartType
  • None of the above

Question 107

Question
Application methods to analyze the general behavior of your Design Studio application
Answer
  • log, alert, createErrorMessage, createWarningMessage, createInfoMessage
  • log, alert, createErrMessage, createWarningMessage, createInfoMessage
  • log, alert, createErrorMsg, createWarningMsg, createInfoMsg

Question 108

Question
Plug-ins that are included in SAP BusinessObjects Analysis, edition for Microsoft Office for both Excel and Powerpoint
Answer
  • Live Office
  • Analysis
  • EPM
  • Data Manager

Question 109

Question
BOAO is for multidimensional analysis of OLAP sources
Answer
  • True
  • False

Question 110

Question
The edition of SAP BusinessObjects Analysis for OLAP is accessed in [blank_start]BI Launch pad[blank_end]
Answer
  • BI Launch pad
  • Central Management Console
  • Central Configuration Manager

Question 111

Question
In what cases do we use Analysis, edition for MS Office?
Answer
  • 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

Question 112

Question
Three user profiles in SAP BOAO
Answer
  • Workbook Creator
  • Data Analyst
  • Administrator
  • Data Modeling Analyst
  • Architecture
  • SAP BW Consultant

Question 113

Question
What do you call on a new inserted sheet in Analysis?
Answer
  • Neutral
  • Analysis Sheet
  • Workbook sheet
  • Sheet

Question 114

Question
For Microsoft Powerpoint, you can add data sources with Analysis plug-in only
Answer
  • True
  • False

Question 115

Question
Info fields are available in BOAO both excel and ppt
Answer
  • True
  • False

Question 116

Question
We can access Analysis in MS Excel through
Answer
  • 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

Question 117

Question
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?
Answer
  • Analysis Design Panel/Design Panel
  • Information Panel
  • Analysis Panel
  • Components Panel

Question 118

Question
What happens when working with the Design panel?
Answer
  • 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

Question 119

Question
This is where we view the available fields for a single data source and the fields currently used in a crosstab
Answer
  • Analysis tab
  • Components tab
  • Analysis Design tab
  • Information tab

Question 120

Question
This is where we find the information about a data source or the entire workbook and used filters and variables.
Answer
  • Information tab
  • Analysis Design tab
  • Analysis tab
  • Info Fields

Question 121

Question
We cannot display information of a data source and entire workbook through drag and drop of information fields in the information tab
Answer
  • True
  • False

Question 122

Question
When using components tab for setting preferences, which is the highest node for the available components?
Answer
  • Workbook Settings
  • Data Source Settings
  • Crosstab Settings
  • Default Settings

Question 123

Question
Which of the following are the three tabs in the design panel?
Answer
  • Analysis
  • Components
  • Information
  • Worksheet

Question 124

Question
If HANA is implemented, what are the two additional data sources for Analysis?
Answer
  • local providers
  • composite providers
  • Remote Providers
  • Virtual Providers

Question 125

Question
If Analysis tab does not appear, the Analysis Add-in can be manually enabled.
Answer
  • True
  • False

Question 126

Question
Which of the following is true about break hierarchies?
Answer
  • 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

Question 127

Question
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
Answer
  • True
  • False

Question 128

Question
Dimensional Hierarchies that are created or imported in SAP BW are called Characteristic Hierarchies
Answer
  • True
  • False

Question 129

Question
Display hierarchies and dimensional hierarchies cannot be used in parallel
Answer
  • True
  • False

Question 130

Question
When using multiple queries in a workbook, you can open the prompt dialog by Data Source or by Query
Answer
  • True
  • False

Question 131

Question
Which of the following are performed for general settings in the Conditional Formatting dialog?
Answer
  • Choose the format option
  • Assign a name to the specific conditional formatting
  • Choose the measure for the conditional formatting
  • Format the filter components

Question 132

Question
It is not possible to restrict conditional formatting to specific area or member selection
Answer
  • True
  • False

Question 133

Question
You can delete all user-defined style sets and all that are installed with the Add-in.
Answer
  • True
  • False

Question 134

Question
Since styles are workbook-specific, you cannot import or export them
Answer
  • True
  • False

Question 135

Question
Which of the following can be used to supplement a crosstab?
Answer
  • Info Fields
  • Dynamic Charts
  • Filter Components
  • Dimensional Hierarchies

Question 136

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

Question 137

Question
Filter Functions can be used for which of the following?
Answer
  • Display Dynamic Filters
  • Display Static Filters
  • Display Effective Filters
  • Display User Filters

Question 138

Question
You can access User, Advanced, Platform, and Support settings via File → Analysis → Settings
Answer
  • True
  • False

Question 139

Question
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
Answer
  • True
  • False

Question 140

Question
You cannot use VBA to read values from cells in worksheets
Answer
  • True
  • False

Question 141

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

Question 142

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

Question 143

Question
Columns and Rows in BOAO contain either measures or dimensions
Answer
  • True
  • False

Question 144

Question
BOAO must be installed on local machine. What are the available platforms and data sources?
Answer
  • SAP BW system
  • SAP BusinessObjects Business Intelligence Platform
  • SAP HANA
  • SYBASE

Question 145

Question
For the installation of Analysis, what components should be installed first?
Answer
  • 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

Question 146

Question
Which applications can be used for accessing Analysis views?
Answer
  • Crystal Reports for Enterprise
  • WEBi
  • BOAO
  • BOAO for OLAP
  • Design Studio
  • Crystal Reports 2016

Question 147

Question
How can you access the Analysis client for Excel?
Answer
  • 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

Question 148

Question
How do you manually enable and disable Analysis Client?
Answer
  • 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

Question 149

Question
What are the main data sources for Analysis?
Answer
  • BW Queries
  • InfoProviders
  • HANA views
  • Query views
  • Universe
  • Relational connection

Question 150

Question
These are pre-analyzed data that implement business logic
Answer
  • HANA views
  • Query views
  • Analysis views

Question 151

Question
An area in which new models can be created based on a central data provider (e.g. Multiprovider) from BW and local data
Answer
  • BW Workplace
  • BW Workspace
  • BW Modeler
  • BW Workbench

Question 152

Question
These are tables in HANA that can be created from a flat file which can be added to a workbook as a data source
Answer
  • Local Provider
  • Composite Provider
  • Virtual Provider
  • Hybrid Provider

Question 153

Question
Combination of all the data that you want to view in your query
Answer
  • Local Providers
  • Local Composite Provider
  • Virtual Provider
  • Hybrid Provider

Question 154

Question
This can be used to view data in Analytic and other views for complex scenarios
Answer
  • A calculation view
  • A formula view
  • A conditional view

Question 155

Question
a data tables made up of row and column axis (report axis)
Answer
  • Analysis crosstab
  • Table
  • Data Table
  • Query Table

Question 156

Question
In Default view in Crosstab, the Default view of all BW sources should be
Answer
  • as in BEx
  • as defined by Query View
  • measures in the columns, aggregated over all dimensions
  • BEx Query Designer

Question 157

Question
Refreshing the data source will update your analysis with the changes
Answer
  • True
  • False

Question 158

Question
You can build an entire report by using Analysis tab
Answer
  • True
  • False

Question 159

Question
Areas in Analysis Tab
Answer
  • Explorer area
  • Field Explorer area
  • Rows/Columns area
  • Background filter
  • Filter member area

Question 160

Question
Configure Display for Members in BOAO
Answer
  • 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)

Question 161

Question
Comments in BOAO will be deleted when we changed the view on your data
Answer
  • True
  • False

Question 162

Question
In jumping to all targets using RRI, what would you use?
Answer
  • Goto
  • GotoAll
  • Gotoin

Question 163

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

Question 164

Question
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
Answer
  • True
  • False

Question 165

Question
Ways on how to Filter by Member
Answer
  • Sort icon
  • Filter icon
  • Via context menu
  • Dragging elements to background filter

Question 166

Question
What are the filter options in the Filter icon?
Answer
  • Filter by Members
  • Filter by Measure
  • Select All Members
  • Supress Zeros on Rows and on Columns
  • Filter other members

Question 167

Question
Filter by Member is the only method in Analysis for Powerpoint
Answer
  • True
  • False

Question 168

Question
You can filter on hierarchy nodes. In filtering hierarchy nodes, You cannot display leaves only but you can display the entire Hierarchy
Answer
  • True
  • False

Question 169

Question
Which of the following are the Access Mode in Filter by member?
Answer
  • Read mode
  • Posted Values in the InfoProvider
  • Posted data in the current navigational state
  • Filter on Values in Master Data
  • Update mode
  • Write mode

Question 170

Question
Types of selection in filtering
Answer
  • Measure
  • Member
  • Individual
  • Range

Question 171

Question
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
Answer
  • True
  • False

Question 172

Question
With filter by Measure, we can restrict all dimensions to top N independently
Answer
  • True
  • False

Question 173

Question
How would you exclude members that are not displayed in your analysis in totaling?
Answer
  • Totals → Calculate Total As → Only displayed values
  • Totals → Only displayed values
  • Totals → Calculate Total As → Sum
  • Totals → Calculate Total As → Sum of Displayed values

Question 174

Question
Which of the following are true about working with BEx conditions in Analysis?
Answer
  • 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

Question 175

Question
How would you activate and deactivate conditions as BEx Conditions in Analysis?
Answer
  • Filter icon → BEx Conditions
  • Filter icon → Filter by measure
  • Filter icon → Filter by member

Question 176

Question
Your customer wants to create new measures in your analysis without changing the query definition
Answer
  • 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

Question 177

Question
With Dynamic Calculation, we use two or more available measures
Answer
  • True
  • False

Question 178

Question
Where can you specify whether all time-dependent hierarchies for a dimension should be available or only the hierarchy for a selected date?
Answer
  • In settings, select Advanced Settings
  • In Analysis ribbon, select Hierarchy
  • In Design panel, select Hierarchy

Question 179

Question
How to expand node to Level
Answer
  • 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

Question 180

Question
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
Answer
  • True
  • False

Question 181

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

Question 182

Question
What do you call this option in which you can display multiple dimensions hierarchically without using dimensional hierarchy?
Answer
  • Filter
  • Sorting
  • Compact display in rows or columns
  • Runtime/Display Hierarchy

Question 183

Question
What should be set in order for a variable to be editable in the prompting dialog?
Answer
  • 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

Question 184

Question
Saved variable values in a workbook
Answer
  • Variant
  • Parameter
  • Variable values
  • Prompt values

Question 185

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

Question 186

Question
When you have multiple queries in a workbook, what options are available to open the prompt dialog?
Answer
  • 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

Question 187

Question
We can define variant for a query or for a document (workbook or presentation) and for a user-specific or global variant.
Answer
  • True
  • False

Question 188

Question
We can create multiple variants and multiple active variants.
Answer
  • True
  • False

Question 189

Question
Working with document variant is document mode. What is working with query variant?
Answer
  • data source mode
  • query mode
  • query source mode
  • query view

Question 190

Question
On what tab in Design panel would you see the Merge Variables?
Answer
  • Design tab
  • Analysis tab
  • Information tab
  • Components tab

Question 191

Question
What authorization object must be maintained in the Netweaver server so that the user can create variant?
Answer
  • S_RS_PARAM
  • R_SR_PARAM
  • S_SR_PARAM
  • S_RS_COMP

Question 192

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

Question 193

Question
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
Answer
  • True
  • False

Question 194

Question
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.
Answer
  • True
  • False

Question 195

Question
To configure workbook properties, be sure to select the crosstab or the name of the data source on the Components tab
Answer
  • True
  • False

Question 196

Question
Which of the following options can be selected for workbook properties on the Components tab?
Answer
  • 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

Question 197

Question
You can use the logic AND and OR in conditional formatting
Answer
  • True
  • False

Question 198

Question
In Conditional Formatting, how can you shift the visualization to a different measure than the one the rules have been defined on?
Answer
  • 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

Question 199

Question
How do you apply conditional Formatting?
Answer
  • 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

Question 200

Question
New rows/columns cannot be inserted next to a data cell
Answer
  • True
  • False
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Epithelial tissue
Morgan Morgan
Data Structures & Algorithms
Reuben Caruana
Geography Unit 1, World at Risk Compulsory Case Study 3 - Impact of climate change on the Arctic region
Holly Lovering
BYU English 11 B Speedback
Becky Kopplin
Connected Educators
Remind
Religious Studies- Matters of life and death
Emma Samieh-Tucker
Biology B1.3
raffia.khalid99
GCSE - AQA: C1.1 The Fundamental Ideas in Chemistry
Olly Okeniyi
The Circulatory System
mimtasin afra
NCEA Guide to Studying
Kerrin _
English Language Techniques 2
Adam Arrell
Browse Library