Oracle Analytics Forum

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

Categories

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

DVD not picking up Excel columns as measures by default?

Received Response
42
Views
2
Comments
jepva
jepva Rank 5 - Community Champion
in Oracle Analytics Forum

Summary

DVD not picking up Excel columns as measures by default?

Content

Importing Excel files into DVD and it is not picking up the value columns as measures automatically.  We have to right click for each value field and tell DVD it is a measure, this is a pain when your workbook might have 10+ measures.  Why is not picking up value/number formatted columns as measures automatically?  Is this a known issue or issue with the excel workbook?

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics & AI Lead

    Hi,

    In my experience all numeric columns were treated like measures automatically.

    Maybe you have some strange formatting?

  • Satya Surisetti
    Satya Surisetti Rank 2 - Community Beginner

    I am having similar issue while loading data through xlsx file. I tried changing the format of data in excel to number and general, still no luck, DVD reads the data type as integer and Treat it as "Attribute". I am assuming if DVD can read the column as data type Integer it should automatically show as measure instead of attribute.

    I need to manually change it to measure to make it work. Looks like it is a bug.

    If you know of any changes to be done in excel before loading, let me know and i will give a try.

    Rgds

    Satya