In the Central Management Console (CMC), what does the SAP authentication area allow you to do? (2) Import SAP roles Specify SAP systems Enable SAP BW publisher services. Define custom access rights for SAP users.
You create a dashboard and choose Save to Platform asDashboard Design Object. What does the saved dashboard contain? An object that contains both the design document and the Flash file The design document only An object that contains both the design document and the Excel file The Flash file only.
In BEx Web applications, what is the function of a data provider? To store data for offline scenarios To combine data from different BEx Queries To provide data to Web items To connect to InfoProviders, information spaces, or BEx Query views.
You have created a Web Intelligence document that displays data from the query in a single table. Now you edit the query and add two additional objects.
Where will the new objects appear when you re-run the query?
In the existing table In the Document Summary panel In a new table In the Available Objects panel.
You create a workbook with exceptions in BEx Analyzer. Your customer does not like the standard colors for Bad 1 and Good 2 exceptions.
What do you use to change the color settings in BEx Analyzer?
The theme The portal theme The XML file The CSS file.
Which of the following is a tool for ad hoc analysis and reporting to be used by business users/end users? Dashboard Design Crystal Reports Web Intelligence Web Application Designer.
Which process on the SAP BusinessObjects BI platform governs how content and users are managed and transferred among development, test, and production environments? Master data management Data federation management Lifecycle management MetaData management.
You want to create a calculated key figure at InfoProvider level. Which key figures can you use? All types of key figures defined at query level Only calculated key figures defined at query level All types of key figures defined at InfoProvider level Only calculated key figures defined at InfoProvider level.
You use Crystal Reports for Enterprise. How can you align columns in your report? Use smart guidelines. Use conditional formatting. Use calculations. Use format painter.
What is a capability in SAP BusinessObjects Analysis, edition for Microsoft Office, PowerPoint? You can use the same filter options as in Analysis for Excel. You can split long tables across multiple slides. You can provide a design panel for conditional formatting You can perform calculations and axes swapping.
Which of the following BI clients require a predefined connection in the BI platform to a BEx Query? Analysis, edition for Microsoft Office and Explorer Crystal Reports 2011 and Analysis, edition for OLAP Web Intelligence and Crystal Reports for Enterprise Dashboards and Web Intelligence.
You open the Cost Center dimension in BEx Query Designer. What information about the Cost Center characteristic can you determine? (Choose two) The Cost Center is compounded to the Controlling area. The Cost Center has display attributes. The Cost Center has navigational attributes. The Controlling area is compounded to the Cost Center.
What do you have to consider regarding the data provider definition when you design a new standard Web template? The data provider must be created in the Web template and specified by a URL parameter. The data provider is automatically generated by specifying a query in the URL parameter The data provider must be created in the Web template and specified by a Java script. The data provider must be created in the Web template and changed through a command sequence.
What can you define when using the formula mode in BEx Analyzer? Excel formulas to read data out of a data source defined in your workbook Excel formulas to change the filter settings directly in the BEx Query definition Excel formulas to change the navigation state of a data source defined in your workbook Excel formulas to read data directly out of a PSA table.
Which of the following tasks can you perform from the Data Warehousing Workbench?(Choose two) Create new restricted key figures at InfoProvider level. Create transport packages of BW objects. Create DataStore Objects. Create variables for reporting.
Which of the following InfoProviders store data persistently?(Choose three) InfoCubes InfoSets InfoObjects DataStore Objects MultiProviders.
What is the purpose of a dashboard model created in Dashboard Design? To monitor access to data based on SAP roles To analyze data elements commonly used in many different reports To display thousands of rows of data in a report To display highly aggregated visualizations of current business performance.
Which tool do you use to enable SAP authentication? Information Design Tool (IDT) Central Management Console (CMC) Central Configuration Manager (CCM) LifeCycle Manager (LCM).
Which of the following statements regarding refreshing mode in BEx Analyzer is correct? The "pause automatic refresh" option should only be used when you perform ad hoc analysis directly against an InfoProvider. 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. 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. The "pause automatic refresh" option prevents automatic data refreshes when you report against VirtualProviders with real-time data access.
To which of the following formats can you export a dashboard? (Choose two) HTML Microsoft Word MP4 AVI.
Which type of InfoObjects can you create in BW? (Choose three) Characteristics Units Time characteristics Key figures Technical characteristics.
For which data sources does SAP recommend the use of Crystal Reports for Enterprise? BI4.0 OLAP universes (.unx) and BEx Queries in the BW 7.x system BI4.0 relational universes (.unx) and BEx Queries in the BW 3.x system Microsoft Essbase and BEx Queries in the BW 3.x system SAP ERP tables and BEx Queries in the BW 7.x system.
You want to create a Crystal report based on a BEx Query that contains a characteristic value variable.
To which element is this variable mapped in Crystal Reports?
Formula Parameter Prompt Filter.
Which of the following objects can you use as target objects in a transformation?(Choose two) Business Layer InfoSet InfoCube InfoSource Data Foundation.
Your BW customer wants to access BEx queries in Web Intelligence, Dashboards, and Crystal Reports for Enterprise using BICS connectivity.
How do you explain the interaction between the BW and BI authorizations?
Authorizations for the required reporting tools and data access must be defined on the BI platform. Authorizations for BI users must be imported in BW to access data. Authorizations for the required reporting tools and data access must be defined in BW. Authorizations for the required reporting tools must be defined on the BI platform and for the data access in BW.
How do you schedule a SAP BusinessObjects Web Intelligence document? Use Promotion Management. Use the Universe Design tool. Use the BI launch pad. Use the Information Design tool.
For which use case would you recommend the use of Crystal Reports 2011? When you use BEx Queries in SAP NetWeaver Business Warehouse 7.x When you use OLAP universes on the SAP BusinessObjects BI 4.0 platform When you use BEx Queries in SAP NetWeaver Business Warehouse 3.5 or below When you use Analysis views in SAP NetWeaver Business Warehouse 3.5 or below.
Which of the following is a valid combination of sender-receiver assignment for the SAP BW report-to-report interface? InfoCube -> Transaction in SAP ERP system BEx query -> InfoCube BEx query -> PDF document BEx query view -> ABAP report in SAP BW system.
Which task can you perform using the SAP toolbar in Crystal Reports 2011? Set the root folder for the BW publisher service. Save reports to the BW system. Monitor the Crystal Reports Processing Server. Create a query definition.
Your customer requests a new dashboard. You suggest creating a prototype first, as advised by best practices.
What are the benefits of this recommendation?(Choose two)
You can simulate the data flow. You can simulate the design and development process. You can streamline the production time. You can simulate how users will interact with the dashboard.
When can you create a new BEx variable? When you define the data provider in the BEx Web Application Designer When you maintain an InfoProvider in the Data Warehousing Workbench When you work in design mode in the BEx Analyzer When you restrict a characteristic in the BEx Query Designer.
How are hierarchies in a BEx Query represented in Crystal Reports for Enterprise? As fields representing the parent node ID and node ID As subobjects of dimension objects for each existing hierarchy As attribute objects that belong to a dimension object As dimension objects for each node.
What is the difference between navigation attributes and display attributes in a BEx Query definition? Navigation attributes cannot be used in restricted key figures, display attributes can. Navigation attributes can be used in formulas, display attributes cannot. Navigation attributes behave like characteristics, display attributes do not. Navigation attributes cannot be filtered, display attributes can.
Which of the following actions can you perform in SAP BusinessObjects Explorer? Create a new chart type. Change the chart type used for data visualization. Import data directly from a dashboard. Design a layout template.
Which of the following data connectivity options can you use in dashboards?(Choose two)
Web service query (Query as a Web Service) XML Data HTTP SQLMOBILE.
Which types of objects can you target with commands in BEx Web Application Designer? Data provider and command sequence Web item and portal theme Query definition and planning function Web template and Web item.
How can you create a new report using a BEx Query in Crystal Reports 2011?(Choose two) Use the SAP toolbar. Use the Database Expert. Use the Repository Explorer. Use the Workbench.
You want to create a query in BEx Query Designer that produces a table as shown in the attached screenshot.
What do you have to use to accomplish this?
Filters Structures Exceptions Restricted key figures.
What does this formula do? Month ({Orders.Order Date}) Determines the month in which an order has been placed Lists the orders that have been placed in a given month Returns the total number of orders that have been placed in a given month Sorts the orders by month.
In an SAP BusinessObjects Analysis, edition for Microsoft Office workbook, where can you find the active filters?(Choose two) Under Design Panel -> Information tab In the Info field Under Design Panel -> Components tab Under Design Panel -> Analysis tab.
You are previewing a report in SAP Crystal Reports. After changing the filter in the Select Expert, you are prompted to choose between the Used Saved Data option and the Refresh Data option.
What happens if you choose the Saved Data option?
The updated query reads from the data source again. The data used in the report will be saved to the database. The data will be saved to the repository. The updated query reads only the records included in the report.
You want to insert a chart in a SAP Crystal Reports report. The chart should be displayed only on the first page of the report.
In which section do you insert the chart?
Report Header Page Header Details Group Header.
In Web Intelligence, where are formulas created by users persistently stored? In the universe On the Web Intelligence Processing Server On the Adaptive Job Server On the page of the report where the formula appears.
Which of the following Web items can you use to execute a command in a Web template?(Choose two) Text Item Dropdown Box Item Button Group Item Radio Button Group Item Checkbox Group Item.
What is a capability of the SAP BusinessObjects BI platform? Provide an alternative to data warehouse solutions. Analyze large volumes of operational data in real-time. Perform compression to reduce data storage. Provide one unified infrastructure for data assets and analytics.
You use BEx Query Designer to create a query with the characteristic "Material" in the rows and the key figure "Sales Volume" in the columns. Now you create an exception (Bad 3, Critical 2 and Good 1) and activate it. After executing the query, all values under Sales Volume are colored. You now edit the exception and click the Exception Only Affects Results button.
What happens in the report?
No report records are colored. Only the Bad 3 values are colored. Only the overall result of the Sales Volume key figure is colored. The exception is deactivated automatically.
Which variable type can use the processing type "replacement path"? (Choose three) Formula variable Hierarchy variable Hierarchy node variable Characteristic value variable Text variable.
What is the purpose of an "Exception" in Query Designer? To highlight data based on characteristic values To highlight data based on key figure values To hide data that does not meet threshold criteria To filter on measure values.
Which tasks can you perform by using URL parameters in BEx Web Application Designer?(Choose two) Change filter values. Change Web item properties. Change the authorization user. Change the applied portal theme.
You want to ensure that the SAP BusinessObjects Analysis Add-In is started automatically with your VBA code executed.
Where do you call the start-up procedure for the Analysis Add-In? In the properties settings of the VBA Editor In the After Redisplay registered callback In the workbook properties of the Components tab In the standard Workbook_Open event.
Your BW customer wants to integrate Web Intelligence documents into their SAP NetWeaver Enterprise Portal.
How can you accomplish this?(Choose two)
Use the Document Viewer iViews to integrate single Web Intelligence documents from the BI platform as iViews. Use the Document List iView to allow access to Web Intelligence documents stored on the BI platform. Upload the folders containing the Web Intelligence documents from the CMC to the portal as a role. Use the BW Publisher service to publish the Web Intelligence documents as iViews to the portal.
.
What is an attribute in BW? Additional information assigned to a key figure An object that stores master data A characteristic assigned to another characteristic A data field used to store transactional data.
What is the result of setting the "constant selection" property in the Extended tab of a restricted key figure? Navigation and filters will affect the restricted key figure. Navigation will affect the result of the restricted key figure, filters will have no effect. Filters will change the result of the restricted key figure, navigation will have no effect. Navigation and filters will not affect the restricted key figure.
Where can you save workbooks created with SAP BusinessObjects Analysis, edition for Microsoft Office? (Choose two) In an Analysis iView in the Enterprise Portal On your local PC On the BI platform On the BW server.
You are using the LifeCycle Manager to promote BI objects. How do you undo a change to an object in the target system? Roll back either a complete or a partial promotion Change the object directly in the production environment. Delete the promotion job in the source system. Reset the system time to a time before the transport.
How is a BW navigation attribute represented in Web Intelligence? As a prompt As a dimension As an attribute of a dimension As a query filter.
Which of the following combinations of structures can you create in BEx Query Designer? (Choose two) 1 characteristic structure and 2 key figure structures 1 characteristic structure and 1 characteristic structure 1 characteristic structure and 1 key figure structure 1 key figure structure and 1 key figure structure.
How are characteristic restrictions in a BEx Query processed by SAP BusinessObjects Analysis, edition for Microsoft Office and edition for OLAP? They appear as a background filter in Analysis and can be changed by users at runtime. They appear in the dimension folder of the related characteristic and cannot be changed. They are ignored. They are applied to the underlying query and cannot be changed by users at runtime.
Which components make up a data flow in BW? PSA table, Start Routine, and DataSource DataSource, Transformation, and InfoProvider Start Routine, Transformation, and End Routine InfoSource, DataSource, and PSA table.
What is the benefit of implementing data warehousing for reporting and analysis? To grant access to real-time data on mobile devices To consolidate and harmonize data from multiple systems and applications To guarantee data accuracy To reduce the number of transactional systems.
What happens when you activate a characteristic InfoObject with master data? Existing master data is validated and written in the activation queue. If the activation is successful, a Master data Change Run is automatically started. The assigned navigational attributes are activated for reporting in the InfoCube. The SID table and the appropriate master data tables are created in the Data Dictionary.
Which of the following data sources can you choose directly to create a Web Intelligence document?(Choose two) InfoCube Universe BEx Query View Business View Analysis View.
To which types of files can Crystal Reports 2011 reports be exported?(Choose two) Crystal Reports Read-Only (.rptr) Web Intelligence Document (.wid) Flash (.swf) MS Excel (.xlsx).
Which BW sources supply data to a BEx Web application?(Choose three) BEx Queries BWA indexes Fact tables InfoProviders BEx Query views.
You want to connect a number of different DataSources to a target. The DataSources have the same business rules.
Which object do you use to connect the DataSources to the target?
InfoArea InfoSource InfoPackage InfoProvider.
What is a key capability of SAP BusinessObjects Analysis, edition for Microsoft Office? Analyze data from OLAP universes. Provide a unified information modeling design environment. Analyze SAP BW data in Microsoft Excel. Change the BEx query definition.
You export a dashboard to PDF. Which file format is generated in the PDF? SWF CSV XLS XLF.
Which functional area of the Data Warehousing Workbench do you use to create and maintain objects that are relevant to the data staging process? Transport connection Metadata Repository Modeling Administration.
How do portal themes affect Web templates at runtime? They change the representation of the Web items on the Layout tab. They apply formatting styles to the Web items in the Web application. They overwrite the CSS attributes of individually changed Web items. They align the Web items as defined in the theme.
What is a characteristic of reusable query objects such as calculated key figures? Reusable objects can be changed without affecting other queries unless you set them as "to be changed". Reusable objects are saved on an InfoProvider and can be used in all queries on that InfoProvider. Reusable objects are automatically set as "reusable" in the object properties dialog box. Reusable objects are stored directly in either the fact table or master data of the underlying InfoCube.
For which purposes can you use the tabs in the Design panel of SAP BusinessObjects Analysis, edition for Microsoft Office? (Choose two) The Components tab, to retrieve information such as filters assigned to single components The Components tab, to add components such as charts or dropdown boxes to the workbook The Information tab, to add text information to the workbook by using drag and drop The Information tab, to display the structure of used elements The Analysis tab, to define the data that is displayed in the crosstab.
Your Crystal Reports 2011 report is grouped by city.
How can you display only cities that have more than 10 records?
Use the Database Expert. Use the Group Expert. Use the Select Expert. Use the Section Expert.
You need to combine data from multiple BW InfoProviders in one report using Crystal Reports for Enterprise.
What approach should you take?
Access a BEx Query that uses a VirtualProvider. Access a BEx Query that uses a MultiProvider. Access an OLAP universe. Access the necessary InfoProviders.
What can you use to align different Web items side by side? Overview tab Group Web item Container item HTML table.
What can you secure on the SAP BusinessObjects BI platform?(Choose two) Applications Queries InfoProviders Folders.
You want to customize your settings in the BI launch pad, but the Preferences button is disabled.
Why?
The BW user management denies you the rights to customize your own user preferences. Your system administrator denied you the rights to customize your own user preferences. The SAP Portal theme prevents you from customizing the BI launch pad. Your system administrator configured your system to use predetermined settings.
Which hierarchy elements can you select using the Member Selector in Web Intelligence?(Choose three) Hierarchy node variables Hierarchy children Hierarchy descendants Hierarchy variables Hierarchy nodes.
Which of the following options can be used to connect a dashboard to BW data? The result of a BEx Query view connected via a Web service query (Query as a Web Service) connection A Crystal Reports for Enterprise document connected with a Live Office connection Analysis views created with Analysis, edition for Microsoft Office via the SAP NetWeaver BW connection Content of a Web Intelligence document that is published as a Web service and connected via a Web service connection.
Which of the following functions is included in SAP BusinessObjects Analysis, edition for Microsoft Office? Migrate a BEx Analyzer Workbook. Create a Report-Report-Interface Define a filter by measure. Save a variant to the BW server.
How could you optimize the performance of a BEx query?(Choose two) Create aggregates. Use excludes in the filter settings. Update the database statistics. Create virtual key figures.
What is the purpose of design mode in BEx Analyzer? To change the query design To design query views To design and embed charts in the workbook To define the layout of the workbook using design items.
Which hierarchies are available when you use a BEx Query in SAP BusinessObjects Analysis, edition for Microsoft Office? All hierarchies of the characteristics that you use in the query The hierarchies that you activated in the query for the characteristics All hierarchies of the InfoProvider that you use in the query The hierarchies that you selected when inserting the query into Analysis.
What is the objective of the semantic layer? To validate data loaded into BW To create transformations from various ERP systems to a BW system To provide business users access to data without them needing to be familiar with the structure of the data sources To enable database administrators to create a data warehouse from multiple data sources.
Which InfoObjects can you use when creating BEx Queries? (Choose two) Hierarchies Structures Filters Characteristics Key figure.
Which of the following InfoProvider types always have the generated key figure 1ROWCOUNT (number of records)?(Choose two) DataStore Object InfoObject MultiProvider InfoCube.
What information should you provide for a SAP Business Warehouse connection in dashboards?(Choose two) The refreshing cycle, for example, every Monday morning at 8:30, or triggered on data load The mapping of the input and output parameters to the Microsoft Excel spreadsheet The query or query view used as the data source The fixed authorization user used to access the data.
Which task can users perform when interacting with the dashboard? Use a navigational path in Web Intelligence. Create your own navigational path. Follow a predefined navigational path. Share a navigational path with other users.
You define an OLAP connection to BW.
Which of the following objects can you define as targets for this connection?
MultiProvider and Favorites InfoCube and BW system Query and InfoArea Role and InfoCube.
What happens when you activate data in a DataStore Object (DSO)? The data from Persistent Staging Area (PSA) is written to the active data and the change log. The data from the activation queue is written to the active data and removed from the change log. The data from the InfoPackage is written to the activation queue The data from the activation queue is written to the active data and the change log.
What is the key capability of Web Intelligence? Perform in-memory computing for business analytics. Use familiar keywords to search directly across pre-indexed corporate data and display results by relevancy. Provide self-service access to BI content directly within Microsoft Office applications. Create free-form documents with elements such as simple tables, charts, and calculations.
Which of the following tools can consume analysis views?(Choose two) SAP BusinessObjects Web Intelligence SAP Crystal Reports 2013 SAP BI workspaces SAP BusinessObjects Analysis, edition for OLAP.
|
