C_BOWI_40 Exam Questions
160 real C_BOWI_40 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #51Creating Documents with Queries
Which two are benefits of creating queries from existing queries?
query duplicationquery parametersreport creation efficiency - Question #52Reporting
You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the...
data trackingquery drill modescope of analysistrack changes - Question #53Using Formulas and Variables
Which statement describes a benefit of using the NoFilter() function?
NoFilter() functionreport rankingfilter override - Question #54Creating Documents with Queries
Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel?
query propertiessample optionfixed optionquery panel - Question #55Restricting Data with Query Filters
Which type of relationship links sub-queries by default?
sub-queriesAND relationshipquery linkingdefault behavior - Question #56Working with Data
Which three are prerequisites for combining data from multiple data providers?
multiple data providersdata mergingdimension linkingcommon format - Question #57Introduction to Web Intelligence
Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
regional settingsInfoView preferencesdocument configuration - Question #58Using Formulas and Variables
Which three statements are true of calculation contexts?
calculation contextsForEach operatordefault contextWhere keyword - Question #59Working with Data
Which two statements are true of grouping sets when using smart measures?
smart measuresgrouping setsSQL aggregationmeasure aggregation - Question #60Creating Interactive Reports
Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence 4.0?
Interactive View modesortfiltersformat cell - Question #61Introduction to Web Intelligence
Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source?
Web Intelligence Rich ClientExcel data sourceWID creationreporting tools - Question #62Using Formulas and Variables
You are using calculation contexts within an If() function. Which two are valid contexts for use in an If() function?
calculation contextsIf() functionIn BlockIn Report - Question #63Using Formulas and Variables
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 custo...
NoFilter()rankingaggregate functionscalculation context - Question #64Creating Interactive Reports
Which is a benefit of using query drill?
query drillSQL generationdrill modesdata retrieval - Question #65Restricting Data with Query Filters
Which two operators are available when using wildcards in a query filter?
wildcard operatorsMatches PatternDifferent from Patternquery filters - Question #66Working with Data
Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x?
merged objectsData tabReport Managerobject management - Question #67Using Formulas and Variables
Which keyword is defined as flexible for input contexts?
ForEach keywordinput contextscalculation contextscontext operators - Question #68Formatting
Which two are benefits of using breaks?
breakssubtotalstable formattingblock structure - Question #69Using Formulas and Variables
Which Web Intelligence component should you use to list the existing variables in a report?
Report Managervariables listVariable Editorreport components - Question #70Working with Data
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. Wh...
data trackingtracked changesdocument permissionsformatting restrictions - Question #71Formatting
Which tasks can you accomplish using breaks?
breaksrepeated valuessubtotalstable block - Question #72Formatting
Which method can you use to hide data using an alerter?
alertershiding datafont colorconditional formatting - Question #73Formatting
Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?
table to chart conversionRich ClientTurn Toblock types - Question #74Sharing Documents
Which two statements are correct about saving documents?
document storagefolderscategoriessaving documents - Question #75Using Formulas and Variables
Which two operators are used as calculation context operators?
calculation context operatorsIn operatorWhere operatorformula syntax - Question #76Introduction to Web Intelligence
Which BusinessObjects Enterprise tool supports Offline Mode logins?
Offline ModeRich ClientBusinessObjects Enterpriseclient tools - Question #77Using Formulas and Variables
Which three statements about the If() function are correct?
If() functionaggregate functionsThen/Else keywordsvariable creation - Question #78Introduction to Web Intelligence
How many blocks can you create in a Web Intelligence document (WID)?
blocksdocument structureWID limitsreport layout - Question #79Creating Interactive Reports
Which three are drill options?
drill optionsdrill toolbarsynchronize drilldrill configuration - Question #80Reporting
Which method should you use to see report filters?
report filtersFilter Panetoolbarfilter visibility - Question #81Creating Documents with Queries
Which panel should you use to create sub-queries?
sub-queriesQuery Panelquery creation - Question #82Creating Documents with Queries
Why would you need to change the data source for your query?
data sourceuniverse connectiontest vs production universe - Question #83Sharing Documents
Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?
InfoView Preferencesexport optionsExcel exportdocument saving - Question #84Using Formulas and Variables
Which operators can be used in an Input calculation context?
calculation contextInput contextForEach operatorIn operator - Question #85Working with Data
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?
data trackingdocument sizedata change history - Question #86Reporting
Your report contains a table. What happens when you drop a dimension object into a blank part of this report?
drag and dropdimension objectsblock creationreport layout - Question #87Introduction to Web Intelligence
Which three can you use to start the Web Intelligence Rich Client from?
Rich Clientlaunch methodsInfoViewcommand line - Question #88Formatting
Which property do you enable to keep rows in a break together on the same page?
page breaksbreak formattingblock propertiesavoid page break - Question #89Sharing Documents
You are working in the Web Intelligence Rich Client. Which two file formats can you save a document in?
Rich Clientfile formatsXLS exportPDF export - Question #90Using Formulas and Variables
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...
If-Then-Elseformula evaluationconditional logicnested conditions - Question #91Creating Interactive Reports
Which method should you use to view alerts in a report?
alertersreport toolbaralert management - Question #92Reporting
How can you see general report information such as the document author and the document creation date?
Document Summarydocument propertiesreport metadatadocument author - Question #93Working with Data
Which method should you use to activate data tracking?
data trackingtrack buttontoolbardata changes - Question #94Working with Data
Which three rules apply when you manually synchronize queries?
query synchronizationmerge dimensionsmultiple data sourcesdimension rules - Question #95Creating Interactive Reports
Which message appears when you select "Use query drill" while Scope of Analysis is set in aBusinessObjects Web Intelligence 4.0 report?
query drillscope of analysisdrill modeinteractive drill - Question #96Working with Data
Which two are limitations of a detail object?
detail objectsobject limitationsdrillmerge dimensions - Question #97Creating Documents with Queries
Which two data sources can you directly access from a Web Intelligence document (WID) using the Web Intelligence Rich Client?
data sourcesRich Clientuniversetext file - Question #98Creating Documents with Queries
You have created a BusinessObjects Web Intelligence 4.0 document (WID) within InfoView that has a single table block on a single report page. Where will a new object be displayed w...
Report Managerquery objectsdocument structureadding objects - Question #99Restricting Data with Query Filters
Which two search criteria are valid when using Delegated List of Values?
Delegated List of Valuessearch criteriawildcard charactersquery filters - Question #100Restricting Data with Query Filters
Which methods can you use to apply report filters to a BusinessObjects Web Intelligence XI 4.x document (WID)?
report filtersfilter scopeglobal filterblock filter