6.1 Discussing Data Modelling Flashcards
(38 cards)
What are the 2 styles of models
Planning model
Analytics model
Planning model dimensions, preconfig and offered
- Preconfigured with Time and version dimensions
- offer multi currency on model and dim level
Planning model write back capaiblities
- users w/ planning privileges can create own version of model
- users can write data to the model
Analytics model (3) differences from planning model
- does not support categories
- doesn’t require time dim
- read only
SAC Datasources for stories (3)
Datasets
Planning models
Analytics models
Datasets can be live under these two conditions
- only for HANA
- only used for Smart Predict, not for stories
What are the 2 viewing options for a data model
- structured view
- data foundation view
What does a structure view show you?
- star schema
- dimension box (version, date shows hierarchy)
How do you add a new dimension or existing dimension to your model
- toolbar
- schema view
What does the data foundation view show you
- fact table that has transactions
- in planning can switch between different public versions of the data
Main difference between old model and new model
Old: only 1 measure column in transaction, so relied on accounts to describe values (rev, cost, admin)
New: allows multiple data columns. Not all modelling features supported yet in the new model.
Classic account models can be converted to new model.
Benefits of the new model - describe the flexible model structure benefit
Flexible model structure - both accounts and measures are available as structures, so data can be displayed more precise. EG:
- aggregate over a measure instead of account
- explicit data types - measures can be integers or decimals
- disaggregation of data for measures - with integers, distribute entire value but avoid decimals
Benefits of the new model - describe the optional account dimension
When using measures, you can add accounts to a generic dimension instead of an account dimension
Benefits of the new model - describe improved calculations
- calculated measures in models that can be used across stories, apps, etc.
- calcs on numeric dim properties: flip signs on account values based on dim properties (eg, show expenses as positive)
Benefits of the new model - describe enhanced currency features
- add multiple base currency measures and add currency conversion on top of them
- plan based on any base or conversion measure, and see results across dependent currencies immediate.
- apply currency conversion while copying data from a base measure
Benefits of the new model - describe data integration
- the way a measure is set up is very similar to in HANA/BW/etc, so you don’t have to apply as many transformations from the source
Benefits of the new model - describe clearer terminology in charts and tables
because non-fin data is removed from members of the account dim (aka no longer see them in the measures), charts will be easier for non-fin people to use
Limitations of the new model - account/measure based formulas and calcs
- link formula between models not supported. use LINK function instead
- time dependent formulas (YoY) can’t be used with measures
- can’t do cross model copying between classic and new model. instead use LINK function
Limitations of the new model - stories and apps
- no blending when there’s an account dim
- no table threshold when there’s an account dim
- no geo maps
- can’t copy/paste data between currency measures
- measures only sorted via Edit Member Order
- Stores created on old account are not migrated, must be adjusted
Limitations of the new model - import of data
- dim members must exist first in the modeler before you import fact data, or import data to a global dimension
- any models created from cvs/excel file or data source are still created as classic account models
Limitations of the new model - integration with Microsoft office
- default currency for currency variables must be set
- if you migrate a classic model used in workbook to new model, you need to re-insert the model with existing workbook created with SAC add-in for MS
- cannot use new model with AFO edition for SAC
Old model - how measures work (2)
- values stored in 1 measures
- and use account structure to add calcs, units, aggregations
New model - how measures work (2)
- measures are single entities
- you can configure multiple measure with aggregation and units (instead of just 1)
SAC dimension types (public vs private)
- private (model specific, copied with model if it is coped/deleted)
- public (shared by several models)
