3.7 Calculating Data in Stories

Question 1

what is the calculation editor

Answer 1

• allows you to create calcs for a chart or table

Question 2

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

Answer 2

1. Account

2. cross calculations dimension

Question 3

Can a dimension attribute be used in a calculation

Answer 3

yes

Question 4

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

Answer 4

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

Question 5

how do you add a currency conversion (2)

Answer 5

• for the model, enable currency conversion

- add currency conversion using cross calculations

Question 6

2 new options for calculations in the new model

Answer 6

• create calculated measures in the model, to share across stories
• in stories, calcs can be created on account and measures

Question 7

Calculated measures do not allow you to perform mathematical operations (tf)

Answer 7

false

Question 8

Calculated measures do not allow you to perform boolean operations (tf)

Answer 8

false

Question 9

What calculation type does BW/Universe Live models not support

Answer 9

Dimension calculations

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

how do you display a list of possible formulas (shortcut keys)

Answer 12

CTRL + Space bar

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

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

Answer 15

Measure-based calculated dimension

Question 16

what is a measure-based calculated dimensions

Answer 16

• lets you create a new calculated dimension that defines the criteria for the dim members (eg, rank based on sales)

Question 17

when do you use a cross calculation

Answer 17

• when you have a dimension in the columns and the rows of a table (eg, Version is in the columns and Product in the rows)

Question 18

why is it called a cross calculation

Answer 18

it lets you calculate accross multiple members of a dimension

Question 19

what is an asymmetric report (2)

Answer 19

• when a restricted measure is applied across accounts

- accounts are in rows, so account dim can’t be used to calculate variance

Question 20

Steps to create a cross calculation (eg, for a Plan/Actual variance)

Answer 20

1. in Builder, enable cross calcs
2. Add calculation (1 measure 2 dims)
3. Measure will be “Account Values”
4. Add both dims (Date, Version) and select values

Question 21

What calc do you use for a rolling forecast layout

Answer 21

Forecast Layout Crosstab (not cross calc)

Question 22

Can you use column/row numbers to create table formulas like in excel?

Answer 22

yes - they aren’t displayed but you can use them

Question 23

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

Answer 23

• on the fly, excel like formulas.

- Add a column and add the calculation