The animation shows how to create a simple Fact Schema (2 measures + 1 simple Hierarchy) following these steps:
- Create a new empty Fact Schema titled “Sales”
- Create two new measures titled “Revenue” and “Units sold”
- Create a new dimensional attribute titled “Day”
- Link the Fact Schema to the dimensional attribute to create a Hierarchy that has “Day” attribute as dimension
- Create a new dimensional attribute titled “Month”
- Add the attribute “Month” in the “Day” hierarchy
- Create a new dimensional attribute titled “Year”
- Add the attribute “Year” in the “Day” hierarchy
- Rename the hierarchy “Day” in “Time”
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
-
This topic was modified 9 years, 1 month ago by Stefano.
