MoneyTalkswith SS
Back to Foundations
Architecture

Data Storage Properties: Store vs. Dynamic Calc vs. Shared

Choosing the right storage property is how an Architect balances Speed vs. Space.

1. The Definitions

* Store: Data is physically saved on the disk. Use this for data you "load."

* Dynamic Calc: Data is not saved. Calculated "on the fly." Saves space but uses CPU.

* Dynamic Calc and Store: Calculates once, then saves the result in the block for next time.

* Shared Member: A "mirror" of another member to avoid doubling storage.

* Never Share: Prevents "Implied Shares" between a parent and its only child.

* Label Only: A "dummy" member acting purely as a folder heading.


2. The "Library" Example

* Store (The Physical Book): Actual book on the shelf.

* Dynamic Calc (The Librarian’s Answer): Counting students only when asked.

* Dynamic Calc and Store (The Post-it Note): Librarian counts once and writes it on a note for later.

* Shared Member (The QR Code): A link in the "History" section pointing to a book in "Science."

* Never Share (The Private Collection): Forcing the shelf and the single book on it to be treated as different items.


3. Practical Application

* Never Share: Essential for loading data to parents in FCCS with only one child.

* Dynamic Calc: Best for the Time dimension (Months -> Quarter -> Year).

Ready for the next lesson?

Continue your journey toward becoming an EPM Architect.

Back to Catalog