DVD not picking up Excel columns as measures by default?

Question

Summary

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?

Satya Surisetti · Answer

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

FTisiot · Answer

Hi,

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

Maybe you have some strange formatting?