DNU Unit 3 Lesson 4 + 5

Question 1

what 2 modes does Explorer have

Answer 1

1. Data exploration (suggests visuals for data)

2. Data manipulation (simple data prep, like saying which column is a measure)

Question 2

Explain what explorer is

Answer 2

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.

Question 3

When you save an explorer view, where is it stored

Answer 3

Yes, you can store them with the story.

Question 4

In a table, what can you apply calculations to (2)

Answer 4

1. Account

2. cross calculations dimension

Question 5

Can a dimension attributed by used in a calculation

Answer 5

yes

Question 6

In a table, what is created when you create a new calculation

Answer 6

1. calculated member for dimension used to create it

2. restricted member for dimension used to create it

Question 7

In a chart, can a calculation based on an account dimension be added as a new measure

Answer 7

Yes

Question 8

In a chart, what are the calculation types supported (4)

Answer 8

1. Calculated measures
2. Restricted measures
3. Difference from
4. Currency conversion

Question 9

What is a limitation of the new model and cross calcs

Answer 9

you cant do a cross-calculation in a story when using the new model

Question 10

If using a BW/Universe model, what are the options when adding calculations in the story:

Answer 10

1. calculated measure
2. restricted measure
3. aggregation

Question 11

Which model types gives all options for adding calculations:

Answer 11

Live model based on Hana calc views

Question 12

Can you use IF functions in the calculation editor

Answer 12

Yes

Question 13

How do you calculate YoY

Answer 13

1. Create a Difference From calculation type

2. Compare Current Period to Previous year

Question 14

what are calculated dimensions used for (3)

Answer 14

• concatenate members
• group dimensions
• create dimensions based on thresholds

Question 15

How do you group dimensions (eg, cities into provinces) using Calculated Dimensions

Answer 15

Use an IF statement - IF Regina THEN Saskatchewan - creating a new column

Question 16

What type of calculation would you use to group dimensions based on a measure (eg, rank based on sales)

Answer 16

Measure-based calculated dimension

Question 17

When is it best to use a cross calculation

Answer 17

when you have 2 measures and you want to compare the difference in data

Question 18

What is a cross calculation (2)

Answer 18

-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

Question 19

What do you need to do before creating a cross calculation

Answer 19

Enable cross calculations in the Builder pane > Dimensions > Cross calculations

Question 20

What is a table formula, and when do you use it

Answer 20

• on the fly, excel like formulas.

- Add a column and add the calculation