DNU Unit 3 Lesson 4 + 5 Flashcards
what 2 modes does Explorer have
- Data exploration (suggests visuals for data)
2. Data manipulation (simple data prep, like saying which column is a measure)
Explain what explorer is
start creating a story by experimenting with filters and charts through Explorer.
Create a new view of a char/table and add it to the story or replace the original.
When you save an explorer view, where is it stored
Yes, you can store them with the story.
In a table, what can you apply calculations to (2)
- Account
2. cross calculations dimension
Can a dimension attributed by used in a calculation
yes
In a table, what is created when you create a new calculation
- calculated member for dimension used to create it
2. restricted member for dimension used to create it
In a chart, can a calculation based on an account dimension be added as a new measure
Yes
In a chart, what are the calculation types supported (4)
- Calculated measures
- Restricted measures
- Difference from
- Currency conversion
What is a limitation of the new model and cross calcs
you cant do a cross-calculation in a story when using the new model
If using a BW/Universe model, what are the options when adding calculations in the story:
- calculated measure
- restricted measure
- aggregation
Which model types gives all options for adding calculations:
Live model based on Hana calc views
Can you use IF functions in the calculation editor
Yes
How do you calculate YoY
- Create a Difference From calculation type
2. Compare Current Period to Previous year
what are calculated dimensions used for (3)
- concatenate members
- group dimensions
- create dimensions based on thresholds
How do you group dimensions (eg, cities into provinces) using Calculated Dimensions
Use an IF statement - IF Regina THEN Saskatchewan - creating a new column
What type of calculation would you use to group dimensions based on a measure (eg, rank based on sales)
Measure-based calculated dimension
When is it best to use a cross calculation
when you have 2 measures and you want to compare the difference in data
What is a cross calculation (2)
-a measure that is created based on a mathematical formula
-a calc that’s applied across accounts
- results of the calc will apply across all dimensions of the model
EG, plan vs actual variance
What do you need to do before creating a cross calculation
Enable cross calculations in the Builder pane > Dimensions > Cross calculations
What is a table formula, and when do you use it
- on the fly, excel like formulas.
- Add a column and add the calculation
