Data not visible

Hi @Marc ,

Did you run the synchronize task after changing the RSD files? This ensures the new columns are detected.

After running the synchronize task, you need to synchronize the ODX Server (right-click ODX Server → Synchronize Objects). Once it is synced, the new columns should be visible in the data warehouse layer as well.

Hi @bas.hopstaken, synchronize task have been executed. Columns are visible however data fields are empty and missing data.

Thanks. 

Fields that appear empty while existing in the RSD file can be due to two things.

1. The XPath in the field descriptor points incorrectly to the field making it appear empty
2. The JSONPath setup does not point to the right level hence it can’t find the data.

This <api:set attr="JSONPath" value="$." /> is the default JSONPath for most RSD files, but it can be that it is on a lower level that the data exists. You can change the Data Model setup before generating the file to see how it affects this. If it is set to FlattenedDocuments it can aggregate more than one setup in this field using a ; to separate each setup.

Hi,

additionally if the table you are loading into is incremental or a history table, it won't populate new fields unless new records are loaded in. You may get more information if you set the verbosity on the logging to level 3 and verify that the raw data is being loaded from source.

Hi @Marc have you had a chance to try the suggestions above?