In this data model we have 2 fact tables holding the numbers we would like to analyze and 2 dimension tables that hold unique employee IDs and unique dates.
What does this data model support?
- You can analyze any number from Absence numbers and Invoices by Dates
- You can analyze any number from Absence numbers from Employees
- You CAN'T analyse numbers from Invoices by Employees
- You CAN't use any autogenerated measures from either data table or Employees at all
(you should hide those using attribute settings) - You CAN'T use and autogenerated dimensions from either Absence numbers or Invoices
(you should hide those using attribute settings)
To use attribute settings - click the 3 lines on a table and choose attribute settings:
Now clean up (in this case a fact table) all the auto generated dimensions:
And for a dimension table:
Then you are sure to avoid problems later on.
Comments
Please sign in to leave a comment.