Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Measure issues over data model

I am unable to create a calculation of how many hours a team is working on a project (based on the Cap Ex, Op Ex and Un Cat %) and therefore can't calculate cost. Monthly Networking allows me to...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  - The issues start with the model - You will need to separate dimension and fact tables. For example, you will need a separate Date and Scrum Team dimension tables. Then you can create relevant 1-many relationships between dimension and fact tables. 

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks I understand the dim vs fact table. Our data is just complex so it's not easy to simplify the data down 1-many relationships between dimension and fact tables

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes, data modelling can be difficult, but complexity necessitates a dimensional model.