The article provides information on the mandatory dimensions when importing data.
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.
- Data Warehouse Manager