Oracle Analytics and AI

DVD / Data Sync WID linking column Treat AS Question

Brian666H

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

Find more posts tagged with

Reporting

Tips & Tricks

Packaging and Licensing

Administration

Accepted answers

All comments

[Deleted User]

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".

Doug Ross

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.

[Deleted User]

¯\_(ツ)_/¯

Brian666H

Thanks for the information.

Brian666H

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

[Deleted User]

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.