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)
-
Unit 1 Lesson 144
-
Unit 2.1 Explaining Data Sources and Connections12
-
Unit 3.1 Building Stories21
-
Unit 3.2 Config Charts & Tables + 3.3 Conditional Formatting19
-
DNU Unit 3 Lesson 4 + 520
-
DNU Unit 3 Lesson 6 + 720
-
3.8 Linking and Blending Data in Stories11
-
3.9 Geo Maps + 3.10 Designing Stories w/ Best Practices10
-
Unit 4 Lesson 123
-
Unit 5.1 SAC Add-in for MS10
-
Unit 5 Lesson 25
-
6.1 Discussing Data Modelling38
-
6.2 Accessing Data from SAP Systems14
-
6.2 Accessing Data from SAP Systems (cont)14
-
6.3 Planning28
-
6.4 Explaining Collaboration18
-
6.5 Discussing Augmented Analytics21
-
7.1 Creating Presentations in SAC Digital Boardroom10
-
7.2 SAC Mobile3
-
7.3 Managing Scheduling17
-
8.1 Explaining Security27
-
8.1 Explaining security part 214
-
8.2 Performing Admin Tasks24
-
8.3 Managing Content4
-
3.4 Using Templates and Analyzing with Explorer15
-
3.5 Sorting Data in Stories3
-
3.6 Filtering Data in Stories28
-
3.7 Calculating Data in Stories23
-
1.2 First Steps in SAC4
-
1.11
