Identify from the following options which ensure that the data displays on the page in a way that is easy to view and interpret? Please choose the correct answer.
- A . The Padding options at single level of your document
- B . The Format options at various levels of your document
- C . The Page break options at various levels of your document
- D . The Format options at single level of your document
Which tasks can you accomplish using breaks? There are 2 correct answers to this question.
- A . Generate a running sum in multiple table blocks.
- B . Remove repeated values in one table block.
- C . Break the table into multiple table blocks.
- D . Generate subtotals in one table block.
How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking? Please choose the correct answer.
- A . It will stay the same size.
- B . It will increase two times.
- C . It will increase three times.
- D . It will increase by 50% on each refresh.
What are the ways of adding breaks In the Web Intelligence Desktop application? There are 2 correct answers to this question
- A . Click on the origin where you want to insert a break
- B . In the Analysis toolbox, on the Display tab, by clicking Break
- C . The row or column where you want to add the break and selecting Break>Add Break
- D . In the text, on the Design tab, by clicking Break
What is the procedure to Display the data in the table as an image that maintains the original formatting? Please choose the correct answer.
- A . Right-click the table and, from the contextual menu, select Copy
- B . Drag data in a table in the target application and you can add the data contained in the table, click copy and paste
- C . Drag and drop the table from Web Intelligence to the target application
- D . Right- click the table to the target application and maintain the formatting from Web Intelligence
Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source? Please choose the correct answer.
- A . Crystal Reports
- B . Desktop Intelligence
- C . Web Intelligence in InfoView
- D . Web Intelligence Rich Client
Which three statements are true about alerters? There are 3 correct answers to this question.
- A . You can apply alerters to charts.
- B . You can apply multiple alerters to one block.
- C . You can apply the same alerter to multiple blocks.
- D . You can control the order in which alerters are applied.
Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)? There are 2 correct answers to this question.
- A . LTM
- B . LDAP
- C . Offline
- D . Enterprise
- E . Standalone
What are the two relational operators that can be used with wildcard Characters, in a query filter? There are 2 correct answers to this question
- A . Design pattern: to find values that match the design you specify
- B . Matches pattern: to find values that match the pattern you specify
- C . Different from pattern: to find values different than the pattern you specify
- D . Defined pattern: to find values that match the defined pattern you specify
Which two statements are true of contexts? There are 2 correct answers to this question.
- A . You can combine objects in different contexts.
- B . You cannot combine objects in different contexts.
- C . You can combine any object within the same context to create a query.
- D . You can combine only measures within the same context to create a query.
Which three statements are true of calculation contexts? There are 3 correct answers to this question.
- A . If no context is defined the default context is assumed.
- B . You can use NoFilter() as an extended syntax keyword when using contexts.
- C . The ForEach context operator automatically takes the dimensions in the block into account.
- D . You must place parentheses around the values listed after the Where keyword when using the Where operator.
Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel? Please choose the correct answer.
- A . Web Intelligence
- B . InfoView Preferences
- C . Microsoft Excel File Options
- D . Web Intelligence Rich Client
Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x? Please choose the correct answer.
- A . Report Properties tab
- B . Data tab
- C . Navigation tab
- D . Object Properties tab
Which two statements are true about Page Layout of a report? There are 2 correct answers to this question.
- A . It displays the definition of the block.
- B . It displays the report page by default.
- C . It defines what the report will look like when printed.
- D . It defines what the report will look like in PDF mode.
Which three methods can you use to combine queries using the Web Intelligence Rich Client? There are 3 correct answers to this question.
- A . UNION
- B . MINUS
- C . UNION ALL
- D . INTERSECT
Build a query using the eFashion universe, and select the following options to create a section? There are 3 correct answers to this question
- A . Year
- B . Quarter
- C . Half-Year
- D . Sales revenue
- E . Monthly Sales revenue
Select the correct sequence To Format a Bar Chart? Please choose the correct answer.
- A . Report Element>Chart>Insert Column Chart
- B . Chart> Report Element >Insert Column Chart
- C . Chart> Insert Column Chart >Report Element
- D . Insert Column Chart>Chart>Report Element
Which two are calculation context types? There are 2 correct answers to this question.
- A . Input
- B . Output
- C . Logical
- D . Conditional
Which scenarios should you use breaks for? There are 2 correct answers to this question.
- A . Generating subtotals in one table block
- B . Breaking the table into multiple table blocks
- C . Grouping repeated values in one table block
- D . Generating running sum in multiple table blocks
Which three options appear in the Scope of Analysis pane in the Query panel? There are 3 correct answers to this question.
- A . None
- B . Default
- C . Custom
- D . One Level
Where do you view merged dimensions? Please choose the correct answer.
- A . In the Report Map pane
- B . In the Available Objects pane
- C . In the Document Structure and Filters pane
- D . In the Query panel
Which method can you use to build a custom sort? Please choose the correct answer.
- A . Right-click the table, select "Custom Sort"
- B . Right-click the table, select "Sort" and select "Custom Sort"
- C . Select a column; on the toolbar, click the "Custom Sort" button
- D . Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort"
Which two are benefits of using breaks? There are 2 correct answers to this question.
- A . Creates a navigation map
- B . Makes the table block easier to read
- C . Splits the block into smaller table blocks
- D . Enables the use of subtotals in one block
Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)? There are 3 correct answers to this question.
- A . Personal data files
- B . Stored procedure data source
- C . Queries from the same universe
- D . Queries from different universes
What is the default behavior when creating a report from two queries from the same universe? Please choose the correct answer.
- A . Result produces two table blocks.
- B . Dimension objects are automatically merged.
- C . Results are shown on two different report tabs.
- D . Dimension objects are not automatically merged.
Which two are running aggregate functions in Web Intelligence? There are 2 correct answers to this question.
- A . RunningMax()
- B . RunningSum()
- C . RunningTotal()
- D . RunningMean()
Discuss all the advantages link to organizing a report in the section. There are 2 correct answers to this question
- A . You can have multiple blocks projected from the same microcube within a single report, all sub-grouped to the sectioned level
- B . You can have single block projected from the same microcube within a single report, all grouped to the sectioned level
- C . You can insert subtotal cells, repeated in each section, which are created by the simple process of drag and drop
- D . You can insert tables, different in each section, which are created by the simple process of drag and drop
Which of the following is not a step of demonstration, to display an aggregate within a sectioned report. Please choose the correct answer.
- A . Click a detail row in the Sales revenue column
- B . Click the Table, Chart or Others tab
- C . Click the Analysis Toolbox
- D . Click the Functions Tab
Which three calculations can you use in a measure object in Web Intelligence? There are 3 correct answers to this question.
- A . Min
- B . Max
- C . Count
- D . Count All
Which three statements are true of contexts? There are 3 correct answers to this question.
- A . Contexts are defined in a report.
- B . Contexts are defined in a universe.
- C . You can combine objects in different contexts.
- D . You can combine any objects within the same context to create a query.
Which Report Manager tab should you use to change report formatting? Please choose the correct answer.
- A . Map
- B . Data
- C . Properties
- D . Templates
You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report.
How does Web Intelligence respond? Please choose the correct answer.
- A . It prompts you to choose a hierarchy level and waits for your response before retrieving the data.
- B . It notifies you that it needs to retrieve additional data to complete the drill and retrieves the data.
- C . It inserts a prompted query filter in the query and reruns the query.
- D . It inserts a prompted report filter on the report and refreshes the report view.
Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location? Please choose the correct answer.
- A . Save the document to the Enterprise directories
- B . Save the document to the Enterprise documents.
- C . Export the document to the Central Management Server (CMS).
- D . Export the document to the Central Configuration Manager (CCM).
Which two data sources can you directly access from a Web Intelligence document (WID) using the Web Intelligence Rich Client? There are 2 correct answers to this question.
- A . Universe
- B . Text File
- C . Web Service
- D . OLAP Cube
Which two methods can you use to define document properties? There are 2 correct answers to this question.
- A . Click the report tab, select "Document Properties" and enter the required information.
- B . Right-click the report tab, select "Document Properties" and enter the required information.
- C . Right-click a blank space on the report page, select "Document Properties" and enter the required information.
- D . In the Properties tab of the Report Manager, select "Document Properties" and enter the required information.
Which method can you use to hide data using an alerter? Please choose the correct answer.
- A . Build an alerter that removes the column.
- B . Build an alerter that applies a formula that changes the block value.
- C . Build an alerter with a formula that changes the font color to the background color.
- D . Click anywhere in the document. On the toolbar, click the "Data" button and select "Hide Data".
A variable in your report contains the statement:
=If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] =
"Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
Sales revenue for Florida is $1,879,159.
Which rate is applied to the Florida revenue by the formula? Please choose the correct answer.
- A . 1.00
- B . 1.05
- C . 1.10
- D . 1.15
- E . 1.18
How do you duplicate a query? Please choose the correct answer.
- A . Choose Duplicate Query in the Tools Menu
- B . Select Duplicate Query in Properties in the Query Panel
- C . Right-click Query in the Report Manager and select Duplicate Query
- D . Right-click the Query Tab in the Query Panel and select Duplicate Query
Which three types of local data files can you use to create a BusinessObjects Web Intelligence 4.0 document (WID)? There are 3 correct answers to this question.
- A . TXT
- B . XML
- C . CSV
- D . XLS
Which type of relationship links sub-queries by default? Please choose the correct answer.
- A . OR
- B . AND
- C . NOR
- D . NAND
Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel? There are 2 correct answers to this question.
- A . You can enable the "Fixed" option.
- B . You can set the "Max retrieval time".
- C . You can set the "Max rows retrieved".
- D . You can specify a "Sample Result" set.
Which three output context expressions are valid extended syntax expressions? There are 3 correct answers to this question.
- A . Where ([State] = "CA")
- B . Where Section In [State]
- C . In Block Where Section = [State]
- D . In Section Where ([State] = "CA")
- E . Where ([State]="CA" And [Year] ="2006")
In the Web Intelligence Desktop, when you save a document as an Excel file, you can specify which reports saving; Following are the options available to save and export data? There are 2 correct answers to this question
- A . Prioritize data analysis in the Excel document
- B . Prioritize the format of reports in the Excel document
- C . Prioritize easy data processing in the Excel document
- D . Prioritize the selection of best solution in the Excel document
Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field? Please choose the correct answer.
- A . Left(5; [Product Name])
- B . Left([Product Name]; 5)
- C . Right((Product Name), 5)
- D . Right(5, [Product Name])
Your report contains a table.
What happens when you drop a dimension object into a blank part of this report? Please choose the correct answer.
- A . A new group is created.
- B . A new block is created.
- C . A new free-standing cell is created.
- D . A new section is created.
You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context.
Which output statement should you use? Please choose the correct answer.
- A . In([State])
- B . Out([State])
- C . ForAll([State])
- D . ForEach([State])
For what purposes can you use the Page Layout of a report? There are 2 correct answers to this question.
- A . To display the definition of the block.
- B . To define how the report will look like in PDF mode.
- C . To define how the report will look like when printed.
- D . To display the report page by default.
Which method should you use to group query filters together to form one AND statement? Please choose the correct answer.
- A . Drag the queries together
- B . Drag the query filters to the Group panel
- C . Select the filters, right-click and select Group
- D . Select the filters, then click the Group Filters button on the toolbar
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers.
You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers.
Which function should you use in the variable?
- A . NoFilter()
- B . NoRank()
- C . AverageAll()
- D . IgnoreFilter()
From the following identify which of the option is not a method to copy a chart from Web Intelligence to a target application? Please choose the correct answer.
- A . Right-click the chart, and, from the contextual menu, select Copy.
- B . In the target document, right-click the section cell and, from the contextual menu, click Copy
- C . In the target document, right-click the area where you want the table to appear and, from the contextual menu, select Paste
- D . Drag and drop the table from Web Intelligence to the target application