nerdexam
SAP

C_BOWI_40 · Question #111

Where are formulas stored when created in Web Intelligence?

The correct answer is B. On the report page. Formulas created in Web Intelligence are stored directly on the report page as part of the document itself, not in any external server-side store.

Using Formulas and Variables

Question

Where are formulas stored when created in Web Intelligence?

Options

  • AIn the universe
  • BOn the report page
  • CIn the Central Management Server (CMS) database
  • DIn the metadata of the Cube

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    91% (32)
  • C
    6% (2)

Why each option

Formulas created in Web Intelligence are stored directly on the report page as part of the document itself, not in any external server-side store.

AIn the universe

The universe stores the semantic layer - dimensions, measures, filters, and joins - defined by the designer, not report-level formula expressions created by end users.

BOn the report pageCorrect

Web Intelligence formulas are report-level objects embedded in the .wid document structure and associated with the specific report page cell or block where they are defined. They are not persisted outside the document, meaning they travel with the document when it is saved or exported, and are not accessible or shared across other documents.

CIn the Central Management Server (CMS) database

The CMS database stores platform metadata such as document properties, user accounts, and security assignments, but does not store the formula logic embedded inside a report.

DIn the metadata of the Cube

Cube metadata pertains to OLAP data source connection structures and does not store Web Intelligence report formulas.

Concept tested: Web Intelligence formula storage location within documents

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

Topics

#formulas#storage#report page

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice