Which three options are default page number cells? There are 3 correct answers to this question.
- A . Page Number
- B . Total Number of Pages
- C . Page Number / Total Pages
- D . Total Number of Pages in Section
You insert the function CurrentDate() into a cell.
To clarify the date you add a string so that the formula is now:
="Sales Report from "+CurrentDate()
Which formatting capability is disabled for the cell?
- A . Format cell
- B . Hide cell
- C . Align text
- D . Format number
In the query panel, you modify the script and no errors occur. You remove an object and add a different object to the Result Object pane .
What happens to the script?
- A . The script includes both the manual change and the new result objects.
- B . The script remains unchanged because the script was changed manually.
- C . The script fails to parse.
- D . The script is regenerated because the result object list is changed.
How can you see general report information such as the document author and the document creation date?
- A . Select the Query Properties button.
- B . Open the Query panel.
- C . Insert the pre-defined cell Query Summary in the report.
- D . Open the Document Summary panel.
In what application mode can you freeze column headers?
- A . Data
- B . Design, With Data
- C . Reading
- D . Design, Structure Only
Where is a predefined query filter created?
- A . In the universe
- B . In the query panel
- C . In the filter bar
- D . In the Input Controls pane
Which keyword is defined as flexible for input contexts?
- A . In
- B . All
- C . ForAll
- D . ForEach
Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence 4.0? There are 2 correct answers to this question.
- A . Drag the measure from the Data tab into the section header.
- B . Copy the measure from the Data tab into the section header.
- C . While pressing the ALT key, drag the measure from the table to the section header.
- D . While pressing the CTRL key, drag the measure from the table to the section header.
What is the output of the following expression when the CurrentDate is January 31, 2014?
If (MonthNumberOfYear(CurrentDate())=1;
Year(CurrentDate())-1;
Year(CurrentDateQ))
- A . 2014
- B . 01/31/2014
- C . 01/31/2013
- D . 2013
Which four authentication methods are available for Web intelligence Rich Client? There are 4 correct answers to this question.
- A . AD
- B . NT
- C . LDAP
- D . Vintella
- E . Kerberos
- F . Enterprise
Which of the following options are use to create a default vertical table? There are 2 correct answers to this question
- A . Create a validate query
- B . Create a new query
- C . Run a new query
- D . Run query panel
How can you make the pie chart (shown in the attached graphic) display correctly?
- A . Change to the Design – With Data application mode.
- B . Drag a measure on to the chart
- C . Change to the Reading application mode.
- D . Drag a dimension or attribute on to the chart
What items can be presented in a free-standing cell? (2 answers)
- A . Page numbers
- B . Last refresh date
- C . Bar charts
- D . Vertical tables
What is the maximum number of sub-alerts that an alerter can contain?
- A . 1
- B . 8
- C . 16
- D . 32
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
You are working with a set of store revenues. All stores have positive revenue values .
Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?
- A . =[Revenue]/RefValue([Revenue])
- B . =[Revenue]/PreValue([Revenue])
- C . =[Revenue]/HistValue([Revenue])
- D . =[Revenue]/BaseValue([Revenue])
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
Why would you use the FormatDate() function? There are 2 correct answers to this question.
- A . To modify the format of a string object into a non-standard date format.
- B . To convert a string object into a date object.
- C . To convert a date object into a string object.
- D . To format a date so that it is displayed as a string when it is concatenated with another string.
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.
What is the correct formula for the RunningSum column (shown in the attached graphic)?
- A . RunningSum([Sales revenues];([Year];[Quarter]))
- B . RunningSum([Sales revenues];[Year];[Quarter])
- C . RunningSum([Sales revenues];([Year]))
- D . RunningSum([Sales revenues] in [Quarter])
Which of the following is not a preferred method for duplicating a table?
- A . Context sensitive menu
- B . Toolbar buttons
- C . Table of contents
- D . Keyboard shortcuts
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?
- A . 1.00
- B . 1.05
- C . 1.10
- D . 1.15
- E . 1.18
Which tab should you use to change the page orientation of a report?
- A . Click File > Page Setup and select "Page Orientation"
- B . In InfoView Preferences, change the default page orientation
- C . Select the report tab; in Report Manager, select the "Properties" tab and select the "Page Orientation"
- D . Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation"
Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"? There are 2 correct answers to this question.
- A . Left()
- B . LeftPad()
- C . LeftTrim()
- D . Concatenate()
Why is the subtotal missing from the bottom of each break in the attached diagram?
- A . The report is NOT sectioned by year.
- B . The default aggregation on the measure is delegated.
- C . The calculation was applied to the table before the break.
- D . The break footers display option is NOT selected.
Which three options are Web Intelligence drill mode options? There are 3 correct answers to this question.
- A . Drill By
- B . Drill Up
- C . Drill Down
- D . Drill Through
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? There are 2 correct answers to this question.
- A . Synchronize the data providers.
- B . Manually merge all dimensions.
- C . Synchronize the data providers SQL.
- D . Manually merge the parent dimensions.
Identify from the correct option from the following – To Navigate from Section to Section?
- A . The Report Element pane to work on one report to another and navigate from Multiple section
- B . The Report Map pane to jump from one cell to another and navigate one and two sections
- C . The Report Map pane to jump from one report to another and navigate from section to section
- D . The Report Element to jump from one section to another and navigate from column to row
Which Web Intelligence component should you use to list the existing variables in a report?
- A . Report Manager
- B . Formula Editor
- C . Variable Editor
- D . Slice and Dice Panel
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")
The universe is made up of classes and objects; there are three different types of objects .
What are they? There are 3 correct answers to this question
- A . Analyze C Analysis of data for required result
- B . Dimension -Typically retrieve character-type data
- C . Detail -Provides descriptive data about a dimension
- D . Measure – Retrieves numeric data that is the result of calculations on data in the database
- E . Improve- Selecting and implementation of the best solution
Conditional formatting rules enable you to highlight results that meet or fail specific business targets. Name the elements associated with the Formatting rules? There are 3 correct answers to this question
- A . An object or cell contents
- B . A modified data formatting
- C . A cell section
- D . An operator
- E . The conditional formatting
Elucidate the advantages of saving formulas as variables?
- A . Use as options available in the Format and Report Element toolboxes
- B . You can reuse the formula without having to enter it each time
- C . Create the formulas and feed it with all its dimensions
- D . Use variables in any report within the document
Discuss the instructions appropriate for how you want the data in a table and manipulate the data within the table There are 2 correct answers to this question
- A . Right-click the table and, from the contextual menu, select Copy
- B . In the target document, right-click the section cell and, from the contextual menu, click Copy and paste
- C . Drag and drop the table from Web Intelligence to the target application
- D . In the target application, right-click the area where you want the table to appear and, from the contextual menu, select Paste
Which type of relationship links sub-queries by default?
- A . OR
- B . AND
- C . NOR
- D . NAND
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.
To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 4.0? There are 3 correct answers to this question.
- A . Broadcast Agent
- B . Business Objects Inbox
- C . FTP
- D . Email
- E . File Server
What can you use breaks for?
- A . To create a section
- B . To create multiple table blocks
- C . To remove repeated values in one table block
- D . To manipulate the navigation path
Which two statements are true about using the Where operator with an output context? There are 2 correct answers to this question.
- A . It must contain Boolean operators.
- B . It restricts the data used to calculate the measure expression.
- C . It modifies the WHERE clause of the SQL generated to calculate the measure expression.
- D . It is not necessary to place parentheses around the values listed after the Where operator.
Which two options are valid options when you save a Web Intelligence document (WID) in the Web Intelligence Rich Client? There are 2 correct answers to this question.
- A . Save As
- B . Save As FTP
- C . Save Query As
- D . Save to My Computer As
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?
- 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.
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
Design mode provides access to the following toolboxes and their associated functions .
What are they? There are 3 correct answers to this question
- A . Improve function
- B . Matches data task
- C . Report Element
- D . Data Access
- E . Analysis task
Which two options can you change when using Quick Display Mode? There are 2 correct answers to this question.
- A . Limit Query Results
- B . Sample Query Results
- C . Vertical Records Per Page
- D . Horizontal Records Per Page
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 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
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.
What is the procedure to Display the data in the table as an image that maintains the original formatting?
- 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 of the following can you use to filter results dynamically? (2 answers)
- A . Element linking
- B . Report map
- C . Results Object pane
- D . Input control
Which Report Manager tab should you use to change report formatting?
- A . Map
- B . Data
- C . Properties
- D . Templates
Where do you view merged dimensions?
- 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 DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?
- A . =DaysBetween([Birth_date] ; CurrentDate ) / 365.25
- B . =DaysBetween([Birth_date] , CurrentDate() ) / 365.25
- C . =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25
- D . =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25
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 two options should you take before you finish creating a variable in Web Intelligence? There are 2 correct answers to this question.
- A . Save
- B . Parse
- C . Export
- D . Validate
Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence 4.0? There are 3 correct answers to this question.
- A . Sort
- B . Filters
- C . Format Cell
- D . Merge Dimensions
Which two are calculation context types? There are 2 correct answers to this question.
- A . Input
- B . Output
- C . Logical
- D . Conditional
What do you use to search for content in multiple documents?
- A . Central Configuration Manager (CCM)
- B . Central Management Console (CMC)
- C . Report map
- D . BI launch pad
What do you use to search for content in multiple documents?
- A . Central Configuration Manager (CCM)
- B . Central Management Console (CMC)
- C . Report map
- D . BI launch pad
What do you use to search for content in multiple documents?
- A . Central Configuration Manager (CCM)
- B . Central Management Console (CMC)
- C . Report map
- D . BI launch pad
What do you use to search for content in multiple documents?
- A . Central Configuration Manager (CCM)
- B . Central Management Console (CMC)
- C . Report map
- D . BI launch pad
What do you use to search for content in multiple documents?
- A . Central Configuration Manager (CCM)
- B . Central Management Console (CMC)
- C . Report map
- D . BI launch pad
Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?
- 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).
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?
- A . Sum
- B . Detail
- C . Measure
- D . Dimension
Which three layout options can you use when creating sections in a report? There are 3 correct answers to this question.
- A . Relative Position
- B . Start on New Page
- C . Keep Blocks Together
- D . Avoid Page Break in Section
Where is a variable saved?
- A . In the document
- B . In a category
- C . In a query
- D . In the universe
What happens when you create a section in a report? (2 answers)
- A . Blocks in the report are repeated for each section value.
- B . Page breaks are created to divide each section value
- C . Header and footer cells are created for each section value.
- D . Free-standing cells are created to label each section value.
Which of the following option is not a component of Web Intelligence Application Structure?
- A . Toolboxes
- B . The Left Panel
- C . The Expand panel
- D . The Status Bar
In which two situations should you use sub-queries? There are 2 correct answers to this question.
- A . When the query filter involves values that are known
- B . When the query filter involves values that are not known
- C . When the query filter for the report involves a value that will change over time
- D . When the query filter for the report involves a value that will never change over time
Which statement is a benefit of using a Web Intelligence formula?
- A . The formula can be reused in a document from the Data tab.
- B . The formula can be reused to create a variable.
- C . The formula can be saved into a new function.
- D . The formula can be saved and reused in a measure object.
Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?
- A . Web Intelligence
- B . InfoView Preferences
- C . Microsoft Excel File Options
- D . Web Intelligence Rich Client
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
Which method should you use to group query filters together to form one AND statement?
- 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
What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers)
- A . Analysis view
- B . XML files
- C . BEx Query
- D . Lumira Dataset
Which method can you use to build a custom sort?
- 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 function would you use to extract the word "casual" from the product name "casual
pants" of the Product Name field?
- A . Left(5; [Product Name])
- B . Left([Product Name]; 5)
- C . Right((Product Name), 5)
- D . Right(5, [Product Name])
You have two columns: order date and ship date .
How do you calculate the processing time from the order date to the ship date?
- A . Use the "daynumberofyear" function after subtracting both dates.
- B . Use the "daysbetween" function with order date and ship date.
- C . Use the "currentdate" function and subtract the ship date.
- D . Use the "isdate" function on both dates and subtract the dates.
To where can you copy a formula used in a document?
- A . To another block on a report
- B . To the Available Objects panel
- C . To a conditional formatting rule
- D . To the universe
When scheduling Web Intelligence document, what output formats are available? (2 answers)
- A . Microsoft PowerPoint (PPT)
- B . HyperText Markup Language (HTML)
- C . Adobe Acrobat (PDF)
- D . Plain Text (TXT)
Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence 4.0 report?
- A . The Scope of Analysis is empty.
- B . The Scope of Analysis is not empty.
- C . The query drill mode option is enabled.
- D . The query drill mode option is not enabled.
Which operators can be used in an Input calculation context? There are 2 correct answers to this question.
- A . Input
- B . ForAll
- C . ForEach
- D . In
Which of the following is not a step of demonstration, to display an aggregate within a sectioned report.
- 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
When using the ranking feature on a table, which expression allows you to display the total of all values (both ranked and unranked) in the footer of the block?
- A . NoFilter(Sum([measure]))
- B . Sum([measure) For Each [dimension])
- C . Sum([measure]) In Block
- D . RefValue(Sum([measure]))
Which of the following option is not a part of The Web Intelligence Query Process?
- A . Run the query
- B . Launch panel to generate data
- C . SQL is executed to extract data
- D . Report is displayed