How to create a simple Fact Schema

Home Forums BI Modeler – How to How to create a simple Fact Schema

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #36
    Stefano
    Keymaster

    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 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 7 months ago by Stefano.
    • This topic was modified 6 years, 6 months ago by Stefano.
    • This topic was modified 6 years, 6 months ago by Stefano.
    • This topic was modified 6 years, 6 months ago by Stefano.
    • This topic was modified 6 years, 6 months ago by Stefano.
    • This topic was modified 6 years, 6 months ago by Stefano.
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.