nerdexam
SAP

C_BOWI_40 · Question #158

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, 2012. What is the result when you edit the…

The correct answer is A. The cell reads "Last Refresh Date: 1/22/12". Editing a cell formula via the Formula toolbar to use string concatenation with LastExecutionDate() overrides any previously applied cell formatting, causing the date to render in its default short format.

Using Formulas and Variables

Question

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, 2012. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?

Options

  • AThe cell reads "Last Refresh Date: 1/22/12".
  • BThe "Computation Error" error message is displayed.
  • CThe "Incompatible Data Types" error message is displayed.
  • DThe cell reads "Last Refresh Date: {Tuesday, January 22, 2012}".

How the community answered

(27 responses)
  • A
    70% (19)
  • B
    4% (1)
  • C
    7% (2)
  • D
    19% (5)

Why each option

Editing a cell formula via the Formula toolbar to use string concatenation with LastExecutionDate() overrides any previously applied cell formatting, causing the date to render in its default short format.

AThe cell reads "Last Refresh Date: 1/22/12".Correct

When you directly edit the formula using the Formula toolbar to concatenate a string literal with the LastExecutionDate() function, the explicit formula takes precedence over the custom date format applied to the cell. The date value returned by LastExecutionDate() is implicitly converted to a string in its default short date format (1/22/12), discarding the 'Tuesday, January 22, 2012' formatting that was set on the cell.

BThe "Computation Error" error message is displayed.

A 'Computation Error' is triggered by invalid mathematical operations or unresolvable calculations, not by string concatenation with a date function, which is a supported operation.

CThe "Incompatible Data Types" error message is displayed.

An 'Incompatible Data Types' error occurs when types cannot be reconciled at all, but Web Intelligence performs implicit type conversion when concatenating a string with the output of a date function.

DThe cell reads "Last Refresh Date: {Tuesday, January 22, 2012}".

Web Intelligence does not wrap date values in double curly braces when rendering concatenated formula output; the date is converted to its default short string representation instead.

Concept tested: Formula toolbar concatenation overriding cell date format

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/SAP_BusinessObjects_Web_Intelligence_User_Guide

Topics

#LastExecutionDate()#string concatenation#date formatting#formula behavior

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice