What does a data model in Data Discovery support - and what does it NOT support

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.

mceclip0.png

 

What does this data model support?

  1. You can analyze any number from Absence numbers and Invoices by Dates
  2. You can analyze any number from Absence numbers from Employees 
  3. You CAN'T analyse numbers from Invoices by Employees
  4. You CAN't use any autogenerated measures from either data table or Employees at all 
    (you should hide those using attribute settings)
  5. 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:

mceclip1.png

 

Now clean up (in this case a fact table) all the auto generated dimensions:

mceclip3.png

 

And for a dimension table:

mceclip4.png

 

Then you are sure to avoid problems later on.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.