Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DVD / Data Sync WID linking column Treat AS Question

Received Response
31
Views
6
Comments

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

  • Doug Ross
    Doug Ross Rank 5 - Community Champion

    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.

  • ¯\_(ツ)_/¯

  • Brian666H
    Brian666H Rank 6 - Analytics Lead

    Thanks for the information.

  • Brian666H
    Brian666H Rank 6 - Analytics Lead

    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

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