3. Dimensions & Attributes

Question 1

Which of the below is not considered a dimension?

1. Region dimension with values of North, East, South and West.
2. Cost Centre dimension with values of 10001 Finance, 10002 HR and 10003 Legal.
3. Product dimension with values of Dish Soap, Hand Soap, Floor Cleaner and Antibac Wipes.
4. Customer dimension with values of Retail, Online and Small Business.

Answer 1

2. Cost Centre dimension with values of 10001 Finance, 10002 HR and 10003 Legal. (Cost Centre would be part of the Level structure).

Question 2

Attributes are hierarchical. True or false?

Answer 2

True

Question 3

You can import or enter data into dimension values, but not into attribute values. True or false?

Answer 3

True

Question 4

Attributes are informational tags that you can apply to existing levels, accounts, and dimensions. True or false?

Answer 4

True

Question 5

You can apply attributes to…

1. Levels
2. Accounts
3. Dimension
4. Versions
5. Time

Answer 5

1. Levels
2. Accounts
3. Dimension

Question 6

Dimensions and Attributes can show a blue dot next to their name. What does this mean?

1. Values have been loaded.
2. They are used in sheets, reports or charts.
3. They belong to a Planning version.

Answer 6

2. They are used in sheets, reports or charts.

Question 7

Level and Account attributes can be flat or hierarchical. True or false?

Answer 7

True

Question 8

When importing dimensions via a template, which fields are mandatory?

1. Dimension Name
2. Type
3. Dimension Value
4. Parent

Answer 8

1. Dimension Name
2. Dimension Value

Question 9

Which of the below dimension types can only be a flat list?

1. List dimension
2. Level dimension
3. Hierarchical dimension

Answer 9

1. List dimension

Question 10

Which of the below attribute types can be flat or hierarchical?

1. Level attribute
2. Account attribute
3. Dimension attribute

Answer 10

1. Level attribute
2. Account attribute
3. Dimension attribute

Question 11

Which of the below statements about Level Attributes are true?

1. You can define multiple Level Attributes and assign a single value from each to a level.
2. You can reference Attribute values in formulas.
3. You cannot filter reports and dashboards charts based on Level Attribute values.
4. You can use Level Attributes in cube and modelled sheets.

Answer 11

1. You can define multiple Level Attributes and assign a single value from each to a level.
2. You can reference Attribute values in formulas.
3. You can use Level Attributes in cube and modelled sheets.

Question 12

You can use Dimension attributes in…

1. Formulas
2. OfficeConnect
3. Report calculations
4. Data import

Answer 12

1. Formulas
2. OfficeConnect
3. Report calculations

Question 13

Dimension values and attribute values can have identical names, but the dimensions and attributes themselves cannot. True or false?

Answer 13

True