Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
DVD / Data Sync WID linking column Treat AS Question
Summary
The WID linking columns for the FACT and DIM "Treat As"
Content
Should the WID linking columns for the FACT and DIM tables be Treat As (Measure or Attribute)?
Version
18
Answers
-
Attribute.
The only time you use the WID as a "measure" is when you have fact-less facts and no other way of counting anything else. So each fact row becomes an event "xyz happened".
0 -
Agree it would be an attribute except in the specific case Christian mentioned. I would wonder why you would need to expose the column at all in a data set, especially one that might be shared with other less savvy users.
0 -
¯\_(ツ)_/¯
0 -
Thanks for the information.
0 -
Might any one know how to deal with an empty or null value in the filter I have (ColumnValue = 'D') But when there is no 'D' I get an error. Insufficient Data
0 -
Obvious first answer: Correct the source data :-)
Alternative approach: do a data flow which replaces emptys and nulls with 'N/A' or 'Insufficient data' or the likes.
0