2

AX Adapter: Filter DataArea table entries

The AX adapter's ability to pick which DataAreaID values to bring into the project is really helpful.  Unfortunately, it doesn't work on one important table - the DataArea table.  

We're hoping to use that table as the basis for a company dimension, but it is not properly filtered. All companies/legal entities present in the AX instance show up in this table no matter what. 

While it does not have a DataAreaID field, it is the DataArea table and does have an ID field, which is the ultimate source of all other DataAreaID values in AX.

Workarounds to exclude records from this table are clunky to build or maintain, or have other drawbacks.  It would be really nice if the contents of this table were filtered by the AX adapter as well. 

0 comments

Please sign in to leave a comment.