When importing data through Data Explorer, there are mandatory dimensions that need to be mapped. These are indicated with the red box highlighting the fields in the Import Wizard.
In the screenshot below, an example of the mandatory mappings of the General Ledger (GL) is shown.
If the amount field is left blank or there is a zero value in the field, it will show up as blank when the query is ran in the Data Explorer field.
Applies To: Data Warehouse Manager
what are the red boxes