SAP Certified Application Associate - Business Intelligence with SAP BW BI

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

Write your full Name ? *

Whats your Mobile Number ? *

QUESTION NO: 1 What is a capability in SAP BusinessObjects Analysis, edition for Microsoft Office, PowerPoint? *

1 point

A. You can use the same filter options as in Analysis for Excel.

B. You can split long tables across multiple slides.

C. You can provide a design panel for conditional formatting.

D. You can perform calculations and axes swapping.

QUESTION NO: 2 For which purposes can you use the tabs in the Design panel of SAP BusinessObjects Analysis,edition for Microsoft Office? (Choose two) *

1 point

A. The Components tab, to retrieve information such as filters assigned to single components

B. The Components tab, to add components such as charts or dropdown boxes to the workbook

C. The Information tab, to add text information to the workbook by using drag and drop

D. The Information tab, to display the structure of used elements

E. The Analysis tab, to define the data that is displayed in the crosstab

QUESTION NO: 3 Which hierarchies are available when you use a BEx Query in SAP BusinessObjects Analysis,edition for Microsoft Office? *

1 point

A. All hierarchies of the characteristics that you use in the query

B. The hierarchies that you activated in the query for the characteristics

C. All hierarchies of the InfoProvider that you use in the query

D. The hierarchies that you selected when inserting the query into Analysis

QUESTION NO: 4 Where can you save workbooks created with SAP BusinessObjects Analysis, edition for MicrosoftOffice? (Choose two) *

1 point

A. In an Analysis iView in the Enterprise Portal

B. On your local PC

C. On the BI platform

D. On the BW server

QUESTION NO: 5 Which of the following functions is included in SAP BusinessObjects Analysis, edition for MicrosoftOffice? *

1 point

A. Migrate a BEx Analyzer Workbook.

B. Create a Report-Report-Interface.

C. Define a filter by measure.

D. Save a variant to the BW server.

QUESTION NO: 6 Which of the following statements regarding refreshing mode in BEx Analyzer is correct? *

1 point

A. The "pause automatic refresh" option should only be used when you perform ad hoc analysis directly against an InfoProvider.

B. The "pause automatic refresh" option is the best practice option. You only use the "automatic refresh" option for special scenarios to optimize the use of the OLAP processor.

C. The "automatic refresh" option is the best practice option. You only use the "pause automatic refresh" if you want to define more than one filter and send them all to the OLAP processor.

D. The "pause automatic refresh" option prevents automatic data refreshes when you report against VirtualProviders with real-time data access.

QUESTION NO: 7 What can you define when using the formula mode in BEx Analyzer? *

1 point

A. Excel formulas to read data out of a data source defined in your workbook

B. Excel formulas to change the filter settings directly in the BEx Query definition

C. Excel formulas to change the navigation state of a data source defined in your workbook

D. Excel formulas to read data directly out of a PSA table

QUESTION NO: 8 You create a workbook with exceptions in BEx Analyzer. Your customer does not like the standardcolors for Bad 1 and Good 2 exceptions.What do you use to change the color settings in BEx Analyzer? *

1 point

A. The theme

B. The portal theme

C. The XML file

D. The CSS file

QUESTION NO: 9 What is the purpose of design mode in BEx Analyzer? *

1 point

A. To change the query design

B. To design query views

C. To design and embed charts in the workbook

D. To define the layout of the workbook using design items

QUESTION NO: 10 You want to create a query in BEx Query Designer that produces a table as shown in the attachedscreenshot. *

1 point

A. Filters

B. Structures

C. Exceptions

D. Restricted key figures

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms