Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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
51
Views
6
Comments
Brian666H
Brian666H Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

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

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 0 - Community Observer

    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 6 - Analytics & AI Lead

    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]
    [Deleted User] Rank 0 - Community Observer

    ¯\_(ツ)_/¯

  • Brian666H
    Brian666H Rank 6 - Analytics & AI Lead

    Thanks for the information.

  • Brian666H
    Brian666H Rank 6 - Analytics & AI 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

  • [Deleted User]
    [Deleted User] Rank 0 - Community Observer

    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.