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.
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)- A3% (1)
- B91% (32)
- C6% (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.
The universe stores the semantic layer - dimensions, measures, filters, and joins - defined by the designer, not report-level formula expressions created by end users.
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.
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.
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
Community Discussion
No community discussion yet for this question.