Unit 5 Lesson 2

Question 1

5 filter operations that are available

Answer 1

• filter by member
• select all members
• filter by measure
• suppress zeros on rows
• suppress zeros on columns

Question 2

how to add a simple calculation

Answer 2

1. select two measures
2. analysis ribbon, Calculations
3. Add calculation
4. pick from simple calc (add, substract, multiply, divide, % diff, % share)

Question 3

what calculations are not available for SAC connections? (3)

Answer 3

Dynamic calculations

• moving min value
• accumulative sum
• rank number

Question 4

What kind of connection do you use in AO for live SAC models

Answer 4

select Live connections when inserting the datasource in AO

Question 5

what are the basic features of Analysis for Excel (2)

Answer 5

• Filter

- sort