I recommend several changes to the data mapping. First, import the two columns “folderid” and “folder” as the Folder dimension “Folder” level. Select the ID column and Key column options for the “folderid” column. Then, for the “folder” column, select the Name column option. Similarly, adjust the data import for the rest of the columns that have id and name columns.
To get the Folder->Sub folder relation, I recommend adjusting the data you deliver to eazyBI in a way that the “folderid” and “folder” columns return only parent folders. Then, return Sub-folder ids and names as two separate columns that you map to the Folder dimension “Sub-folder” level. See the suggested data mapping below: