C_BOWI_40 Exam Questions
160 real C_BOWI_40 exam questions with expert-verified answers and explanations. Page 1 of 4.
- Question #1Creating Documents with Queries
Which three types of local data files can you use to create a BusinessObjects Web Intelligence 4.0 document (WID)?
local data filesfile formatsWID documentdata sources - Question #2Introduction to Web Intelligence
Which two personal folders are available by default to Web Intelligence users?
personal foldersInboxMy FavoritesInfoView navigation - Question #3Using Formulas and Variables
Which two are calculation context types?
calculation contextinput contextoutput contextformula context types - Question #4Working with Data
Where do you view merged dimensions?
merged dimensionsAvailable Objects panedata synchronizationReport Manager - Question #5Working with Data
What is the default behavior when creating a report from two queries from the same universe?
multiple queriesdimension mergingsame universedefault behavior - Question #6Using Formulas and Variables
Where is a Web Intelligence variable stored?
variablesdocument storageWeb Intelligence variablesvariable scope - Question #7Sharing Documents
To which destinations can you send a Web Intelligence document (WID) through InfoView ofBusinessObjects Web Intelligence XI 4.0?
document distributionInfoViewsending destinationspublication - Question #8Creating Documents with Queries
How do you duplicate a query?
duplicate queryQuery Panelquery managementquery tab - Question #9Sharing Documents
Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)?
Rich Client authenticationCMS exportLDAPEnterprise authentication - Question #10Using Formulas and Variables
Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
Right functionstring functionsformula syntaxtext extraction - Question #11Using Formulas and Variables
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 sh...
ForAll operatoroutput contextcalculation contextdimension exclusion - Question #12Introduction to Web Intelligence
Which data sources can you access directly using Web Intelligence?
data sourcesBEx queriesdirect accessOLAP - Question #13Reporting
Which two options can you change when using Quick Display Mode?
Quick Display Moderecords per pagedisplay settingspage layout - Question #14Creating Interactive Reports
Which method should you use to activate "Interactive Viewing"?
Interactive ViewingInfoView preferencesviewing modeinteractive reports - Question #15Formatting
Which three options are valid Page Layout Options in the Properties tab of a document?
page layoutdocument propertiesmarginspage orientation - Question #16Formatting
Which two break properties can you use when setting Break Priority?
break priorityvertical breakshorizontal breaksreport breaks - Question #17Restricting Data with Query Filters
Which method should you use to group query filters together to form one AND statement?
query filtersAND operatorfilter groupingfilter conditions - Question #18Formatting
Which three layout options can you use when creating sections in a report?
sectionslayout optionspage breakrelative position - Question #19Reporting
Which two methods can you use to define document properties?
document propertiesreport tabReport Managerdocument settings - Question #20Using Formulas and Variables
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...
CurrentDate functionstring concatenationnumber formattingformula cell behavior - Question #21Using Formulas and Variables
Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?
DaysBetween functiondate functionsformula syntaxCurrentDate - Question #22Using Formulas and Variables
Which character should you use to reset the result of the RunningSum( ) function for either a break or a section?
RunningSum functionbreak resetsection resetformula syntax - Question #23Working with Data
Which two panels can you use to purge data from a BusinessObjects Web Intelligence 4.0 document (WID)?
purge dataQuery panelReport paneldocument management - Question #24Formatting
Which two statements are true about Page Layout of a report?
page layoutprint settingsPDF modereport view - Question #25Working with Data
Where in Web Intelligence do you view merged dimensions?
merged dimensionsAvailable Objects panelmulti-querydata synchronization - Question #26Working with Data
You try to select a number of data objects from the Data tab to drag into a report, but some of them are grayed out and in italics. Which statement explains this behavior?
data synchronizationmulti-querygrayed out objectsobject availability - Question #27Creating Documents with Queries
How does rearranging the objects in the Result pane after the query has run affect the block display?
Result Objects paneblock displayquery panelobject order - Question #28Creating Documents with Queries
Which three options appear in the Scope of Analysis pane in the Query panel?
scope of analysisquery paneldrill hierarchyanalysis levels - Question #29Creating Documents with Queries
Which two statements are true of an ambiguous query?
ambiguous querycontext resolutionloopquery design - Question #30Using Formulas and Variables
Which statement is true of the Where operator when used within a variable?
Where operatorvariable calculationformula contextmeasure restriction - Question #31Using Formulas and Variables
Which statement describes a Web Intelligence variable?
variable definitionnamed formuladocument storageformula - Question #32Creating Interactive Reports
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?
drill optionsscope of analysisdrill outside scopeadditional data prompt - Question #33Restricting Data with Query Filters
Where do you set the "Optional prompt" option in Web Intelligence Rich Client?
optional promptquery panelRich Clientprompt configuration - Question #34Using Formulas and Variables
Which two statements are true about using the Where operator with an output context?
Where operatoroutput contextBoolean operatorsmeasure calculation - Question #35Reporting
Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence 4.0?
section headermeasure aggregationdrag and dropsection level - Question #36Introduction to Web Intelligence
Where are contexts created?
contextsuniverse designambiguous query resolutionsemantic layer - Question #37Working with Data
Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?
merge dimensionsmulti-querydimension objectsdata synchronization - Question #38Using Formulas and Variables
You want to force the calculation context for a variable in a large report with many dimensions. Which operator allows you to add a dimension to the default context?
ForEach operatorcalculation contextextended syntaxdimension context - Question #39Using Formulas and Variables
Which two functions could you use to concatenate the First Name and Last Name objects?
concatenationstring functionsformula syntaxtext operators - Question #40Formatting
For what purposes can you use the Page Layout of a report?
page layoutPDF modeprint settingsreport formatting - Question #41Introduction to Web Intelligence
Where can you set the default universe when using Web Intelligence within InfoView?
InfoView preferencesdefault universeuser settings - Question #42Working with Data
Which three objects represent qualifications from a local data provider?
local data providerobject qualificationsdata typesDATE TEXT NUMBER - Question #43Creating Documents with Queries
Which three object types can you use in a Web Intelligence universe query?
universe objectsdimensionmeasuredetail - Question #44Using Formulas and Variables
Which two options should you take before you finish creating a variable in Web Intelligence?
variable creationvalidatesaveworkflow - Question #45Using Formulas and Variables
Which statement is true about calculation contexts?
calculation contextsdata aggregationvariables - Question #46Using Formulas and Variables
You want to force the calculation context of a variable in a table so thatits values do not change when adimension is added to the table. Which of the following statements is corre...
output contextcalculation contextdimension exclusioncontext operators - Question #47Using Formulas and Variables
Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
Pos() functionstring functionssyntaxcharacter position - Question #48Using Formulas and Variables
Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?
string concatenationLeftPad()Concatenate()string functions - Question #49Using Formulas and Variables
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 rese...
RunningSumrunning aggregationreset contextsections - Question #50Using Formulas and Variables
You are reviewing a report with the following statement in a variable: =If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Ave...
If Then Elseconditional logiclogic gapsvariable analysis