C_BW4HANA_27 · Question #1
You create a Datastore Object (advanced) using the "data mart DataStore object" modeling property. Which behaviors are specific to this modeling property? (2)
The correct answer is A. Reporting is done based on a union of the inbound and active tables D. All characteristics are automatically defined as key. Selecting the "data mart" modeling property for a DataStore Object (advanced) in SAP BW/4HANA creates a DSO optimized for reporting and distribution. Option A is correct because the data mart DSO exposes data for reporting via a union of both the inbound (not-yet-activated) and…
Question
You create a Datastore Object (advanced) using the "data mart DataStore object" modeling property. Which behaviors are specific to this modeling property? (2)
Options
- AReporting is done based on a union of the inbound and active tables
- BThe change log table Will only by filled after activation
- CQuery results are only shown when data has been activated
- DAll characteristics are automatically defined as key
How the community answered
(42 responses)- A93% (39)
- B5% (2)
- C2% (1)
Explanation
Selecting the "data mart" modeling property for a DataStore Object (advanced) in SAP BW/4HANA creates a DSO optimized for reporting and distribution. Option A is correct because the data mart DSO exposes data for reporting via a union of both the inbound (not-yet-activated) and active tables, meaning data is immediately visible without waiting for activation. Option D is correct because this modeling property automatically designates all characteristics as key fields - a defining structural behavior that distinguishes it from other DSO types where you manually assign key vs. data fields.
Option B is wrong because filling the change log only after activation describes standard DSO behavior, not something unique to the data mart property. Option C is wrong because it directly contradicts A - the data mart DSO is specifically designed to make data available before activation via the union, so restricting query results to activated data only would defeat its purpose.
Memory tip: Think "data mart = market stall open all day" - goods (data) are on display from the moment they arrive (inbound), not just after the stockroom is organized (activation). Also remember: all characteristics = all keys in data mart, no exceptions.
Topics
Community Discussion
No community discussion yet for this question.