Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
31
Views
6
Comments
Brian666H
Brian666H Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

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

  • Christian Berg -Oracle
    Christian Berg -Oracle Mod

    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.

  • Christian Berg -Oracle
    Christian Berg -Oracle Mod

    ¯\_(ツ)_/¯

  • 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

  • Christian Berg -Oracle
    Christian Berg -Oracle Mod

    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.