You plan to populate a predefined Currency dimension with data stored in a Microsoft Office Excel file. The file has an XLSX extension. You discover that the Load Members wizard is unable to load the XLSX file. You need to ensure that the Load Members wizard can load data from the XLSX file. What should you do?
A.
Save the Excel file as a comma-separated value (CSV) file. Ensure that the Label column is the first column in the file.
B.
Save the Excel file as a comma-separated value (CSV) file. Ensure that the Name column is the first column in the file.
C.
Create a System DSN (data source name) connection to the XLSX file. Ensure that the Symbol column is the first column in the file.
D.
Create a System DSN (data source name) connection to the XLSX file. Ensure that the Name column is the first column in the file.