Questão 1
Questão
Who are the target users for BOAO, MS Powerpoint?
Responda
-
Business Users
-
Data Analyst
-
SAP BW Consultants
Questão 2
Questão
Use Cases for Analysis for Powerpoint
Questão 3
Questão
Analysis for Powerpoint have the same functionality as Analysis for Excel
Questão 4
Questão
Analysis Powerpoint does not have a Design Panel
Questão 5
Questão
Available features in Analysis for Powerpoint ribbon
Responda
-
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
Questão 6
Questão
Which Settings are available in Analysis for Powerpoint?
Responda
-
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)
Questão 7
Questão
Available Properties to configure for the entire presentation
Responda
-
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
Questão 8
Questão
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
Questão 9
Questão
What are the options available in using Fit Table feature?
Responda
-
Split Table
-
Fit Table
-
Abbreviate Table
-
Hide Table
Questão 10
Questão
What is the maximum number of rows per slide in Analysis for Powerpoint?
Questão 11
Questão
If the number of total rows has changed, slides are created and/or deleted based on the changes when it is data refreshed.
Questão 12
Questão
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.
Responda
-
Fit Table
-
Split Table
-
Abbreviate Table
Questão 13
Questão
In Abbreviating table, Sorting will not affect the display of data
Questão 14
Questão
If you turn a split table into an abbreviation table, one or more slides are added.
Questão 15
Questão
You have the option to delete existing slides via Fit Table Dialog
Questão 16
Questão
If a table is split across multiple slides and one or more slides is manually deleted, the lost slides are replaced on refresh.
Questão 17
Questão
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
Questão 18
Questão
What are the following available options for info field in Analysis for Powerpoint?
Responda
-
Presentation name
-
Key date
-
Data Source name
-
Last Data update
-
Effective Filters
-
Variables
Questão 19
Questão
Which of the following are true statements about Info field in Analysis for Powerpoint?
Responda
-
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
Questão 20
Questão
Available Platforms in Saving Platforms
Responda
-
SAP BI Platform
-
SAP Netweaver Platform
-
SAP Lumira Cloud
-
SAP BW Server
Questão 21
Questão
When you have a data source with numerous rows you can use the Fit Table feature to break the result into multiple slides
Questão 22
Questão
If a table is split across multiple slides and one or more of the slides is manually deleted, the lost slides cannot be recovered.
Questão 23
Questão
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
Questão 24
Questão
Which of the following are the true statements about Design Studio?
Responda
-
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
Questão 25
Questão
Deployment Options for Design Studio Applications
Responda
-
BI Platform
-
SAP Netweaver
-
HANA Native
-
Universe
Questão 26
Questão
Which of the following are true about Deploying Design Studio Application on BI Platform?
Responda
-
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
Questão 27
Questão
Which of the following are true statements about Deploment Options for SAP Netweaver?
Responda
-
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
Questão 28
Questão
Which of the following are true about Deploying Design Studio Application on HANA Native?
Responda
-
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
Questão 29
Questão
Which of the following are true statements about the Local Mode in Design Studio?
Responda
-
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
Questão 30
Questão
Which of the following Platform strategy is recommended by SAP?
Responda
-
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
Questão 31
Questão
How would you change the the startup mode from a Local mode to BI Platform?
Responda
-
Choose tools → Preferences → Select SAP BusinessObjects BI Platform
-
Choose Settings→ Preferences → Select SAP BusinessObjects BI Platform
-
Choose Application→ Preferences → Select SAP BusinessObjects BI Platform
Questão 32
Questão
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.
Questão 33
Questão
Which of the following can you do on the Welcome page of Design Studio?
Responda
-
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
Questão 34
Questão
You can create a new Design Studio Application via
Responda
-
Application menu
-
Toolbar
-
Layout
-
Edit
-
View
Questão 35
Questão
Storage location of Design Studio Application deployed on BI Platform
Questão 36
Questão
How to use the "New Application" Dialog
Responda
-
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
Questão 37
Questão
Which of the following are main screen elements of Design Studio?
Responda
-
Components
-
Analysis
-
Information
-
Layout
-
Outline
-
Properties
Questão 38
Questão
Which of the following are the possible additional views on Design Studio?
Responda
-
Additional Properties
-
Properties
-
Script problems
-
Script Editor
-
Search Results
-
ERROR Log
-
Conversion Log
Questão 39
Questão
Design Studio Sources for a Data Source Object
Responda
-
SAP BW (Query, Query view, InfoProvider)
-
SAP HANA (Analytic View, Calculation View)
-
CSV
-
Universe (Relational and OLAP)
-
Universe (Relational)
-
SAP BW (Query, Query view)
Questão 40
Questão
Restrictions for Universes as Data Source of a Design Studio Application
Responda
-
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
Questão 41
Questão
Ways on how to create a new Data Source
Responda
-
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
Questão 42
Questão
Which of the following allows you to modify initial state of any data source?
Questão 43
Questão
Which of the following are the options to add components to an Application?
Responda
-
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
Questão 44
Questão
Which of the following are not true about Layout Properties and Docking behavior in Design Studio?
Responda
-
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
Questão 45
Questão
Which of the following are true about Aligning and Distributing components in layout?
Responda
-
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
Questão 46
Questão
Ways on how to assign Data source to a component
Responda
-
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
Questão 47
Questão
Basic Components includes
Questão 48
Questão
Analytic Components includes
Responda
-
Dimension Filter
-
Filter Panel
-
Spreadsheet
-
Scorecard
-
Filter Line
-
Chart Type Picker
-
Tabstrip
-
Info field
-
Crosstab
-
Geo Map
Questão 49
Questão
Container Components include
Responda
-
Grid Layout
-
Page number
-
Pagebook
-
Panel
-
Navigation Panel
-
Popup
-
Split Cell Container
-
Tabstrip
-
Merge Cell Container
Questão 50
Questão
This type of component is used to optimize an application for a mobile device and enable specific motion gestures in mobile applications
Responda
-
Components
-
Container
-
Basic
-
Analytic
Questão 51
Questão
This type of component is used to enable navigation and user interaction at runtime, enhance the design and layout of the application
Responda
-
Components
-
Container
-
Basic
-
Analytic
Questão 52
Questão
The [blank_start]Crosstab[blank_end] displays multi-dimensional data in a grid with analytic functions.
Responda
-
Crosstab
-
Tablestrip
-
Geo map
Questão 53
Questão
Which of the following is not true about Crosstab component in Design studio?
Responda
-
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
Questão 54
Questão
Feeding Panel is not compatible with Charts, only with Info Charts.
Questão 55
Questão
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.
Questão 56
Questão
Which of the following can you do with the Navigational Panel?
Responda
-
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
Questão 57
Questão
The order of dimensions in a Navigational Panel can be determined in runtime
Questão 58
Questão
Drag and Drop from Navigational Panel to Crosstab is a default setting in Application property
Questão 59
Questão
The Filter Panel component can be used for [blank_start]Filtering and Navigation[blank_end]
Questão 60
Questão
Which of the following are true about Filter Line component
Responda
-
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
Questão 61
Questão
Which of the following is true about Dimension Filter?
Responda
-
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
Questão 62
Questão
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"
Responda
-
as mandatory
-
as optional
-
as variable
-
as mandatory variable
Questão 63
Questão
Grid layout is used to group and order the content of an application and is displayed at runtime
Questão 64
Questão
The [blank_start]Pagebook[blank_end] component enables the user to switch between different views of an application.
Responda
-
Pagebook
-
Tabstrip
-
Panel
-
Popup
-
Image
-
Text
Questão 65
Questão
Pages are shown in the outline view
Questão 66
Questão
If you use Pagebook component in the layout editor, the system automatically creates one page for the Pagebook.
Questão 67
Questão
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]
Responda
-
click Create Child → Page
-
click Pagebook → Choose Page
-
click Create Pagebook → Page
-
click Create Child → Page N
Questão 68
Questão
Pagebook component are compatible with any browser types/versions and capable to display the transition effects correctly.
Questão 69
Questão
[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.
Responda
-
Tabstrip component
-
Pagebook component
-
Filter Line component
-
Filter Panel component
-
Navigational Panel
Questão 70
Questão
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
Questão 71
Questão
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.
Questão 72
Questão
[blank_start]Panel component[blank_end] is used to group other components in your application. This is a very simple container component.
Responda
-
Panel component
-
Pagebook component
-
Tabstrip component
-
Popup component
Questão 73
Questão
The components nested in the Panel are positioned [blank_start]relative[blank_end] to the Panel and not to the Application border.
Responda
-
relative
-
linear
-
beside
-
10 pixels to the left
Questão 74
Questão
[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.
Responda
-
Popup component
-
Panel component
-
Pagebook component
-
Tabstrip component
-
Navigational component
Questão 75
Questão
You can only put texts component into a popup
Questão 76
Questão
Which of the following are the restrictions of using Popup component?
Responda
-
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
Questão 77
Questão
Popup component is set to visible by default
Questão 78
Questão
Working with Design Studio Applications provides Multi language support
Questão 79
Questão
[blank_start]Text pool[blank_end] to add translations centrally
Responda
-
Text pool
-
Translation component
-
Translation pool
-
Text Translation
Questão 80
Questão
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
Responda
-
Formatted Text View
-
Text Component
-
Text pool
Questão 81
Questão
This component is used to enable the user to apply text formatting within one control.
Responda
-
Formatted Text View
-
Formatted Text Pool
-
Text pool
-
Text Component
Questão 82
Questão
Which of the following is true about Data Bound Component Properties
Responda
-
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)
Questão 83
Questão
How would you bind a text component to a cell value?
Responda
-
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
Questão 84
Questão
How would you bind Listbox and Define Filtering?
Responda
-
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
Questão 85
Questão
Scorecard is recommended to be used with dynamic data sources and data sources with free multidimensional navigation (slice and dice)
Questão 86
Questão
The [blank_start]Scorecard Component[blank_end] is designed for use in dashboards and reports with controlled visualization content and restricted navigation possibilities.
Responda
-
Scorecard Component
-
Scoreboard Component
-
Info Chart Component
-
Info field Component
Questão 87
Questão
Auto Generation of Scorecard analyzes fully any specialties of the data source.
Questão 88
Questão
Steps to create a Scoreboard
Responda
-
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
Questão 89
Questão
The [blank_start]Row Scope property[blank_end] define how many or how detailed your data is presented in the Scorecard
Questão 90
Questão
Interoperability between Analysis Office and Design studio
Questão 91
Questão
Which of the following are true statements about Smart Copy ?
Responda
-
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
Questão 92
Questão
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]
Responda
-
Settings → Advanced Settings
-
Options → Advanced Settings
-
Settings → Platform Settings
-
Settings → User Settings
Questão 93
Questão
Which of the following Analysis components can be transferred to Design studio?
Responda
-
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
Questão 94
Questão
You can used Create Web Application even when the Design Studio is open
Questão 95
Questão
Script to manually add Export to Lumira option to any application: DS_1.export([blank_start]DataSourceExportType.LUMIRA_lums[blank_end]);
Responda
-
DataSourceExportType.LUMIRA_lums
-
ExportType.LUMIRA_lums
-
DataSourceExportType.LUMIRA
-
DataFileExportType.LUMIRA_lums
Questão 96
Questão
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.
Questão 97
Questão
Which features are available in Ready to Run: Online Composition?
Responda
-
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
Questão 98
Questão
Which features are available in Ready to Run: Data Exploration & Visualization App?
Responda
-
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
Questão 99
Questão
Define your Template Folders: [blank_start]Tools → Preferences → Application Design[blank_end] → Application Templates
Responda
-
Tools → Preferences → Application Design
-
Tools → Settings → Application Design
-
Tools → Preferences → Application
-
Tools → Preferences → Design
Questão 100
Questão
Export the Application you want to use as new Template: [blank_start]Application → Export as Template[blank_end]
Responda
-
Application → Export as Template
-
Design Application → Export as Template
-
Application → Export
-
Design Application → Template
Questão 101
Questão
Which CSS attributes are supported for both desktop browser and iPad/iPhone application?
Questão 102
Questão
The scripts are executed on the [blank_start]Analysis Application Design Service[blank_end] (unlike JavaScript that is executed in the Web browser)
Responda
-
Analysis Application Design Service
-
Analysis Application Designer Service
-
Analytic Application Design Service
-
Analytic Application Designer Service
Questão 103
Questão
Script Statement Types
Questão 104
Questão
Call statement Sytanx : [blank_start]<Component>.<Method>(<Arguments>);[blank_end]
Responda
-
<Component>.<Method>(<Arguments>);
-
IF xxx THEN xxx ELSE
-
VAR <VARIABLE> = <EXPRESSION>
-
<VARIABLE> = <EXPRESSION>
Questão 105
Questão
It offers content assistance.
Responda
-
CTRL + ENTER
-
CTRL + SPACE
-
CTRL + SHIFT + SPACE
-
CTRL + ?
Questão 106
Questão
BI Types: Design studio needs to know what type a parameter has. Which of the following is not included in BI Types?
Responda
-
Dimension
-
Member
-
Filter
-
MemberPresentation
-
ChartType
-
None of the above
Questão 107
Questão
Application methods to analyze the general behavior of your Design Studio application
Responda
-
log, alert, createErrorMessage, createWarningMessage, createInfoMessage
-
log, alert, createErrMessage, createWarningMessage, createInfoMessage
-
log, alert, createErrorMsg, createWarningMsg, createInfoMsg
Questão 108
Questão
Plug-ins that are included in SAP BusinessObjects Analysis, edition for Microsoft Office for both Excel and Powerpoint
Responda
-
Live Office
-
Analysis
-
EPM
-
Data Manager
Questão 109
Questão
BOAO is for multidimensional analysis of OLAP sources
Questão 110
Questão
The edition of SAP BusinessObjects Analysis for OLAP is accessed in [blank_start]BI Launch pad[blank_end]
Questão 111
Questão
In what cases do we use Analysis, edition for MS Office?
Responda
-
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
Questão 112
Questão
Three user profiles in SAP BOAO
Responda
-
Workbook Creator
-
Data Analyst
-
Administrator
-
Data Modeling Analyst
-
Architecture
-
SAP BW Consultant
Questão 113
Questão
What do you call on a new inserted sheet in Analysis?
Responda
-
Neutral
-
Analysis Sheet
-
Workbook sheet
-
Sheet
Questão 114
Questão
For Microsoft Powerpoint, you can add data sources with Analysis plug-in only
Questão 115
Questão
Info fields are available in BOAO both excel and ppt
Questão 116
Questão
We can access Analysis in MS Excel through
Responda
-
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
Questão 117
Questão
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?
Questão 118
Questão
What happens when working with the Design panel?
Responda
-
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
Questão 119
Questão
This is where we view the available fields for a single data source and the fields currently used in a crosstab
Responda
-
Analysis tab
-
Components tab
-
Analysis Design tab
-
Information tab
Questão 120
Questão
This is where we find the information about a data source or the entire workbook and used filters and variables.
Responda
-
Information tab
-
Analysis Design tab
-
Analysis tab
-
Info Fields
Questão 121
Questão
We cannot display information of a data source and entire workbook through drag and drop of information fields in the information tab
Questão 122
Questão
When using components tab for setting preferences, which is the highest node for the available components?
Responda
-
Workbook Settings
-
Data Source Settings
-
Crosstab Settings
-
Default Settings
Questão 123
Questão
Which of the following are the three tabs in the design panel?
Responda
-
Analysis
-
Components
-
Information
-
Worksheet
Questão 124
Questão
If HANA is implemented, what are the two additional data sources for Analysis?
Responda
-
local providers
-
composite providers
-
Remote Providers
-
Virtual Providers
Questão 125
Questão
If Analysis tab does not appear, the Analysis Add-in can be manually enabled.
Questão 126
Questão
Which of the following is true about break hierarchies?
Responda
-
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
Questão 127
Questão
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
Questão 128
Questão
Dimensional Hierarchies that are created or imported in SAP BW are called Characteristic Hierarchies
Questão 129
Questão
Display hierarchies and dimensional hierarchies cannot be used in parallel
Questão 130
Questão
When using multiple queries in a workbook, you can open the prompt dialog by Data Source or by Query
Questão 131
Questão
Which of the following are performed for general settings in the Conditional Formatting dialog?
Responda
-
Choose the format option
-
Assign a name to the specific conditional formatting
-
Choose the measure for the conditional formatting
-
Format the filter components
Questão 132
Questão
It is not possible to restrict conditional formatting to specific area or member selection
Questão 133
Questão
You can delete all user-defined style sets and all that are installed with the Add-in.
Questão 134
Questão
Since styles are workbook-specific, you cannot import or export them
Questão 135
Questão
Which of the following can be used to supplement a crosstab?
Responda
-
Info Fields
-
Dynamic Charts
-
Filter Components
-
Dimensional Hierarchies
Questão 136
Questão
A waterfall chart can be used to show how an initial value is affected by a series of intermediate positive or negative values
Questão 137
Questão
Filter Functions can be used for which of the following?
Questão 138
Questão
You can access User, Advanced, Platform, and Support settings via File → Analysis → Settings
Questão 139
Questão
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
Questão 140
Questão
You cannot use VBA to read values from cells in worksheets
Questão 141
Questão
When you have a data source with numerous rows you can use Fit Table feature to break the result into multiple slides
Questão 142
Questão
If a table is split across multiple slides and one or more of the details is manually deleted, the lost slides cannot be recovered
Questão 143
Questão
Columns and Rows in BOAO contain either measures or dimensions
Questão 144
Questão
BOAO must be installed on local machine. What are the available platforms and data sources?
Questão 145
Questão
For the installation of Analysis, what components should be installed first?
Responda
-
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
Questão 146
Questão
Which applications can be used for accessing Analysis views?
Questão 147
Questão
How can you access the Analysis client for Excel?
Responda
-
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
Questão 148
Questão
How do you manually enable and disable Analysis Client?
Responda
-
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
Questão 149
Questão
What are the main data sources for Analysis?
Responda
-
BW Queries
-
InfoProviders
-
HANA views
-
Query views
-
Universe
-
Relational connection
Questão 150
Questão
These are pre-analyzed data that implement business logic
Responda
-
HANA views
-
Query views
-
Analysis views
Questão 151
Questão
An area in which new models can be created based on a central data provider (e.g. Multiprovider) from BW and local data
Responda
-
BW Workplace
-
BW Workspace
-
BW Modeler
-
BW Workbench
Questão 152
Questão
These are tables in HANA that can be created from a flat file which can be added to a workbook as a data source
Responda
-
Local Provider
-
Composite Provider
-
Virtual Provider
-
Hybrid Provider
Questão 153
Questão
Combination of all the data that you want to view in your query
Responda
-
Local Providers
-
Local Composite Provider
-
Virtual Provider
-
Hybrid Provider
Questão 154
Questão
This can be used to view data in Analytic and other views for complex scenarios
Responda
-
A calculation view
-
A formula view
-
A conditional view
Questão 155
Questão
a data tables made up of row and column axis (report axis)
Responda
-
Analysis crosstab
-
Table
-
Data Table
-
Query Table
Questão 156
Questão
In Default view in Crosstab, the Default view of all BW sources should be
Questão 157
Questão
Refreshing the data source will update your analysis with the changes
Questão 158
Questão
You can build an entire report by using Analysis tab
Questão 159
Questão
Areas in Analysis Tab
Responda
-
Explorer area
-
Field Explorer area
-
Rows/Columns area
-
Background filter
-
Filter member area
Questão 160
Questão
Configure Display for Members in BOAO
Responda
-
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)
Questão 161
Questão
Comments in BOAO will be deleted when we changed the view on your data
Questão 162
Questão
In jumping to all targets using RRI, what would you use?
Questão 163
Questão
With sorting in BOAO, if you sort values of one measure, the other cells in your crosstab are also affected
Questão 164
Questão
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
Questão 165
Questão
Ways on how to Filter by Member
Questão 166
Questão
What are the filter options in the Filter icon?
Questão 167
Questão
Filter by Member is the only method in Analysis for Powerpoint
Questão 168
Questão
You can filter on hierarchy nodes. In filtering hierarchy nodes, You cannot display leaves only but you can display the entire Hierarchy
Questão 169
Questão
Which of the following are the Access Mode in Filter by member?
Responda
-
Read mode
-
Posted Values in the InfoProvider
-
Posted data in the current navigational state
-
Filter on Values in Master Data
-
Update mode
-
Write mode
Questão 170
Questão
Types of selection in filtering
Responda
-
Measure
-
Member
-
Individual
-
Range
Questão 171
Questão
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
Questão 172
Questão
With filter by Measure, we can restrict all dimensions to top N independently
Questão 173
Questão
How would you exclude members that are not displayed in your analysis in totaling?
Responda
-
Totals → Calculate Total As → Only displayed values
-
Totals → Only displayed values
-
Totals → Calculate Total As → Sum
-
Totals → Calculate Total As → Sum of Displayed values
Questão 174
Questão
Which of the following are true about working with BEx conditions in Analysis?
Responda
-
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
Questão 175
Questão
How would you activate and deactivate conditions as BEx Conditions in Analysis?
Responda
-
Filter icon → BEx Conditions
-
Filter icon → Filter by measure
-
Filter icon → Filter by member
Questão 176
Questão
Your customer wants to create new measures in your analysis without changing the query definition
Responda
-
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
Questão 177
Questão
With Dynamic Calculation, we use two or more available measures
Questão 178
Questão
Where can you specify whether all time-dependent hierarchies for a dimension should be available or only the hierarchy for a selected date?
Responda
-
In settings, select Advanced Settings
-
In Analysis ribbon, select Hierarchy
-
In Design panel, select Hierarchy
Questão 179
Questão
How to expand node to Level
Responda
-
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
Questão 180
Questão
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
Questão 181
Questão
In sorting with hierarchy, the members of the hierarchy are sorted within their groups by default unless you use Break Hierarchies
Questão 182
Questão
What do you call this option in which you can display multiple dimensions hierarchically without using dimensional hierarchy?
Questão 183
Questão
What should be set in order for a variable to be editable in the prompting dialog?
Responda
-
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
Questão 184
Questão
Saved variable values in a workbook
Responda
-
Variant
-
Parameter
-
Variable values
-
Prompt values
Questão 185
Questão
The use of the operators in prompts, such as =, >=, [], *, ![], must be enabled in the registry by your IT administrator
Questão 186
Questão
When you have multiple queries in a workbook, what options are available to open the prompt dialog?
Responda
-
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
Questão 187
Questão
We can define variant for a query or for a document (workbook or presentation) and for a user-specific or global variant.
Questão 188
Questão
We can create multiple variants and multiple active variants.
Questão 189
Questão
Working with document variant is document mode. What is working with query variant?
Responda
-
data source mode
-
query mode
-
query source mode
-
query view
Questão 190
Questão
On what tab in Design panel would you see the Merge Variables?
Responda
-
Design tab
-
Analysis tab
-
Information tab
-
Components tab
Questão 191
Questão
What authorization object must be maintained in the Netweaver server so that the user can create variant?
Responda
-
S_RS_PARAM
-
R_SR_PARAM
-
S_SR_PARAM
-
S_RS_COMP
Questão 192
Questão
In data source mode, the context menu for prompts is only available if workbook property Merge Variables is selected unlike in document mode
Questão 193
Questão
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
Questão 194
Questão
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.
Questão 195
Questão
To configure workbook properties, be sure to select the crosstab or the name of the data source on the Components tab
Questão 196
Questão
Which of the following options can be selected for workbook properties on the Components tab?
Responda
-
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
Questão 197
Questão
You can use the logic AND and OR in conditional formatting
Questão 198
Questão
In Conditional Formatting, how can you shift the visualization to a different measure than the one the rules have been defined on?
Responda
-
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
Questão 199
Questão
How do you apply conditional Formatting?
Responda
-
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
Questão 200
Questão
New rows/columns cannot be inserted next to a data cell