Filtering data with data model parameters
Data Modeling in Sigma
Ben Harris
Technical Instructional Designer at Sigma
Concept - What are parameters
- Parameters are control elements
- Can be controlled from outside the data model
Concept - What are parameters
- Simple example next
Concept - What are parameters
- Base table: transactions
- Users often filter by dollar range (e.g. amount > 1000)
Concept - What are parameters
- Without parameters, this is hard in a data model
- Consider options that don't use a parameter
Concept - What are parameters
- Filter on table → model only works for that range
- Users want another range or custom range? Not scalable
Concept - What are parameters
- Give full table → users filter manually each time
- Flexible but: consistency and efficiency problems
- Different ranges, fields, defaults
Concept - What are parameters
