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.