Free SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.3 Exam C_BOWI_43 Exam Practice Test

Elucidate the advantages of saving formulas as variables?Please choose the correct answer.Response:

• Use as options available in the Format and Report Element toolboxes
  
• You can reuse the formula without having to enter it each time
  
• Create the formulas and feed it with all its dimensions
  
• Use variables in any report within the document
  

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.Response:

• The Padding options at single level of your document
  
• The Format options at various levels of your document
  
• The Page break options at various levels of your document
  
• The Format options at single level of your document
  

Discuss all the advantages link to organizing a report in the sectionThere are 2 correct answers to this questionResponse:

• You can have multiple blocks projected from the same microcube within a single report, all sub-grouped to the sectioned level
  
• You can have single block projected from the same microcube within a single report, all grouped to the sectioned level
  
• You can insert subtotal cells, repeated in each section, which are created by the simple process of drag and drop
  
• You can insert tables, different in each section, which are created by the simple process of drag and drop
  

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, 2014. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string 'Last Refresh Date: ' and the LastExecutiondate() function?Please choose the correct answer.Response:

• The cell reads 'Last Refresh Date: 1/22/14'.
  
• The 'Computation Error' error message is displayed.
  
• The 'Incompatible Data Types' error message is displayed.
  
• The cell reads 'Last Refresh Date: {Tuesday, January 22, 2014}'.
  

You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table?

• Apply a break
  
• Section the report
  
• Insert a blank cell
  
• Format the table
  

Which of the following is not a rule to apply on the report elements?Please choose the correct answer.Response:

• Columns in vertical tables
  
• Rows in horizontal tables
  
• Cells in conditional tables
  
• Cells in forms and cross tables
  

Which two properties can you set in the hyperlink dialog box when you create a hyperlink to a document?There are 2 correct answers to this question.Response:

• Refresh on open
  
• Color and font style for the link
  
• Drill level for the target document
  
• Link to a specific area in the document
  

Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x?Please choose the correct answer.Response:

• Report Properties tab
  
• Data tab
  
• Navigation tab
  
• Object Properties tab
  

You are creating a 'Target Revenue Based on Required % Growth' variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid?Please choose the correct answer.Response:

• =If[State] = 'California' Then [Sales revenue] * 1.05 Else[State] = 'Massachusetts' Then [Sales revenue] * 1.18 Else [Sales revenue]
  
• =If[State] = 'California' Then [Sales revenue] * 1.05 ElseIf[State] = 'Massachusetts' Then [Sales revenue] * 1.18 Else [Sales revenue]
  
• =If[State] = 'California' ; [Sales revenue] * 1.05 ElseIf[State] = 'Massachusetts' Then [Sales revenue] * 1.18 Else [Sales revenue]
  
• =If[State] = 'California' Then [Sales revenue] * 1.05 ElseIf[State] = 'Massachusetts' Then [Sales revenue] * 1.18 Else [Sales revenue] End
  

You want to force the calculation context of a variable in a table so that its values do not change when a dimension is added to the table. Which of the following statements is correct?Please choose the correct answer.Response:

• You include the dimension using the input context.
  
• You exclude the dimension using the input context.
  
• You include the dimension using the output context.
  
• You exclude the dimension using the output context.