SAP BPC E-Learning_2

Which for the following terms was previously know as Datasource Dimension Type. Audit trail dimension type. Group dimension type. Scope dimension type. Data access profile.

Which the following tab pages ara available in the Excel interface of de enterprise performance management add-in? Choose 2 answers. Data Manager. EPM. Data. Environment.

A single environment reduces maintenance, improves data integrity and simplify deployment. This feature is one of the main benefits of ussing the planning and consolidation application. true. false.

You can use EPM add-in to simultaneously read data from both planning and consolidation models and SAP BW Infoproviders. True. False.

With the View Formats option, which of the following tasks can you perform?. Edit formatting defined for the report. Open or close the EPM formatting sheet. Delete the formatting sheet. Save the formatting sheet.

Wich of the following actions can be undone using the Back function? Choose 3 correct answer. Expand. Row and column axes switch. EPM pane changes. Save Data.

which of the following options are included in the EPM Context? Choose 2 correct answer. The dimensions included in the current InfoCube or model. The selected dimension member. Row and column axes details. the current model.

InWhich of the folllowing ways can you create a new report in the SAP Business Planning and Consolidation 10.0, Add-in for Microsoft Office (the EPM add-in) Choose 3 corrects answers. Using EPM Report Editor. Using EPM Pane. Using copy and paste. Using EPM Sheet Options.

In which of the following stages of the project do you configuere the initial solution?. Realization. Project preparation. Business Blueprint. Go live and support.

Whichof the following development guideline is used to extract o retract master or transaction data from source to target system whith required data transformation?. Global and/or local data. Master data. Data flow. Data model integration.

Which of the following options can you use to create reports? Choose 5 correct answers. Use the Enterprise Performance Management (EPM) report editor. Enter members directly in a sheet. Use the Enterprise Performance Management (EPM). Create reports using copy and paste. Use drag and drop. Use EVDRE Builder. Create reports using move.

Which of the following are the features of the report editor Layout tab page? Choose 5 correct answers. Create a report on a blank worksheet. Create a report on a worksheet that already contains a report. Arrange the layout of the report. Access the member selector. Define the position of the report. Define the option of inheriting from sheet options. Define a link for the report.

Which of the following are the data analysis options?. Expand. Collapse. Remove. Hide. Keep. Exclude.

What is the function of the Retain Members option?. Retains only the members who meet the filter criteria. Retains only the members who do not meet the filter criteria. Retains the specified member wherher it meets the criteria or not.

Which of the following data is used to sort the data in a report?. The first data column. The last data column. The second last Data column. The first and last data row.

Whic of the following are the options to prevent data entry when you need to provide a workbook-specific solution?. Data access profiles. Work status. Read-only data setting. Formatting.

Which of the following are the valid ways to create local members? Choose 2 answers. Enter an Excel formula in the report. Create a local member in the Excel report editor. Create in the admin interface. Create in the web interface.

Which of the following relationships are included to define the levels of a hierarchy? Choose 3 corrects answers. Ascendants. Descendants. Base level. Base members. Self.

What is the purpose of Member Recognition?. Identifies the typed dimension member value available in system. Displays the properties of the member typed.

To which of the following types of link options can the user define by using quick links? Choose 3 corrects answers. Data. Web Page. Member. Report.

Which of the following actions can you perfom in the Hierarchy Level Formatting section? Choose 3 corrects answers. Format the levels of hierarchies. Add or delete leves. Add member or property. Choose an inner or outer dimension for nested dimensions.

Which of the following fields allow formatting? Choose 3 corrects answers. Custom members. Calculated members. Specific members. Nonspecific members.

Which of the following are features of the Row and Column Banding formatting section? Choose 3 correct answers. Applies the defined format to data or headers. Allows you to choose one or two alternating formats. Applies the defined format to rows or columns. Allows to apply format to a continuous number of rows or columns.

Which of the following statements are true for the features of report or workbook-specific formatting? Choose 2 corrects answers. You can have multiple formatting sheets in your workbook. Each report or input schedule sheet can point to a different formatting sheet. You can have only one formatting sheet per workbook. Each report can point to as many formatting sheets as required.

Which the following links can you choose in the EPM pane to add new connections?. Select another connection. Select active connection. Select provider connection. Select planning and consolidation connection.

Which of the following features help you to display several reports on the same spreadsheet? Choose 2 correct answers. Axis sharing. Worsheet generation. Multi-source reporting. not possible to have multiple reports in a single spreadsheet.

Which of the following EPM functions launches the specified web client component?. EPMURL. EMPBook. EPMLink.

which of the following functions are used to retrieve the list of properties of any dimension?. EPMContextMember. EPMDimensionProperty. EPMMemberProperty. EPMMemberOffset. EPMDimensionList.

Which of the following classes expose all the macros that you execute directly from a worksheet cell?. EPMAddinAutomationAPI class. IEPMExecuteAPI class.

The delivered templates only includes data retrieval reports. True. False.

Workbook options determine how EVDRE sends data. If the workbook option Type is set to __________, you cannot send data. report. input schedule. static. dynamic.

Which of the following actions are performed when you migrate an EVDRE template?. Row and column expansions are not migrated. Empty rows and columns are not migrated. Visual Basic for Applications is migrated. A Log is generated. Protected workbooks or sheets are not migrated.

Where can you find the original template after a migration process if you do not enable the Do not move original workbooks in a different folder option?. Same location whith same name. Same location with different same name. In migration copy folder with same name. In migration copy folder with different name.

Which of the following EXPANDIN parameters are migrated?. COL. ROW. SHEET.

What do cells in magenta after migration indicate?. Unrecognized members. EPM functions.

Which of the following distribution template options defines the number of templates to be generated?. Number of Section. Number of Fixed Members. Number of Variable Members. Number of Dimensions.

WWhich of the following distribution template options defines the number of templates to be generated?. Number of Section. Number of Fixed Members. Number of Variable Members. Number of dimensions.

Which of the following security features allows you to execute the distrution wizard?. Edit Book and Distribution Templates. Use Offline Distribution. Use offline Collection.

In which of the following ways can you add comments in SAP Business Planning and Consolidation?. Using the EPMSaveComment function. Using the Add Comment pushbutton from EPM tab page. Using Excel Popup.

Which of the following are the comment functions in the Excel inteface of the Enterprise Performance Management add-in? Choose 3 corrects answers. EPMSaveComment. EPMCommentPartialContext. EPMCommentFullContext. EPMDeleteComment.

Which of following options can you use to write comments to the database?. Add comments through the EPM add-in ribbon. Choose Save Data through the EPM add-in-ribbon with the EPMSaveComment function. Run the SaveComment data manager package. Use the Web Client audit option to insert comments.

Which of the following is an optional field in the spread function?. Source Value. Destination. Weights. Spread Results.

Which of the following are the benefits of Business Process Flows?. Guided navigation. Detailed reports. Design and configuration. Coordination. Help desk support. Built-in monitor.

Who among the following can finalize the process instance?. Reviewer of the activity. Owner of the activity. Reviewer of the process. Owner of the process.

Which of the following is the correct sequence for creating a business process flow and working on it?. Define the workspace, check process monitor, design the process template, create process instance. Define the workspace, design the process template, create process instance, check process monitor. Design the process template, define the workspace, create process instance, check process monitor. Design the process template, create process instance, define the workspace, check process monitor.

What is the function of opening criteria?. Control the opening of a business process flow. Control the opening of activities in a business process flow. Control the opening of both a business process flow and activity.

Which of the following are screens within consolidation Central?. Consolidation Monitor. Controls Monitor. Journals. Audit. Ownership Manager.

The administration interface in the SAP Business Planning and Consolidation application is accessed through which of the following?. Excel client. Web client. Admin client. SAP GUI.

Which of the following can you use to access the web reports, if the report has been created as a favorite?. Through the Library view. Through the activities. Trough the Process Monitor. Through the Start Page.

which of the following option starts the book publication wizard?. Publish Books. Open Template. Save As. Validate. Change Connection.

Which of the following options enables you to define the printing order?. Print one sheet for all dimensions member combinations. Pront sheets with no data. Options available in the Excel workbook. Property in the report.

which of the following are valid drill through task profiles? choose 3 correct answers. Manage drill throughs. View drill throughs. Run drill throughs. Create drill throughs.

In a scenario without a master data conversion, the mapping in a dimension table is necessary. True. False.

Which of the following options is used to define formatting in the EPM add-in for Powerpoint?. Sheet Options. Document Options. Presentation Options. User Options.

Which of the following feature allows you interact whit SAP Business Planning and Consolidation while viewing a dashboard?. EPM Connector. EPM- Report Editor. EPM Add-in.

On which tab page can you create design time connections and build reports?. EPM. Live Office. Data Manager. View.