Task 1: Use Excel to add hierarchies to a public dimension
You need to create a public dimension that will be used multiple models. You have all of your hierarchy information in an Excel file and need quickly add them to your dimension.
In this practice exercise, you will perform the following tasks:
- Create a public dimension
- Add properties to the dimension
- Use Excel to add hierarchies to the dimension