SAP Caa - SAP Bo Web Intelligence Xi 3.X
-
Which three calculations can you use in a measure object in Web Intelligence? (Choose three.)
-
Min
-
Max
-
Count
-
Count All
-
SAP Certified Application Associate - SAP BusinessObjects Web Intelligence XI 3. X
Quiz Preview
- 2.
Which panel should you use to create sub-queries?
-
Data Panel
-
Query Panel
-
Report Panel
-
Slice and Dice Panel
Correct Answer
A. Query PanelExplanation
The correct answer is "Query Panel". The Query Panel is used to create sub-queries in order to retrieve specific data from a database. This panel allows users to define and customize their queries by selecting the desired fields, applying filters, and specifying sorting criteria. By using the Query Panel, users can create complex queries and retrieve the exact data they need for analysis or reporting purposes.Rate this question:
-
- 3.
How many blocks can you create in a Web Intelligence document (WID)?
-
1
-
2
-
4
-
8
-
Unlimited
Correct Answer
A. UnlimitedExplanation
There is no limit to the number of blocks that can be created in a Web Intelligence document. This means that users can create as many blocks as needed to organize and present their data effectively.Rate this question:
-
- 4.
Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
-
Pos([Category] , "" )
-
Pos((Category) , "" )
-
Pos([Category] ; " " )
-
Pos({Category} ; " " )
Correct Answer
A. Pos([Category] ; " " )Explanation
The correct answer is "Pos([Category] ; " " )". This syntax is using square brackets to reference the Category field and a semicolon to separate the field and the space character that we want to find the location of.Rate this question:
-
- 5.
In the creation of a document, you have to import a personal data file. The data file contains date information, but when the file is imported, the dates are imported as character strings. Which function should you use to change the format from string to date?
-
Date()
-
Char()
-
ToChar()
-
ToDate()
Correct Answer
A. ToDate()Explanation
The function "ToDate()" should be used to change the format from string to date. This function is specifically designed to convert character strings into date format.Rate this question:
-
- 6.
Which three object types can you use in a Web Intelligence universe query? (Choose three.)
-
Class
-
Detail
-
Measure
-
Dimension
-
User Defined
Correct Answer(s)
A. Detail
A. Measure
A. DimensionExplanation
In a Web Intelligence universe query, you can use three object types: Detail, Measure, and Dimension. Detail objects provide specific information about a data point, Measure objects perform calculations on data, and Dimension objects provide context or grouping for data analysis. These three object types allow users to retrieve and analyze data effectively in a Web Intelligence universe query.Rate this question:
-
- 7.
Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
-
Right(5; [Product Name])
-
Right([Product Name]; 5)
-
Right((Product Name), 5)
-
Right(5, [Product Name])
Correct Answer
A. Right([Product Name]; 5)Explanation
The correct answer is "Right([Product Name]; 5)". The Right function is used to extract a specified number of characters from the right side of a text string. In this case, it is used to extract the last 5 characters from the "Product Name" field, which would be the word "pants".Rate this question:
-
- 8.
Which three elements are parts of a query filter? (Choose three.)
-
Class
-
Object
-
Operator
-
Operand
Correct Answer(s)
A. Object
A. Operator
A. OperandExplanation
The three elements that are parts of a query filter are Object, Operator, and Operand. The Object refers to the attribute or field that is being filtered, the Operator defines the comparison or condition to be applied, and the Operand is the value or criteria that is used for the comparison. These three elements work together to specify the conditions that must be met in order for a query to return the desired results.Rate this question:
-
- 9.
Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?
-
Dimension - Detail
-
Measure - Measure
-
Dimension - Measure
-
Dimension - Dimension
Correct Answer
A. Dimension - DimensionExplanation
When using Multi Queries in a Web Intelligence document, you can merge objects of the same type, specifically Dimension - Dimension. This means that you can merge two dimensions together to create a combined result. Merging other object types such as Dimension - Detail, Measure - Measure, or Dimension - Measure is not possible in this scenario.Rate this question:
-
- 10.
Which three objects represent qualifications from a local data provider? (Choose three.)
-
BLOB
-
DATE
-
TEXT
-
NUMBER
Correct Answer(s)
A. DATE
A. TEXT
A. NUMBERExplanation
The three objects that represent qualifications from a local data provider are DATE, TEXT, and NUMBER. These are commonly used data types to represent qualifications in a database. DATE is used to store dates, TEXT is used to store textual data, and NUMBER is used to store numerical data. BLOB, on the other hand, is used to store large binary objects such as images or files and is not typically used to represent qualifications.Rate this question:
-
- 11.
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
Correct Answer
A. MeasureExplanation
To aggregate the number of cars sold by region in a report, you should use a "Measure" object. A Measure is used to perform calculations and aggregate data, such as summing up the number of cars sold. It allows you to apply mathematical operations to the data and provide meaningful insights by summarizing the information. Therefore, using a Measure object would be the appropriate choice in this scenario.Rate this question:
-
- 12.
Which BusinessObjects Enterprise tool supports Offline Mode logins?
-
InfoView
-
Java Panel
-
Interactive Panel
-
Web Intelligence Rich Client
Correct Answer
A. Web Intelligence Rich ClientExplanation
The Web Intelligence Rich Client supports Offline Mode logins in BusinessObjects Enterprise. This means that users can access and work with their reports and data even when they are not connected to the network or internet. The client allows users to download and save reports locally, and then access and modify them offline. Once the user reconnects to the network, any changes made offline can be synchronized with the server. This feature provides flexibility and convenience for users who need to access and work with their reports while on the go or in areas with limited connectivity.Rate this question:
-
- 13.
Where is a Web Intelligence variable stored?
-
In the cell
-
In the document
-
In the Metadata Cube
-
In the Central Management Server (CMS)
Correct Answer
A. In the documentExplanation
A Web Intelligence variable is stored in the document. This means that the variable is saved within the specific Web Intelligence document where it is created and can be accessed and used within that document only. It is not stored in the cell, Metadata Cube, or the Central Management Server (CMS).Rate this question:
-
- 14.
Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
-
Local Settings
-
Browser Preferences
-
User Machine Settings
-
InfoView Preferences
Correct Answer
A. InfoView PreferencesExplanation
In InfoView, the regional settings of a Web Intelligence document can be configured in the InfoView Preferences. This allows the user to set the desired regional settings for their specific needs, such as language, date format, currency, and number format. By configuring these settings in InfoView Preferences, the user ensures that the Web Intelligence document will be displayed according to their preferred regional settings.Rate this question:
-
- 15.
Which sort option should you use to add Temporary Values?
-
Ascending
-
Descending
-
Custom Sort
-
Adaptive Sort
Correct Answer
A. Custom SortExplanation
To add temporary values, you should use the "Custom Sort" option. This option allows you to manually define the order in which the values should be sorted. Unlike ascending or descending sort, which permanently rearrange the values, custom sort allows you to temporarily organize the values in a specific way without permanently altering their original order. This can be useful when you need to group or prioritize certain values for a specific purpose or analysis.Rate this question:
-
- 16.
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?
-
1.00
-
1.05
-
1.10
-
1.15
-
1.18
Correct Answer
A. 1.00Explanation
The formula contains multiple conditions to determine the rate applied to the sales revenue. However, none of these conditions match with the state "Florida". Therefore, the default rate of 1.00 is applied to the Florida revenue.Rate this question:
-
- 17.
Which type of relationship links sub-queries by default?
-
OR
-
AND
-
NOR
-
NAND
Correct Answer
A. ANDExplanation
The correct answer is AND because when sub-queries are linked using the AND operator, both conditions need to be true for the overall query to return a result. This means that the result set will only include records that satisfy both sub-queries.Rate this question:
-
- 18.
Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?
-
Left(5; [Product Name])
-
Left([Product Name]; 5)
-
Right((Product Name), 5)
-
Right(5, [Product Name])
Correct Answer
A. Left([Product Name]; 5)Explanation
The function "Left([Product Name]; 5)" would be used to extract the word "casual" from the product name "casual pants" of the Product Name field. This function takes the leftmost characters of a string, and in this case, it would take the first 5 characters of the product name.Rate this question:
-
- 19.
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"
Correct Answer
A. Right-click the table block and select "Turn To"Explanation
In Web Intelligence Rich Client, to convert a table block into a chart, you can right-click the table block and select "Turn To". This option allows you to transform the table block into a chart format.Rate this question:
-
- 20.
Which two operators are used as calculation context operators? (Choose two.)
-
In
-
Where
-
Select
-
Having
Correct Answer(s)
A. In
A. WhereExplanation
The operators "In" and "Where" are used as calculation context operators. The "In" operator is used to specify a set of values that a column must match in a query. The "Where" operator is used to filter the rows in a query based on a specified condition. Both operators are commonly used in SQL queries to manipulate and retrieve data from a database.Rate this question:
-
- 21.
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?
-
Detail
-
Measure
-
Dimension
-
Sum
Correct Answer
A. MeasureExplanation
To aggregate the number of cars sold by region, you should use the "Measure" object. Measures are used to calculate aggregated values based on the data in a dataset. In this case, you want to calculate the total number of cars sold, which is an aggregated value. Therefore, using the Measure object will allow you to perform the necessary calculations and summarize the data by region.Rate this question:
-
- 22.
For what purposes can you use the Page Layout of a report? Note: There are 2 correct answers to this question.
-
To display the definition of the block
-
To define how the report will look like in PDF mode
-
To define how the report will look like when printed.
-
To display the report page by default.
Correct Answer(s)
A. To define how the report will look like in PDF mode
A. To define how the report will look like when printed.Explanation
The Page Layout of a report can be used to define how the report will look like in PDF mode and when printed. It allows the user to customize the formatting and arrangement of the report elements specifically for these purposes.Rate this question:
-
- 23.
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
Correct Answer(s)
A. Page Number
A. Total Number of Pages
A. Page Number / Total PagesExplanation
The three default page number cells are "Page Number," "Total Number of Pages," and "Page Number / Total Pages." These options allow users to easily insert and display page numbers in a document. "Page Number" shows the current page number, "Total Number of Pages" displays the total number of pages in the document, and "Page Number / Total Pages" shows the current page number and the total number of pages in the document together.Rate this question:
-
- 24.
Which four authentication methods are available for Web intelligence Rich Client? (Choose four.)
-
AD
-
NT
-
LDAP
-
Vintella
-
Kerberos
-
Enterprise
Correct Answer(s)
A. AD
A. NT
A. LDAP
A. EnterpriseExplanation
The correct answer is AD, NT, LDAP, and Enterprise. These four authentication methods are available for Web Intelligence Rich Client. AD refers to Active Directory, which is a directory service provided by Microsoft. NT refers to Windows NT authentication, which is a legacy authentication method used by older versions of Windows. LDAP stands for Lightweight Directory Access Protocol and is a protocol used for accessing and managing directory information. Enterprise refers to the Enterprise authentication method, which is a custom authentication method specific to the organization's infrastructure. Vintella and Kerberos are not mentioned as available authentication methods for Web Intelligence Rich Client.Rate this question:
-
- 25.
Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source?
-
Crystal Reports
-
Desktop Intelligence
-
Web Intelligence in InfoView
-
Web Intelligence Rich Client
Correct Answer
A. Web Intelligence Rich ClientExplanation
The Web Intelligence Rich Client is the correct reporting tool to use in order to create a Web Intelligence document directly from an Excel data source. This tool allows users to easily connect to and import data from Excel files, and then create interactive and visually appealing reports using that data. The Web Intelligence Rich Client provides a user-friendly interface and a wide range of features and functionalities to efficiently analyze and present data from Excel sources.Rate this question:
-
- 26.
Which two are calculation context types?
-
Input
-
Output
-
Logical
-
Conditional
Correct Answer(s)
A. Input
A. OutputExplanation
The two calculation context types mentioned in the options are "Input" and "Output." These types refer to the different contexts in which calculations are performed. "Input" refers to the data or values that are provided as input for a calculation, while "Output" refers to the result or outcome of the calculation. These context types help in understanding and analyzing how calculations are performed and their relationship with the given input and resulting output.Rate this question:
-
- 27.
You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
-
The cell reads "Last Refresh Date: 1/22/08".
-
The "Computation Error" error message is displayed.
-
The "Incompatible Data Types" error message is displayed.
-
The cell reads "Last Refresh Date: {Tuesday, January 22, 2008}".
Correct Answer
A. The cell reads "Last Refresh Date: 1/22/08".Explanation
When you edit the formula using the Formula toolbar to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function, the result is that the cell reads "Last Refresh Date: 1/22/08".Rate this question:
-
- 28.
Which two break properties can you use when setting Break Priority? (Choose two.)
-
Order Breaks
-
Vertical Breaks
-
Crosstab Breaks
-
Horizontal Breaks
Correct Answer(s)
A. Vertical Breaks
A. Horizontal BreaksExplanation
Break properties are used to control the layout and organization of data in a report. When setting Break Priority, two break properties that can be used are Vertical Breaks and Horizontal Breaks. Vertical Breaks allow for grouping and organizing data vertically, typically by a specific field or category. Horizontal Breaks, on the other hand, group and organize data horizontally, often by time periods or intervals. By using these two break properties, the report can be structured in a way that effectively presents and summarizes the data based on the desired grouping and organization.Rate this question:
-
- 29.
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
Correct Answer(s)
A. Query
A. Report -
- 30.
You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
-
The cell reads "Last Refresh Date: 1/22/08".
-
The "Computation Error" error message is displayed.
-
The "Incompatible Data Types" error message is displayed.
-
The cell reads "Last Refresh Date: {Tuesday, January 22, 2008}".
Correct Answer
A. The cell reads "Last Refresh Date: 1/22/08".Explanation
When you edit the formula to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function, the result is that the cell reads "Last Refresh Date: 1/22/08".Rate this question:
-
- 31.
You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?
-
=RunningSum([Sales Revenue], Region)
-
=RunningTotal([Sales Revenue], Region)
-
=RunningSum([Sales Revenue] ; ([Region]))
-
=RunningTotal([Sales Revenue], Reset[Region])
Correct Answer
A. =RunningSum([Sales Revenue] ; ([Region]))Explanation
The correct syntax to accomplish the given task is =RunningSum([Sales Revenue] ; ([Region])). This syntax will calculate a running sum of the sales revenue, restarting the aggregation for each region.Rate this question:
-
- 32.
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
Correct Answer(s)
A. TXT
A. CSV
A. XLSExplanation
You can use TXT, CSV, and XLS files to create a BusinessObjects Web Intelligence XI 3.0 document. These file types are commonly used for storing and organizing data, and can be easily imported into the Web Intelligence tool for analysis and reporting purposes. XML files, on the other hand, are not mentioned as an option in the answer and therefore cannot be used to create a WID document.Rate this question:
-
- 33.
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
Correct Answer(s)
A. Top margin
A. Left margin
A. Page orientationExplanation
The given options are valid Page Layout Options in the Properties tab of a document. The top margin option allows the user to adjust the margin at the top of the page. The left margin option allows the user to adjust the margin on the left side of the page. The page orientation option allows the user to choose between portrait or landscape orientation for the page layout. These options are commonly found in document editing software and are essential for customizing the layout and formatting of a document.Rate this question:
-
- 34.
Where are formulas stored when created in Web Intelligence?
-
In the universe
-
On the report page
-
In the Central Management Server (CMS) database
-
In the metadata of the Cube
Correct Answer
A. On the report pageExplanation
When formulas are created in Web Intelligence, they are stored on the report page. This means that the formulas are saved within the specific report document where they were created. They are not stored in the universe, the Central Management Server (CMS) database, or the metadata of the Cube. The report page serves as the container for all the formulas and allows users to access and use them within the context of the report.Rate this question:
-
- 35.
Which two statements are true about Page Layout of a report? (Choose two.)
-
It displays the definition of the block.
-
It displays the report page by default.
-
It defines what the report will look like when printed.
-
It defines what the report will look like in PDF mode.
Correct Answer(s)
A. It defines what the report will look like when printed.
A. It defines what the report will look like in PDF mode.Explanation
The two true statements about Page Layout of a report are that it defines what the report will look like when printed and it defines what the report will look like in PDF mode. The page layout determines the formatting, arrangement, and appearance of the report when it is printed or viewed in PDF format. It includes settings such as page size, margins, headers, footers, and the placement of report elements.Rate this question:
-
- 36.
Which statement describes a Web Intelligence variable?
-
A variable is a function with a name that can be modified.
-
A variable is a universe object that can be modified.
-
A variable is a formula with a name stored in the document.
-
A variable is a formula with a name stored in the query.
Correct Answer
A. A variable is a formula with a name stored in the document.Explanation
A Web Intelligence variable is a formula that is given a name and stored within the document. It allows users to create custom calculations or manipulate data within the document. This statement accurately describes a Web Intelligence variable.Rate this question:
-
- 37.
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?
-
=[Revenue]/RefValue([Revenue])
-
=[Revenue]/PreValue([Revenue])
-
=[Revenue]/HistValue([Revenue])
-
=[Revenue]/BaseValue([Revenue])
Correct Answer
A. =[Revenue]/RefValue([Revenue])Explanation
The formula =[Revenue]/RefValue([Revenue]) should be used to display the variance value of the Revenue measure in the document when data tracking is active. This formula divides the current revenue value by the reference value of revenue, which allows for a comparison and calculation of the variance.Rate this question:
-
- 38.
Where are contexts created?
-
In a report
-
In a universe
-
In a derived table
-
At the database level
Correct Answer
A. In a universeExplanation
Contexts are created in a universe. A universe is a semantic layer that sits between the database and the end-user reporting tool. It acts as a bridge, allowing users to access data from the database in a more user-friendly manner. Contexts in a universe are used to define conditions or filters that restrict the data returned in a query. By creating contexts in a universe, users can control and manipulate the data that is presented to them in their reports.Rate this question:
-
- 39.
You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked data. You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?
-
Contact the system administrator.
-
Edit the document in tracking mode.
-
Open the document in tracking mode.
-
Resave the document with data tracking formats enabled.
Correct Answer
A. Contact the system administrator. -
- 40.
Which options can you select when you save a Web Intelligence document (WID)? Note: There are 2 correct answers to this question.
-
Refresh on open
-
Associate universe
-
Permanent regional formatting
-
Send to users
Correct Answer(s)
A. Refresh on open
A. Permanent regional formattingExplanation
When saving a Web Intelligence document, you can select the options "Refresh on open" and "Permanent regional formatting". The "Refresh on open" option ensures that the data in the document is updated every time it is opened. The "Permanent regional formatting" option allows the document to retain its formatting based on the regional settings of the user, even if the document is opened on a different machine or in a different location.Rate this question:
-
- 41.
Which two options should you take before you finish creating a variable in Web Intelligence? (Choose two.)
-
Save
-
Parse
-
Export
-
Validate
Correct Answer(s)
A. Save
A. ValidateExplanation
Before finishing creating a variable in Web Intelligence, it is important to save the variable to ensure that any changes made are not lost. Additionally, validating the variable is necessary to check for any errors or inconsistencies in the formula or logic used. Therefore, the correct options to take before finishing creating a variable in Web Intelligence are to save and validate.Rate this question:
-
- 42.
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
Correct Answer(s)
A. LDAP
A. EnterpriseExplanation
LDAP and Enterprise are the two Web Intelligence Rich Client authentication methods that enable the export of Web Intelligence documents (WID) to the Central Management Server (CMS). LDAP (Lightweight Directory Access Protocol) is a protocol used to access and manage directory information, including user authentication. Enterprise authentication method allows users to authenticate using their enterprise credentials, such as Active Directory or SAP authentication. Both of these methods provide the necessary authentication for exporting WID to the CMS.Rate this question:
-
- 43.
Which method should you use to activate "Interactive Viewing"?
-
Preferences in Web Intelligence
-
Preferences in InfoView
-
In the Document Properties
-
In the Report Properties
Correct Answer
A. Preferences in InfoViewExplanation
To activate "Interactive Viewing," you should use the method of accessing Preferences in InfoView. This suggests that within the InfoView interface, there is a specific section or option labeled "Preferences" where you can enable the "Interactive Viewing" feature.Rate this question:
-
- 44.
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.
Correct Answer(s)
A. Dimension value formats must be the same.
A. Dimensions with different names can be merged.
A. Dimensions from multiple data sources can be merged.Explanation
When manually synchronizing queries, there are three rules that apply. First, the dimension value formats must be the same, meaning that the values representing the dimensions should be in the same format across all queries. Second, dimensions with different names can be merged, allowing for consolidation and alignment of data. Lastly, dimensions from multiple data sources can be merged, enabling the combination of data from different sources into a single query.Rate this question:
-
- 45.
Which three statements are true about alerters? (Choose three.)
-
You can apply alerters to charts.
-
You can apply multiple alerters to one block.
-
You can apply the same alerter to multiple blocks.
-
You can control the order in which alerters are applied.
Correct Answer(s)
A. You can apply multiple alerters to one block.
A. You can apply the same alerter to multiple blocks.
A. You can control the order in which alerters are applied.Explanation
Alerters can be applied to charts, multiple alerters can be applied to one block, the same alerter can be applied to multiple blocks, and the order in which alerters are applied can be controlled.Rate this question:
-
- 46.
Which three methods can you use to combine queries using the Web Intelligence Rich Client? (Choose three.)
-
UNION
-
MINUS
-
UNION ALL
-
INTERSECT
Correct Answer(s)
A. UNION
A. MINUS
A. INTERSECTExplanation
The correct answer is UNION, MINUS, INTERSECT. These are three methods that can be used to combine queries using the Web Intelligence Rich Client. UNION is used to combine the results of two or more queries into a single result set, MINUS is used to retrieve the records that are in the first query but not in the second query, and INTERSECT is used to retrieve the records that are common to both queries.Rate this question:
-
- 47.
Which Report Manager tab should you use to add a free-standing cell to a BusinessObjects Web Intelligence XI 3.0 document (WID)?
-
Map
-
Data
-
Template
-
Properties
Correct Answer
A. TemplateExplanation
To add a free-standing cell to a BusinessObjects Web Intelligence XI 3.0 document (WID), you should use the Template tab in the Report Manager. This tab allows you to create and customize templates for your reports, including adding free-standing cells.Rate this question:
-
- 48.
Which method can you use to hide data using an alerter?
-
Build an alerter that removes the column.
-
Build an alerter that applies a formula that changes the block value.
-
Build an alerter with a formula that changes the font color to the background color.
-
Click anywhere in the document. On the toolbar, click the "Data" button and select "Hide Data".
Correct Answer
A. Build an alerter with a formula that changes the font color to the background color. -
- 49.
Which Report Manager tab should you use to change report formatting?
-
Map
-
Data
-
Properties
-
Templates
Correct Answer
A. PropertiesExplanation
To change report formatting, you should use the "Properties" tab in the Report Manager. This tab allows you to modify various properties of the report, such as the layout, style, and appearance. By accessing the Properties tab, you can make adjustments to the report's formatting to meet your specific requirements or preferences.Rate this question:
-
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
May 05, 2011Quiz Created by
CRTH