Quite often current data entities don’t contain all fields from the base table (for example LedgerJournalTrans table contains 200 fields, but data entity LedgerJournalLineEntity contains only 40 fields)
And that can cause a problem, because very often client wants to use some fields that are not exists in data entity and this is not possible without development.
Can you change this behaviour – by default add all fields from the base table into the data entity
Comments
this one is so important as sometimes even if you have got a data entity but when the required filed is missing, it is of no use.
Category: Data Management
Most Finance professionals do not have the knowledge and time to consume and maintain data with more advanced tools, but there're more and more new reporting requirements. Often there's not enough time to seek help from technical team to update / build everything. Improving the ability to retrieve and upload data out of data entities will also significantly improve super user experience.
Category: Data Management
To achieve the same, we need to extend the data entity. Microsoft can think to provide option to add fields in the Staging and Target tables functionally (without development) and through mapping we will be able to upload data/update data to our customized fields or un-mapped fields.
Category: Data Management
For datawarehouse integration I would recommend the option to sync the original source tables and all fields to BYOD. Just 1:1, so that the raw data can land/staged in the datawarehouse. It also makes the incremental load (track changes) must easier since it is only one table so the primary key is much clearer then data entities that are denormalized.
Category: Data Management
Additional requirement for this idea- it will be also nice to allow use data management even if data entity doesn't exist(with field mapping 1 to 1 to original table)
Category: Data Management
Also default WMSlocations are missing in entity Warehouses.
In case vendor or customer warehouse are necessary and many, manual update is huge
Category: Data Management
I second Herre's comment, think of sales table, retailsalestable, mcrsalestable...
Category: Data Management
For Legerjournallines there is also the requirement to have some fields from additional tables, such as CorrectedTaxAmount as this is a frequent requirement and for a customers seems to be in the same table.
Category: Data Management