You are working with a previously saved document and you have deleted a logical operator. Which two methods can you use to recover the logical operator? (Choose two.) Rebuild the filters. Click the Undo button in the Query panel. From the Tools menu, select Recover Operator. Close the Query panel without executing and then open the query.
Which option can you use to convert a table block into a chart in Web Intelligence Rich Client? Right-click the table block and select "Turn To" Click Format > Charts and select "Convert to Chart" Right-click the table block and select "Convert to Chart" Click Tools > Charts and select "Change Table to Chart".
Which method should you use to group query filters together to form one AND statement? Drag the queries together Drag the query filters to the Group panel Select the filters, right-click and select Group Select the filters, then click the Group Filters button on the toolbar.
Where is a Web Intelligence variable stored? In the cell In the document In the Metadata Cube In the Central Management Server (CMS).
Which two break properties can you use when setting Break Priority? (Choose two.)
Order Breaks Vertical Breaks Crosstab Breaks Horizontal Breaks.
You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold? Sum Detail Measure Dimension.
Which three calculations can you use in a measure object in Web Intelligence? (Choose three.) Min Max Count Count All.
Which two panels can you use to purge data from a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose two.) Query Report Active X Slice and Dice.
Which three elements are parts of a query filter? (Choose three.) Class Object Operator Operand.
Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)? Dimension - Detail Measure - Measure Dimension - Measure Dimension - Dimension.
Which tab should you use to change the page orientation of a report?
Click File > Page Setup and select "Page Orientation" In InfoView Preferences, change the default page orientation Select the report tab; in Report Manager, select the "Properties" tab and select the "Page Orientation" Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation".
Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report? The Scope of Analysis is empty. The Scope of Analysis is not empty. The query drill mode option is enabled. The query drill mode option is not enabled.
Which three types of local data files can you use to create a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose three.) TXT XML CSV XLS.
Which two operators are available when using wildcards in a query filter? (Choose two.)
LIKE Matches Pattern Not equals Pattern Different from Pattern.
What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected? A new block is created. A new section is created. An error message is displayed. The currently selected cell is displayed.
Which two options should you take before you finish creating a variable in Web Intelligence? (Choose two.) Save Parse Export Validate.
Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID)? Advanced Query Active X Interactive.
Which two statements are true about the AND operator? (Choose two.) Used when any condition is met by two filters Used when all conditions are met by two filters Used when all conditions are met by more than two filters Used when only one condition is met by any of the filters.
Your document displays all data in black. Which dialog box should you use to configure the colors of your document data? Document Palette Document Formats Display Preferences Data Tracking Options.
Which three options are valid Page Layout Options in the Properties tab of a document? (Choose three.) Top margin Left margin Page orientation Background color Visited hyperlink colors.
Which three layout options can you use when creating sections in a report? (Choose three.) Relative Position Start on New Page Keep Blocks Together Avoid Page Break in Section.
Which three can you use to start the Web Intelligence Rich Client from? (Choose three.) InfoView Command Line Start > All Programs Central Management Console.
Which method can you use to build a custom sort? Right-click the table, select "Custom Sort" Right-click the table, select "Sort" and select "Custom Sort" Select a column; on the toolbar, click the "Custom Sort" button Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort".
Which three options are default page number cells? (Choose three.) Page Number Total Number of Pages Page Number / Total Pages Total Number of Pages in Section.
Which three are drill options? (Choose three.) Hide drill toolbar Show drill filters Prompt if drill requires additional data Synchronize drill on report blocks.
How many blocks can you create in a Web Intelligence document (WID)? 1 2 4 8 Unlimited.
Where do you set the "Optional prompt" option in Web Intelligence Rich Client? Query Panel Prompts Panel Slice and Dice Panel Document Properties.
Which two statements are correct about hierarchies in Web Intelligence? (Choose two.) They can be created using the Query panel. They can be created in the Scope of Analysis panel. They can be chosen using a custom Scope of Analysis. They are used to define the drill path in the Scope of Analysis.
Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)? (Choose two.) LTM LDAP Offline Enterprise Standalone.
You create a document with data from multiple data providers. Which two tasks can you perform to include all data from all providers in the same report block? (Choose two.)
Synchronize the data providers. Manually merge all dimensions. Synchronize the data providers SQL. Manually merge the parent dimensions.
Which method should you use to activate "Interactive Viewing"? Preferences in Web Intelligence Preferences in InfoView In the Document Properties In the Report Properties.
Which method can you use to change the object qualification of an object within Web Intelligence Rich Client? In the Query panel, select the qualification. In the Document Properties, select the qualification. In Query View, right-click and select the qualification. Select the object, right-click and select the qualification.
Where are formulas stored when created in Web Intelligence? On the report page In the universe In the Central Management Server (CMS) database In the metadata of the Cube.
What is the maximum number of sub-alerts that an alerter can contain? 1 8 16 32.
Which two options can you change when using Quick Display Mode? (Choose two.) Limit Query Results Sample Query Results Vertical Records Per Page Horizontal Records Per Page.
Which three methods can you use to apply a section in the Web Intelligence Rich Client? (Choose three.) Click the "Set Master" button in the toolbar. Drag the column to be sectioned outside the block. Select the column; select Reporting Menu Option and then select "Set As Section". Right-click the column on which you want to create a section. From the drop-down menu, select "Set As Section".
Which two options are valid options when you save a Web Intelligence document (WID) in the Web Intelligence Rich Client? (Choose two.) Save As Save As FTP Save Query As Save to My Computer As.
Which two locations can you use to set the drill options? (Choose two.) Report Properties Query Panel Properties Preferences in InfoView Scope of Analysis Properties Tools/Options in Web Intelligence Rich Client.
Which three rules apply when you manually synchronize queries? (Choose three.)
Dimension value formats must be the same. Dimensions with different names can be merged. Dimensions with different data types can be merged. Dimensions from multiple data sources can be merged.
Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView? Local Settings Browser Preferences User Machine Settings InfoView Preferences.
Which of the following statements best describes analysis authorizations? Analysis authorizations are required only by data analysts working in the Data Warehousing Workbench to model or load data Analysis authorizations are required by all users working in the Business Explorer Suite to export query data to a local file Analysis authorizations are required by users who want to display transaction data from authorization-relevant characteristics in a query Analysis authorizations are required by users who want to make characteristics authorization-relevant in the Data Warehousing Workbench.
Your customer is seeking better performance on the query filter selection screens for the InfoObject 0CUSTOMER. The customer has also asked for the user to only be allowed to select customers who have transaction data in the InfoProvider being used by the query. What is an easy option to consider in fixing both problems? For InfoObject 0CUSTOMER, set the Query Execution Filter Value Selection parameter to “Values in InfoProvider”. For InfoObject 0CUSTOMER, set the Query Definition Filter Value Selection parameter to “Values in InfoProvider”. Create a separate index on 0CUSTOMER in the InfoProvider and reference the index in the filter screen. Build an aggregate on 0CUSTOMER for this InfoProvider and reference the aggregate in the filter screen.
DataStore Object. You have analyzed the source of the data and determined that it will always contain unique records based on the document number. For this reason, there will be no need to use delta loads of the data.
In order to capture any duplicate document numbers that were accidentally loaded, but still allow the data to be reported, how would you configure the write-optimized DataStore Object?
Note: There are 2 correct answers to this question. Only use the technical key of the write-optimized DataStore Object Ensure that the semantic key contains the document number Deselect the indicator for “Do not check uniqueness of data” Deselect the indicator for “Unique Data Records”.
You need to update a record in a standard DataStore Object but the corresponding record no longer exists in the source system. What is the best approach to solve this problem, assuming that directly updating the DataStore Object table is not an option?
Note: There are 2 correct answers to this question. Create a new DTP and transformation and then reconstruct the request with the new record Reconstruct the DataStore Object from the Data Warehouse layer of the EDW If the PSA still has the original record, change the record manually in the PSA and then reload the request Use Open Hub to export the record from the DataStore Object, change the record then reload the changed record.
A customer reports that selective deletion of records from an InfoCube with 9 million data records runs for several hours. Which of the following factors directly influence the deletion process?
Note: There are 2 correct answers to this question. High number of characteristics in one dimension High number of non-cumulative key figures Uncompressed aggregates on the InfoCube High number of physical partitions High number of display attributes.
A query includes multiple authorization-relevant characteristics. Your customer enables other characteristics used in that query as authorization-relevant with asterisk (*) authorization.
What is the impact?
Please choose the correct answer. The query response time slows noticeably. The authorization maintenance increases. Existing views of that query need to be rebuilt. The query needs to be republished to the Portal.
Which index setups do you recommend for optimal usage of a BW system on an Oracle database?
Note: There are 2 correct answers to this question. An additional index on the partitioning column of the fact table for a partitioned InfoCube A bitmap index for the foreign key of a fact table of a InfoCube A unique index as primary key index for the fact table of a InfoCube A B-Tree index for the foreign key of a line item dimension of a InfoCube.
The cell editor...There are 2 correct answers to this question. Select which of the following answers are correct. ...is always available to make cell-specific definitions in the query definition. ...is available to make cell-specific definitions in the query definition when two structures make up the definition. ...allows you to define cells that have no direct reference to the associated structural components. ...allows you to determine the format of a cell in the BEx Report Designer.
The key date of a query...
There are 2 correct answers to this question. Select which of the following answers are correct. ...used for restricting the time characteristics contained in a query. ...is a decisive factor for the display of time-dependent texts and attributes, independent of the selected transaction data. ...can be determined flexibly at the report runtime by using a variable ...can also enable you to display the progression of attribute values in the selected time period using a variable that represents a time interval.
Display attributes...There are 2 correct answers to this question. Select which of the following answers are correct. ...primarily serve as supplemental information for the carrying characteristic ...can be used for navigating in a report. ...can be used to sort in a report. ...can be used in the query definition to filter individual values of the attribute. ...can be used as navigation attributes in the query definition.
UDC (Universal Data Connect) enhances SAP NetWeaver BI by supporting integration and connectivity to a wide range of data sources. Which of the following statements are true statements regarding UDC?
There are 2 correct answers to this question. Select which of the following answers are correct. UDC integration with JDBC (Java Database Connection) only supports persistent data handling: data that is physically stored on BW. UDC integration with JDBC (Java Database Connection) supports transient data handling: direct access to data that is stored in the source system. Creation of UDC DataSources takes place in the Data Warehousing Workbench of SAP NetWeaver BI. InfoPackages are scheduled for UDC DataSources even though the BI Java Connectors push data to the PSA tables.
Which of the following interfaces are used to connect SAP NetWeaver BI to external OLTP systems (from the BI view)?
There are 2 correct answers to this question. Select which of the following answers are correct. Service API UD Connect (JDBC Connector) UD Connect (ODBC Connector) DB Connect.
Users are complaining about "poor query performance" in BI. What initial step would you take to address this situation?
Please choose the correct answer. Rebuild the indexes on all InfoCubes Split large InfoCubes into groups of smaller lnfoCubes Review the system logs to help identify the problems Use the BI Administrator Cockpit reports to identify problem queries for more detailed analysis Use the BI Administrator Cockpit reports to review data load performance.
Your customer wants to focus on the profitability of their highest volume items. Which of the following techniques in BI could you use to enable this requirement?
Note: There are 2 correct answers to this question. Top N conditions based on Gross Margin Percentage Regression analysis using the Analysis Process Designer Cluster analysis using the Analysis Process Designer Exceptions based on monthly sales quantities ABC analysis using the Analysis Process Designer.
Which of these statements about the attributes of InfoObjects of type "characteristic" - 2 InfoObjects of type "characteristic" must show at least one attribute All attributes are display attributes by default attributes can be time-dependent All attributes are time-dependent by default.
Which of the following is true concerning DataStore Object types in SAP NetWeaver BI ? -1 A Data Transfer Process can only send delta data to target InfoProviders if it is based on a Standard DataStore Object The Write-optimized DataStore Object allows for delta data transfer to target InfoProviders The write-optimized DataStore Object can be used for administrative purpose only as query creation is not possible on this type of DataStore Object.
Which of the following statements accurately describe a DataStore Object in terms of its technical architecture? -3 Aggregates based on DataStore Objects can accelerate access to DataStore Object data DataStore Objects make a distinction between characteristic InfoObjects as keys and key figures as dependent objects. The cumilative update of key figures is supported for DataStore Objects. With DataStore Objects it is also possible to overwrite data fields. Not every characteristic InfoObject in a DataStore Object definition must be a component of the key A Data Store Object consists of a key made up of one or more characteristic InfoObjects.
Which of the following statements about a (new) InfoSource are correct ? -1 InfoSources can be used for reusing existing InfoProviders sepcific transformations when connecting one InfoProvider to a several DataSources Only one DataSource can be assigned to an InfoSource. InfoSources are mandatory when connecting DataSources to InfoProviders InfoSources are source system-dependent InfoSources are used if you want to run two (or more) sequential transformations in the data flow.
Which of the following are features of a transformation? -2 Variables for single field conversions (values can be entered at transformation rintime) Start Routine, End Routine and expert routine for advanced data package-based transformations Routines and Formulas for single field transformations Temporary data storage (defined in the transformation properties) for improved debugging and error.
Which of the following scenarios are supported by Write-optimized DataStore Objects? -1 "load of new records". Every record has a new key and gets inserted into the active table, the activation queue and the change log. "Load & Drop". Fast upload of data to DataStore Object, subsequent update of new data to further InfoProviders, and deletion of DataStore Object data. Loading large sets of data records at a detailed granularity to SAP Net_Weaver BI. This can even include wide structures (high number of data fields) "Direct update". Updating large sets of data records to the Write-optimized DataStore Object can be don using APIs (no need for DataSources and Transformations).
Which of these statements about DataStore Objects of "Standard" type are correct ? -2 DataStore Objects can contain data fields that include both characteristics and key figures. DataStore Objects only contain key figures. One of the functions of DataStore Objects is to harmonize and consolidate data bejore it is aggregated for storage in InfoCubes DataStore Objects store data in multidimensional tables.
Which of the following statements on source system specific features for (new) DataSources in SAP NetWeaver BI is true? -2 During the activation of Business Content on SAP NetWeaver BI, Buisiness Content DataSources n SAP sources systems can also be automatically activated n the source system. During the design of DB Connect and UD Connect DataSources, necessary views for extraction can be created remotely on the connected sources from the DataSource definition During the design of File DataSources, field proposals can be generated from the file to be loaded. During the activation of a Web Service DataSources, a SOAP compilant Web Service is generated that can be called from external tools for pushing data into the DataSources'PSA table. During the design of File DataSources, the file format (ASCII or CSV) is determined automatically from the file to be upload.
Which of the following are supported document classes in SAP NetWeaver BI ? -3 Object Data InfoProvider (transaction data) Meta Data Master Data.
You want to publish a document to a common location where all employees of your department can access it and provide feedback, Which of the following approaches would be the most effective ? -1 Broadcast the document via email to each employee with a note to encourage feedback Save the document in a public folder for your department in the SAP Netwaver Portal Upload the document to a query that is commonly used by all department employees. When the employee runs the query, they can access the document and then provide feedback via email.
In a web enviroment, which of the following is the primary toolf or doing ad hoc analysis ? -1 Bex Web Analyzer Bez Web Application Designer Bex Report Designer.
The APD (Analysis Process Designer) in SAP NetWeaver BI provides a mechanism for reading data from a source and then transferring the analytical results back out to a data target. In this scenario, wich of the following are possible data targets of te APD ? -2 InfoObject master data tables Meta Data Repository DataStore Objects for direct update Virtual Providers Standard DataStore Objects.