3.7 Calculating Data in Stories Flashcards
what is the calculation editor
- allows you to create calcs for a chart or table
In a table, what can you apply calculations to (2)
- Account
2. cross calculations dimension
Can a dimension attribute be used in a calculation
yes
In a chart, what are the calculation types supported (4)
- Calculated measures
- Restricted measures
- Difference from
- Currency conversion
how do you add a currency conversion (2)
- for the model, enable currency conversion
- add currency conversion using cross calculations
2 new options for calculations in the new model
- create calculated measures in the model, to share across stories
- in stories, calcs can be created on account and measures
Calculated measures do not allow you to perform mathematical operations (tf)
false
Calculated measures do not allow you to perform boolean operations (tf)
false
What calculation type does BW/Universe Live models not support
Dimension calculations
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
how do you display a list of possible formulas (shortcut keys)
CTRL + Space bar
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
What type of calculation would you use to group dimensions based on a measure (eg, rank based on sales)
Measure-based calculated dimension
what is a measure-based calculated dimensions
- lets you create a new calculated dimension that defines the criteria for the dim members (eg, rank based on sales)
when do you use a cross calculation
- 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)
why is it called a cross calculation
it lets you calculate accross multiple members of a dimension
what is an asymmetric report (2)
- when a restricted measure is applied across accounts
- accounts are in rows, so account dim can’t be used to calculate variance
Steps to create a cross calculation (eg, for a Plan/Actual variance)
- in Builder, enable cross calcs
- Add calculation (1 measure 2 dims)
- Measure will be “Account Values”
- Add both dims (Date, Version) and select values
What calc do you use for a rolling forecast layout
Forecast Layout Crosstab (not cross calc)
Can you use column/row numbers to create table formulas like in excel?
yes - they aren’t displayed but you can use them
What is a table formula, and when do you use it
- on the fly, excel like formulas.
- Add a column and add the calculation
